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 the edition of SQL Server 2000/2005 through registry?

Hey, I need to understand what version of SQL is running on some machine. How can I do it looking through the registry. I know you can do it for windows and exchange but I don't know how to do it for SQL 2000. I know in SQL 2005, it tells you the edition for SQL, but how do you do it in SQL 2000. Also, I'm pretty sure, you can look at the Product ID and tell if it's an enterprise edition or standard edition and so on, but I don't have the information. Windows and Exchange do it like that. Can someone provide me with such info? Thank you

you don't have to go through the registry for that - look up the SERVERPROPERTY() function in Books Online. You can find a lot of information about the server using that function.

If for some reason you still need the registry, everything SQL Server stores is in this base hive:

HKLM\Software\Microsoft\MSSqlserver\

|||

in query analyzer type: SELECT @.@.VERSION

or try HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

also see

http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/50660f9ebffa92c8/c132c39beb51c4c2?lnk=st&q=how+to+find+sql+server+2000+version+in+registry&rnum=1&hl=en#c132c39beb51c4c2

Microsoft Knowledge Base Article – 321185

http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#3

Hope this helps

dscastro

How to find SQL Server machine configration

I have SQL Server client installed on my machine, through which I connect to SQL Server A. Is there any way, in which I can find out the configration of the machine on which SQL Server A is installed. I am interested in finding out the number of processors and the amount of RAM.

If you're using SQL Server 2005 and have sysadmin privileges or more specifically the VIEW_SERVER_STATE permission you can run the following command:

SELECT * FROM sys.dm_os_sys_info

You can see [cpu_count] and [hyperthread_ratio] as well as [physical_memory_in_bytes]

For more information, please check out the Books Online documentation: http://msdn2.microsoft.com/en-us/library/ms175048.aspx.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Hi Paul,

Thanks for the info.

But I am currently trying to find the machine config of SQL Server 2000. Is there a equivalent query for that. Sorry I didn't specify the SQL Server version in the previous post.

|||

You should upgrade :-P

For SQL Server 2000, I'm not sure. Have you tried EXEC xp_msver?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

EXEC xp_msver gives me the processor count and the processor type.

I think I can go ahead from there. Thanks