Server Name Incorrect!
From: Jason (someone_at_microsoft.com)
Date: 02/15/05
- Next message: Alejandro Mesa: "RE: How to speed up my update process"
- Previous message: Alejandro Mesa: "RE: Is it possible to access query designer through an interface?"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Server Name Incorrect!"
- Reply: Mike Epprecht (SQL MVP): "RE: Server Name Incorrect!"
- Reply: Tibor Karaszi: "Re: Server Name Incorrect!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 10:39:45 -0500
We got a new database server (also a Win2003 domain server). Got the
databases over there fine, up and running fine. Ultimately we named it the
same as the previous server to simplify some of our processes. That worked
fine too, and it can be referenced on our intranet as "Server" via SQL,
Windows, etc.
HOWEVER, some processes mysteriously don't work, like Agent-driven backups,
etc. Ultimately we determined that in the Master database, the 'sysservers'
table refers to the server as "TempServer" (the temporary name we assigned
while setting everything up). How do we change the name in the system table
so that the new name applies and the temporary name is totally gone??? I
assume there's some SP but I'm not sure. Thanks.
- Next message: Alejandro Mesa: "RE: How to speed up my update process"
- Previous message: Alejandro Mesa: "RE: Is it possible to access query designer through an interface?"
- Next in thread: Mike Epprecht (SQL MVP): "RE: Server Name Incorrect!"
- Reply: Mike Epprecht (SQL MVP): "RE: Server Name Incorrect!"
- Reply: Tibor Karaszi: "Re: Server Name Incorrect!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
