Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
 Posted - 2009-06-29 : 09:40:43
|
| The Sql Server Service won't start. This is a named instance, 2005 SP2 in a 2-node cluster. Event log is showing error messages:initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).However when I check the start-up parameters in Sql Config Mgr I see:-dM:\MSSQL\Data\master.mdf;-eF:\errorlog.log;-lM:\mastlog.ldfThis value is also present (and the same) in the registry. We're using a domain account to run the service and I've verified that this account is a local admin and has appropriate rights on the drives.However I can start Sql Server by running it from the command line with the same parameters....(sqlservr.exe -dM:\MSSQL\data\master.mdf -eF:\errorlog.log -lL:\MSSQL\data\mastlog.ldf -sSERVERNAME)Anyone see this before? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-30 : 10:19:04
|
| Is F:\ a shared disk? If it is not, the cluster service will not allow access to it, and the errorlog should be moved to a shared disk. |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2009-06-30 : 14:56:18
|
| Yeah, F: is a shared disk (they all are since this is clustered)I didn't turn up anything yesterday. Since it looked like Sql was having trouble seeing the disks, we scheduled after hours maintenance yesterday and ended up rebuilding the cluster. |
|
|
|
jrsansom
Starting Member
4 Posts |
Posted - 2009-06-30 : 15:26:41
|
| Have the disks/LUN's in question been added as clustered resources i.e. resourceses added to the cluster in the Cluster Administrator.John Sansom | www.johnsansom.com | |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2009-06-30 : 15:34:28
|
| Yes, they were and are.The sledgehammer approach seems to have worked, I haven't seen any abnormal behavior...yet. |
|
|
|
|
|
|
Sql Server Service