I want to change my SQL Server's name.
Currently I am connecting to
SERVER1 is the machine name. I want to change it so I could connect to
SERVER2\SQLSERVER and keep
SERVER1 as the machine name.
sp_dropserver 'SERVER1\SQLSERVER' sp_addserver 'SERVER2\SQLSERVER', local
Then I restarted the server.
If I verify I get the new server name:
Looks like the name was changed but i cant connect to
SERVER2\SQLSERVER while the
SERVER1\SQLSERVER connection still works.
What am I missing here ... and is this even possible?