|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Changed Server Name
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Changed Server Name
|
|
| Dean Beckley 2002-11-21, 12:24 pm |
| Setting up a test environment, I used an existing box with
SQL Server 2000 installed. I changed the machine name for
continuity in my test environment. SQL Server works
correctly, but I notice that in the master.sysservers, the
svrname is my old machine name.
The problem is that I've got an app that wants to set up
replication and it's not working correctly. I think it's
because of this issue in the sysservers table. Is there a
way to update these values or do I need to re-install SQL
Server to get the job done?
Thanks,
Dean
| |
| Geoff N. Hiten 2002-11-21, 1:24 pm |
| Exec sp_dropserver 'OldServername'
Exec sp_addserver 'NewServerName', 'Local'
Stop and restart your SQL service.
Select @@servername will now show the new server name
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Dean Beckley" <dean@omegagroup.com> wrote in message
news:e41a01c29185$14f873e0$8df
82ecf@TK2MSFTNGXA02...
> Setting up a test environment, I used an existing box with
> SQL Server 2000 installed. I changed the machine name for
> continuity in my test environment. SQL Server works
> correctly, but I notice that in the master.sysservers, the
> svrname is my old machine name.
>
> The problem is that I've got an app that wants to set up
> replication and it's not working correctly. I think it's
> because of this issue in the sysservers table. Is there a
> way to update these values or do I need to re-install SQL
> Server to get the job done?
>
> Thanks,
> Dean
| |
| Dean Beckley 2002-11-21, 1:24 pm |
| Geoff,
Bingo! Thanks for the help! I tried BOL before I posted,
but couldn't find it...now have found it under Renaming a
Server.
Thanks again,
Dean
>-----Original Message-----
>Exec sp_dropserver 'OldServername'
>Exec sp_addserver 'NewServerName', 'Local'
>
>Stop and restart your SQL service.
>
>Select @@servername will now show the new server name
>
>--
>Geoff N. Hiten
>Senior Database Administrator
>Careerbuilder.com
>
>
>
>"Dean Beckley" <dean@omegagroup.com> wrote in message
> news:e41a01c29185$14f873e0$8df
82ecf@TK2MSFTNGXA02...
>> Setting up a test environment, I used an existing box
with
>> SQL Server 2000 installed. I changed the machine name
for
>> continuity in my test environment. SQL Server works
>> correctly, but I notice that in the master.sysservers,
the
>> svrname is my old machine name.
>>
>> The problem is that I've got an app that wants to set up
>> replication and it's not working correctly. I think
it's
>> because of this issue in the sysservers table. Is
there a
>> way to update these values or do I need to re-install
SQL
>> Server to get the job done?
>>
>> Thanks,
>> Dean
>
>
>.
>
|
|
|
|
|