SQL 2005 on 2000 Server

[Ecaboodle]

Have a domain A SQL Server 2005 WGE is fine, demote to work group still there, but when I boot it in to Domain B instance of SQL is no longer there...

How do I fix this? Thanks

If you can't fix it in 20 minutes call someone who can.

 

[Ecaboodle]

If i reboot the server back into the old domain it's fine, along with the instance.
So i need to keep the instance of the data base running when it boots into new domain. Any Ideas?

If you can't fix it in 20 minutes call someone who can.

 

[gmmastros]

I would suggest you take a look at the account used to start the SQL Server Service. To do this:

Click Start -> Run
Type Services.msc
Scroll down to:
MSSQLSERVER (this is the SQL2000 Database Engine service).
SQL Server (this is the SQL2005 Database Engine service).
Right Click -> Properties
Click the "log on" tab.



-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom