Tech

Guides
 

Changing the name of your SQL server

By Steven Warren, Special to ZDNet Asia
Thursday, August 28, 2008 01:17 PM
When you change the name of a server you also have to change the name in SQL Server; if you don't, there may be problems.

Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server?

Here are the steps to perform the change:

1. Open SQL Server Management Studio and click New Query.

2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from WIN2K3R2EE to SQL Server.

I did not change the name in SQL Server 2005. It will still return the old name. Let's fix it.

3. Next, type sp_dropserver ‘WIN2K3R2EE’

4. You are now ready to add the correct name by typing sp_addserver ‘SQLSERVER’. local

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.

6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.



WORTHWHILE?

2

2 votes
Blog

Talkback 0 comments

There are currently no comments for this post.


Guest user

Guest user

Level: 
Joined: —
Already a member? Log in »



 

Loading...

Emergency excitement online

Blog thumbnail

Video game Zero Hour: America’s Medic lets responders try out real-time strategies in hazardous virtual environments, with sound effects and human conversations, just like those in the hugely-popular Halo..... by Nathaniel Forbes

Read more »

Whitepapers / Case Studies

Downloads

Enterprise Servers & Storage News


Tech Jobs Now!

Tags

  1. advertisement
  2. apple iphone
  3. blog
  4. china
  5. google inc.
  6. industry
  7. information technology
  8. internet
  9. microsoft corp.
  10. mobile
  11. network
  12. phone
  13. revenue
  14. security
  15. software
  16. strategy
  17. team
  18. u.s.
  19. web
  20. yahoo! inc.