How to fix SQL Server 2000 after machine name & domain change ?

Hello everybody..
Is there a way to fix the SQL Server 2000 installation when the Server after
the server has been disjoined form its old domain and added to a new domain
with a different computer name too?
Sounds like a joke, but stuff happens.
TIA
-arifiHi,
Did you meant to change the server name of sql server,
sp_dropserver <Old server name>
go
sp_addserver <new server name>,Local
Thanks
Hari
MCDBA
"Arifi Koseoglu" <arifi@.turk.net> wrote in message
news:c1l5v8$1kbung$1@.ID-213322.news.uni-berlin.de...
> Hello everybody..
> Is there a way to fix the SQL Server 2000 installation when the Server
after
> the server has been disjoined form its old domain and added to a new
domain
> with a different computer name too?
> Sounds like a joke, but stuff happens.
> TIA
> -arifi
>
>|||Nope, I meant changing the name of the server computer. With its new name
and new domain, the SQL Server Software is currently not able to start on
the machine. So, I cannot connect to the server. As a result no scripts can
be executed on the DB server.
Thanks,
-arifi
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uDwYqfI$DHA.792@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Did you meant to change the server name of sql server,
> sp_dropserver <Old server name>
> go
> sp_addserver <new server name>,Local
> Thanks
> Hari
> MCDBA
> "Arifi Koseoglu" <arifi@.turk.net> wrote in message
> news:c1l5v8$1kbung$1@.ID-213322.news.uni-berlin.de...
> after
> domain
>|||This may be because the account you use to start SQL server does not have
appropriate permissions on the new box, check AD and see if the service
account has permissions. In the meantime, you should be able to set the
services to start as local system.
Ray Higdon MCSE, MCDBA, CCNA
--
"Arifi Koseoglu" <arifi@.turk.net> wrote in message
news:c1l982$1jjf3r$1@.ID-213322.news.uni-berlin.de...
> Nope, I meant changing the name of the server computer. With its new name
> and new domain, the SQL Server Software is currently not able to start on
> the machine. So, I cannot connect to the server. As a result no scripts
can
> be executed on the DB server.
> Thanks,
> -arifi
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:uDwYqfI$DHA.792@.TK2MSFTNGP11.phx.gbl...
>|||You need to use the sp_dropserver and sp_addserver to rename the internal
SQL Server name.
These are documented in SQL Server Books on Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Do you mean SQL Server services can not start ' If so,
check the services which account they are runnig under.

>--Original Message--
>Nope, I meant changing the name of the server computer.
With its new name
>and new domain, the SQL Server Software is currently not
able to start on
>the machine. So, I cannot connect to the server. As a
result no scripts can
>be executed on the DB server.
>Thanks,
>-arifi
>"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>news:uDwYqfI$DHA.792@.TK2MSFTNGP11.phx.gbl...
installation when the Server
added to a new
>
>.
>|||YES YES
This solved the problem - this is the time to say: Wwhat was I thinking ?!
Thanks for the help!
Cheers !
-arifi
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:OpZVbzI$DHA.1792@.TK2MSFTNGP12.phx.gbl...
> This may be because the account you use to start SQL server does not have
> appropriate permissions on the new box, check AD and see if the service
> account has permissions. In the meantime, you should be able to set the
> services to start as local system.
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Arifi Koseoglu" <arifi@.turk.net> wrote in message
> news:c1l982$1jjf3r$1@.ID-213322.news.uni-berlin.de...
name
on
> can
Server
>