SQL Server cannot find server in sys.servers after I renamed the machine.
Posted on 2008-06-25
I renamed my laptop which has a copy of SQL Server 2005 running on it. When I rebooted after renaming the machine I tried running an app which uses the ODBC connection to the SQL Server database and received the following error:
Error -2147467259 Could not find server 'MyNewName' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sysy.servers
I've had this error before when I renamed another comuter but never wrote down the extremely simple solution which if I remember involved the following very easy steps:
running exec sp_addlinkedserver (you'll need to very expliciitly explain the parameters assuming my new machine name is 'MyNewName' etc...I don't know enough about SQL Server!)
selecting from a system table to see two entries (presumably the entry for my oldname and one for the newly added newname with some other fields)
deleting the oldname entry from said system table.
If your answer isn't this simple it probably isn't the answer! Max points too cos it's very very very urgent
Thanks loads in advance