Can we change the name of the instance ..

Can we change the name of the instance (SomeSQLInstance1, Some SQLInstance2) to be "SomeSQLStdInstance" while upgrading to SQL 2005 from MSDE 2k or SQL 2000?

Yes. You can change the name of an instance as long as the server is not clustered. For more information, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

Thanks

|||

hi,

Rubal Jain wrote:

Yes. You can change the name of an instance as long as the server is not clustered. For more information, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

the feature you reported is only able to resync the server name to a SQL Server instance and not to just "rename" an installed instance..

if you installed a local named instance of SQLExpress, usually named (Local)\SQLExpress, you can not rename it to (Local)\AndreaSQLX or the like...

to "rename" an instance you have to uninstall it and reinstall it..

regards