connection failed, check sql server registration properties

[SMO6]

Restoring from a RAID failure. Got the OS back but having issues with SQL. I don't want to loose any data!!!! Can you help?

connection failed, check sql server registration properties

 

[mrdenny]

Did you reinstall SQL Server? Is it running? What OS and version of SQL, what service packs have you installed?

Please provide as much info about what you have done to date to fix this.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SMO6]

SQL 2000 SP3

Win2k SP4

I think part of the problem is that the OS image i used to restore is older than the rest of the data.

Should I try creating a new server instance? I'm a SQL n00b.

later!

smaug

 

[mrdenny]

Uninstall and reinstall SQL Server, then reapply the patches. SQL doesn't like being installed from an Image. Then you should be able to connect, and restore your databases.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLBill]

Also, make sure that when you reinstall SQL Server that you give it the SAME instance name as the original. Also, make sure the TCP port is the same as the original (default is 1433).

-SQLBill