June 10, 2013 at 5:57 am
So I am a newb.... I have a database system that uses SQL 2005. The server that these systems reside on were migrated to an Active Directory domain. Most of that process involved changing the name of the server from what the vendor named it to what my company wants it called. After migrating the system it functioned well however there is one persistant problem that the vendor and I can not fix. Because of our companies security policy the vendor no longer has remote access so I am doing most of the local support. However sql is not my subject of expertice.
My Database is getting an error that tells me {Microsoft}{ODBC SQL Server Driver}{SQL Server} Could not find server 'xxxxxxxx' in sys.servers.
It then recomends to run the sp_addlinkedservers proceedure to add the server.
Since this was running fine prior to the migration to AD, I beleive the server just needs to be renamed.
So I ran the pstored proceedure "sp_linkedservers" to see what server is linked and of course it comes up with an old server name. How can I rename this server"
June 10, 2013 at 6:10 am
please check out the procedure described at msdn: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005 : http://msdn.microsoft.com/en-us/library/ms143799%28v=sql.90%29.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 11, 2013 at 5:19 am
Thanks, but the computer was long since renamed. I am asking how to rename the computer name listed in linkedservers... It still shows the old computer name...
June 11, 2013 at 5:36 am
Drop the existing linked server and recreate it with the proper servername. Before deleting the current linked server you could first script it out (right click linked server, script linked server as, create to, new query editor window) and then change the servername in the generated script.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy