Technology Reviews and How To's
Wednesday, January 15, 2014
Configure SQL after change computer name
After changing the computer name for a machine that has a SQL installed there is some additional step required:
1- select @@servername
> to view the current server name
2- sp_dropserver "Old_Server_Name"
> to remove the old server name
3- sp_addserver "New_Server_Name", local
> to add the new server name
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment