MS SQL Server - New SQL server to replace old SQL server

Author

New SQL server to replace old SQL server

Will Kubly

2005-07-22, 3:23 am

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

Hari Prasad

2005-07-22, 3:23 am

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

Sponsored Links