Re: Server Name Incorrect!
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/15/05
- Next message: John Kane: "Re: Freetext Search with Parameter"
- Previous message: Mike Epprecht (SQL MVP): "RE: Server Name Incorrect!"
- In reply to: Jason: "Server Name Incorrect!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 16:49:03 +0100
See sp_dropserver and sp_addserver (using the LOCAL) option. You might also want to read:
http://www.karaszi.com/SQLServer/info_change_server_name.asp
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Jason" <someone@microsoft.com> wrote in message news:OAHXUS3EFHA.936@TK2MSFTNGP12.phx.gbl... > 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: John Kane: "Re: Freetext Search with Parameter"
- Previous message: Mike Epprecht (SQL MVP): "RE: Server Name Incorrect!"
- In reply to: Jason: "Server Name Incorrect!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
