SQL Server Performance Forum – Threads Archive

SQL 2005 instance remane?

I am thinking of doing a 1 box upgrade of SQL 2000 to SQL 2005. Instead of "upgrading" the SQL 2000 instance, I was going to install SQL 2005 on the same server (as a named instance on another port) and then we could migrated the databases, logins, etc. as we are ready. Once we are done with the migration, I would like to uninstall SQL 2000 and then put SQL 2005 on the default SQL port. Is there any way to change the named SQL 2005 instance to a default SQL 2005 instance? I would just like to be able to keep all pre-migration configuration strings the same (default name and port). Thanks, Matt

Hi, refer below thread discussed earlier : http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11541</a> <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> HTH Regards

I wouldn’t change the 2005 instance to a default instance OR the default port. Matter of fact, I would never even use those two things in the first place. For optimal security, just leave the named 2005 instance on a non-standard port as your final installation. You will have accomplished a migration and a little bit better security. After you’re done with the migration, contact your network guys and "harden" the server access at the network layer. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

After you uninstall the SQL 2000 instance, use SQL Server Configuration Manager to change the port your named 2005 instance listens on. Don’t bother trying to change the name.

Thanks everyone for the information. I changed the port in the config manager. I also tried to rename the server (this is a lab environment and I am just doing a test). I did the following
1. sp_dropserver ‘servernamesql2’
2. sp_addserver ‘servername’
3. Reboot the machine I attempted to then register the server locally and it does not reconize the SQL instance as the default instance. I can still only register with servernamesql2. Once I do register using the old sql2 name, select @@version shows shows ‘servername’ without the named instance reference. I verified I do not have any aliases that would be pointing to the old name. Interesting that I have found in books online that you can rename an Analysis Server instance using a tool named asinstancerename.exe. I guess I am stuck changing connection strings to use the named instance…

oops, I did sp_addserver ‘servername’, local for step 2.

Don’t use the instance name in your connection strings, use a DNS alias poiting to the IP address.

Why? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Easier management.

]]>