Groups | Blog | Home
all groups > sql server clustering > march 2007 >

sql server clustering : event id 17055


snazzy
3/27/2007 7:28:17 PM
Hi,
I having a problem starting sql server in a cluster. The error has the
description;
17113:
initconfig: Error 2(the system cannot find the file specified.) opening
Hate_orphaned_users
3/28/2007 2:26:00 AM
did you check if the file master.mdf exist?
first check in cluster administrator if the configuration is ok and the
resources are available.
If the master.mdf is corrupt, you can't start sqlserver.
So you have to do a restore.
Start up SQL server in single user mode:

check this ARTICLE!
http://articles.techrepublic.com.com/5100-1035_11-5025441.html

GOOD LUCK!
--
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL :)




[quoted text, click to view]
snazzy
3/28/2007 8:12:02 AM
Hi,
I am able to start the SQL server manually through a command line. The
error occurs when I try to start SQL server through the Cluster
Administrator. Does this mean the master.mdf is still corrupt?

Thanks

[quoted text, click to view]
Anthony Thomas
4/9/2007 12:00:00 AM
More likely that the quorum registry entries that locate the master database
are corrupt or the installation is not properly configured for failover
clustering.

Can you provide some historical context?

If it is registry keys, then you will need to perform a cluster recovery
scenario:


http://support.microsoft.com/kb/258078

http://support.microsoft.com/kb/266274


Good luck.

Sincerely,


Anthony Thomas


--

[quoted text, click to view]

AddThis Social Bookmark Button