 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / November 2006Can you have two SQL instances with the same on the same cluster?
Hello I have Windows 2003 SP1 64-bit (enterprise) on two servers. I've installed MSCS, and am ready to start installation of SQL 2000 and SQL 2005. We are currently migrating from an existing SQL 2000 cluster to this 'new' cluster. I'm installing both SQL2000 and 2005 on the same cluster to make our migration as simple as possible (when we're ready to go to SQL 2005) by avoiding installing SQL 2005 on an already live SQL 2000 system. If I install 3 instances, I'll have the following: 1 SQL 2000 instance (live) 2.SQL 2005 instance (future live) 3.SQL 2005 instance (another instance for other purposes - again future live) My question: Can I install two of these instances with the same INSTANCE NAME? Example SQL2005VIRTUALSERVER1\SQLINSTANCE SQL2005VIRTUALSERVER2\SQLINSTANCE TIA! No, Instance names must be unique on the server.  SignatureArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf > Hello > [quoted text clipped - 24 lines] > > TIA! oops, sorry Arnie, didn't see your response before I posted > No, Instance names must be unique on the server. > [quoted text clipped - 26 lines] > > > > TIA! Thanks to all for the info!! > oops, sorry Arnie, didn't see your response before I posted > [quoted text clipped - 41 lines] > > > > > > TIA! Not a problem... SignatureArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf > oops, sorry Arnie, didn't see your response before I posted > [quoted text clipped - 32 lines] >> > >> > TIA! you need to choose unique names for your instances rgds, Edwin. > Hello > [quoted text clipped - 24 lines] > > TIA! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.