Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon
SQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon
|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon