Reputation: 2476
in SQL Server 2014, i used the "sp_addserver" procedure, and then used the @@ServerName, and got my new name right.
but in the SQL Management Studio's Login page, i still have to enter the old servername, and i can't drop that server because it says it does not exist.
the old server name was written servername\instansename, i don't know why it was like that, and whenever i need to login, i have to use that full servername.
why is the login name still haven't changed?
Upvotes: 0
Views: 1096
Reputation: 7344
It isn't going to happen without some extra work outside of SQL Server. The ServerName\InstanceName pair are:
You can change the name of the server, but you'll probably need to be a domain admin to do so (as DNS will need to be updated). Remember, you can substitute the IP Address of the server for the ServerName: it's identifying a machine (which can host no or multiple instances of SQLServer), plus the Instance you want to connect to.
Upvotes: 1