MSSQLTips

Hey,

 I have a query related to both MS-SQL Server 2000 and 2005. I have SQL Server 2000 Database installed on one machine and SQL Server 2005 on another machine. Can i name both of the instances has THI-SQL ?? as this is my First Database Instance name and i want the SQL 2005 to be on the same name.

 Can i do that

Shrry8,

You could name both instances the same, but the server names would have to be different if they are in the same domain which is a function of Windows not SQL Server.  For example this is possible:

• ServerA\THI-SQL
• ServerB\THI-SQL 

Thank you,
The MSSQLTIps.com Team