PDIS
asked on
Renaming Sql Server
Cloned a sql database server for testing. Renamed the physical server name to dev. The SQL Server still has the name of the live server, how do I rename it to Dev? Microsoft Server 2008 R2 with SQL Server 2008 R2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When I ran that command, it came back with an error, Cannot drop server 'oldservername' because it is used a Publisher in replication.
On the test server I went into Replications - Local Publications and deleted all entries there but I still receive the same error. Please advise if I should open this a new question.
On the test server I went into Replications - Local Publications and deleted all entries there but I still receive the same error. Please advise if I should open this a new question.
ASKER
(1 row(s) affected)
Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 56
There are still remote logins or linked logins for the server 'oldservername'