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
>

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
-arifi"Arifi Koseoglu" <arifi@.turk.net> wrote in message
news:c1l36e$1k112u$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

See "Renaming a Server" and "Changing Passwords and User Accounts" in Books
Online - they list the steps to follow. If you didn't change the account
that MSSQL is running under, then you should only need to look at the first
section.

Simon|||Did you get a solution to this? I couldnt find anytning on the books online..Our domain name is change ..
Thanks|||did you find any answers for this? We are hoping to rename few servers this weekend.

Thanks,

Rushdisql

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...
> > 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
> >
> >
> >
>|||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...
> > 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...
> > > 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
> > >
> > >
> > >
> >
> >
>|||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...
>> 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...
>> > 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
>> >
>> >
>> >
>>
>
>.
>|||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...
> > 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...
> > > > 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

how to find out who are in BUILTIN/Administrators Group?

sql2k, nt5
Does anyone know how to find out who are the members in
BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
admin group and can't see nt account info from the NT side).
thank you.The BUILTIN/Administrators group maps to the Windows Local administrators
group. If you can't see who's in the Windows group, you can't find out who's
in BUILTIN/Administrators.
--
Jacco Schalkwijk
SQL Server MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||You can try
exec master..xp_logininfo 'BUILTIN\Administrators','members'
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> sql2k, nt5
> Does anyone know how to find out who are the members in
> BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> admin group and can't see nt account info from the NT side).
> thank you.
>|||that's very helpful. thank you!!!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObGoTa8JEHA.644@.tk2msftngp13.phx.gbl...
> You can try
> exec master..xp_logininfo 'BUILTIN\Administrators','members'
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:%23W8uAl7JEHA.3980@.TK2MSFTNGP10.phx.gbl...
> > sql2k, nt5
> >
> > Does anyone know how to find out who are the members in
> > BUILTIN/Administrators group in SQL Server. (when I'm not in a NT domain
> > admin group and can't see nt account info from the NT side).
> >
> > thank you.
> >
> >
>

How to find all sql servers in a domain

Hi,
Is there a way to find all available SQL Servers in a particular domain or
subnet?
Thanks.
- Rob.At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:
> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
> > Hi,
> >
> > Is there a way to find all available SQL Servers in a particular domain or
> > subnet?
> >
> > Thanks.
> >
> > - Rob.|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
> > Hi,
> >
> > Is there a way to find all available SQL Servers in a particular domain or
> > subnet?
> >
> > Thanks.
> >
> > - Rob.|||You can query the registry on your severs to get a definative answer the path
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
> osql /L will most likely not give you all the SQL servers in a domain unless
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
> > At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> > are broadcasting on the network.
> >
> > "Rob" wrote:
> >
> > > Hi,
> > >
> > > Is there a way to find all available SQL Servers in a particular domain or
> > > subnet?
> > >
> > > Thanks.
> > >
> > > - Rob.

How to find all sql servers in a domain

At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:

> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.Hi,
Is there a way to find all available SQL Servers in a particular domain or
subnet?
Thanks.
- Rob.|||At the DOS prompt enter "OSQL -L" The -L option show all the servers that
are broadcasting on the network.
"Rob" wrote:

> Hi,
> Is there a way to find all available SQL Servers in a particular domain or
> subnet?
> Thanks.
> - Rob.|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||ISQL /L from a machine that has the client tools installed or use SQL DMO.
Just be aware that within the server network utility you have the ability to
hide the server so this may not be conclusive.
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||osql /L will most likely not give you all the SQL servers in a domain unless
you have a tiny domain that has nothing routed and every machine is
broadcasting--an unlikely scenario.
The only reliable way I've found is to enumerate all the machines in a
domain and systematically test each machine for the presence of SQL server
instances.
Linchi
"Greg Larsen" wrote:
[vbcol=seagreen]
> At the DOS prompt enter "OSQL -L" The -L option show all the servers that
> are broadcasting on the network.
> "Rob" wrote:
>|||You can query the registry on your severs to get a definative answer the pat
h
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
[vbcol=seagreen]
> osql /L will most likely not give you all the SQL servers in a domain unle
ss
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
>|||You can query the registry on your severs to get a definative answer the pat
h
is:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
This will list all instances installed on your server.
Ray
"Linchi Shea" wrote:
[vbcol=seagreen]
> osql /L will most likely not give you all the SQL servers in a domain unle
ss
> you have a tiny domain that has nothing routed and every machine is
> broadcasting--an unlikely scenario.
> The only reliable way I've found is to enumerate all the machines in a
> domain and systematically test each machine for the presence of SQL server
> instances.
> Linchi
> "Greg Larsen" wrote:
>