What is the correct way to change the name of server
running SQL 7.0?
Changing the name and running setup seems to work but does
that cause other problems?You also need to run the following after running setup
use master
go
exec sp_dropserver 'old name'
go
exec sp_addserver 'new name','local'
If SQL Server is configured to listen on either the Multiprotocol or NWLink
IPX/SPX network libraries, you'll need to remove them, and then add them
back using the SQL Server Network Utility.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Andrew Buschbom" <anonymous@.discussions.microsoft.com> wrote in message
news:0d9401c3dab8$e0ec3540$a401280a@.phx.gbl...
> What is the correct way to change the name of server
> running SQL 7.0?
> Changing the name and running setup seems to work but does
> that cause other problems?|||Hi,
For SQL 7 , after changing the server name , you need to ,
1. Run the SQL 7 setup , it automatically recognise the server name change
and will update the registry
2. Start SQL server and then login to Query analyser and execute
a. sp_dropserver <oldserver name>
b. sp_addserver <newserver name>,LOCAL
3. Restart SQL server service
Thanks
Hari
MCDBA
"Andrew Buschbom" <anonymous@.discussions.microsoft.com> wrote in message
news:0d9401c3dab8$e0ec3540$a401280a@.phx.gbl...
> What is the correct way to change the name of server
> running SQL 7.0?
> Changing the name and running setup seems to work but does
> that cause other problems?|||The procedure is explained here:
http://vyaskn.tripod.com/administration_faq.htm#q5
You'll have to amend all applications, so that they connect with the correct
name. Do you have replication in place?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Andrew Buschbom" <anonymous@.discussions.microsoft.com> wrote in message
news:0d9401c3dab8$e0ec3540$a401280a@.phx.gbl...
What is the correct way to change the name of server
running SQL 7.0?
Changing the name and running setup seems to work but does
that cause other problems?|||Thanks for the reply.
Named pipes is the only protocol used.
>--Original Message--
>You also need to run the following after running setup
>use master
>go
>exec sp_dropserver 'old name'
>go
>exec sp_addserver 'new name','local'
>If SQL Server is configured to listen on either the
Multiprotocol or NWLink
>IPX/SPX network libraries, you'll need to remove them,
and then add them
>back using the SQL Server Network Utility.
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"Andrew Buschbom" <anonymous@.discussions.microsoft.com>
wrote in message
>news:0d9401c3dab8$e0ec3540$a401280a@.phx.gbl...
>> What is the correct way to change the name of server
>> running SQL 7.0?
>> Changing the name and running setup seems to work but
does
>> that cause other problems?
>
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment