New SQL server to replace old SQL server

Hi
We are getting ready to replace an old NT old SQL server with a New
Server, New Windows and SQL.
I would like to setup the new server with a new name for testing and
once we have it working rename it to the old server name. There are some
ODBC connections that use the name and I suspect a few other things
setup that way as well.
Does that cause an issue with SQL to rename a server?
Thanks
Will
Hi,
After testing you can rename the sql server with out any issues.
Use:-
SP_DROPserver <servernaem>
Go
SP_ADDSERVER <name>,LOCAL
After this just restart sql server service.
Thanks
Hari
SQL Server MVP
"Will Kubly" <wkubly@.wi.rr.com> wrote in message
news:uf%23cyMnjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Hi
> We are getting ready to replace an old NT old SQL server with a New
> Server, New Windows and SQL.
> I would like to setup the new server with a new name for testing and once
> we have it working rename it to the old server name. There are some ODBC
> connections that use the name and I suspect a few other things setup that
> way as well.
> Does that cause an issue with SQL to rename a server?
> Thanks
> Will

New SQL server to replace old SQL server

Hi
We are getting ready to replace an old NT old SQL server with a New
Server, New Windows and SQL.
I would like to setup the new server with a new name for testing and
once we have it working rename it to the old server name. There are some
ODBC connections that use the name and I suspect a few other things
setup that way as well.
Does that cause an issue with SQL to rename a server?
Thanks
WillHi,
After testing you can rename the sql server with out any issues.
Use:-
SP_DROPserver <servernaem>
Go
SP_ADDSERVER <name>,LOCAL
After this just restart sql server service.
Thanks
Hari
SQL Server MVP
"Will Kubly" <wkubly@.wi.rr.com> wrote in message
news:uf%23cyMnjFHA.3704@.TK2MSFTNGP10.phx.gbl...
> Hi
> We are getting ready to replace an old NT old SQL server with a New
> Server, New Windows and SQL.
> I would like to setup the new server with a new name for testing and once
> we have it working rename it to the old server name. There are some ODBC
> connections that use the name and I suspect a few other things setup that
> way as well.
> Does that cause an issue with SQL to rename a server?
> Thanks
> Will