Renaming a Server

[snewell2003 via SQLMonster.com]

Hello

I am wondering if this is able to be done and what implications there would
be with SQL Server.

Server1 name: Production Currently running Windows NT and SQL 7
instance name is Production
Server2 name: Test Currently running Windows 2000 and
SQL 2000, instance name is Test - default installation

Bring the Server1 offline and rename Server 2 with the name of Production.
Do we have to change the instance name in SQL now on Server 2? If so can we
do this? I didn't think you could change a instance name and had to
reinstall SQL.

Another Question:

Can you have 2 instances of SQL with the same name but reside on different
servers?

Thanks
Sher

[Alwik]

Hi

[cut]

Another Question:

Can you have 2 instances of SQL with the same name but reside on different
servers?

Yes, you can have instance1 on server1 and server2 - you always connect to
any of them specifying full name: server1/instance1 or server2/instance1.

Tomik

[Erland Sommarskog]

snewell2003 via SQLMonster.com (fo***@SQLMonster.com) writes:

I am wondering if this is able to be done and what implications there
would be with SQL Server.

Server1 name: Production Currently running Windows NT and SQL 7
instance name is Production
Server2 name: Test Currently running Windows 2000
and SQL 2000, instance name is Test - default installation
Is that Test\Test or just Test? Production is obviously not
Production\Prodction as there are no named instances on SQL 7.
Bring the Server1 offline and rename Server 2 with the name of
Production. Do we have to change the instance name in SQL now on Server
2? If so can we do this? I didn't think you could change a instance
name and had to reinstall SQL.
If SQL 2000 is a default instance, this should not be difficult. There
is one thing you need to once you have moved:

EXEC sp_dropserver Test
go
EXEC sp_addserver, Production, LOCAL

And the reboot afterthis. Else @@servername will be wrong.
Can you have 2 instances of SQL with the same name but reside on different
servers?

As long as the machines are not connected to each other. if they are on
the same network, I would not recommend it.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp