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
SimonSQL2000 - 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|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day

"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|||Some thoughts here:
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"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
No comments:
Post a Comment