SQL Instance is not able to start.

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Instance is not able to start.

Author

Topic

asyed01
Starting Member

13 Posts

Posted - 2009-10-19 : 10:26:10

Hello experts,

I’m trying to make Cluster SQL Server 2005 and have encountered an error. It actually happened even during installation when I was making SQL Cluster. During installation when SQL Setup tired to start SQL Server instance it couldn’t and I had error saying ‘Some services need to be start manually as setup has failed to start them.’ It was obvious that it’s SQL Instance who is not able to start. When I went to start it manually it still didn’t stared. Then I checked processes though Task Manager & I observed a process (sqlserver.exe) tries to start but then suddenly get vanished. NOT SURE AT ALL WHY THOUGH. Since I’ve made cluster so when I move my groups (Cluster Group, MSDTC & SQL_2005) from active SANDBOX1 (where instance is not able to start and keep getting fail) to passive SANDBOX2 SQL Instance starts and everything start working fine. So at this point its clear something is wrong with SANDBOX1 and instances is not able to start. Did anybody faced this problem or have any clue what is causing this problem?

Thanks a lot in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-19 : 14:10:10

Check Event Viewer for the reason and post it here so we can help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

asyed01
Starting Member

13 Posts

Posted - 2009-10-19 : 14:18:38

Thanks tkizer. I checked system log but it doesn’t help much. 4 information messages shows up
followed by 1 error message.

Information messages:
1. The SQL Server [SQLSERVERINS] service was successfully sent a start control.
2. The SQL Server [SQLSERVERINS] service entered the running state
3. The SQL Server [SQLSERVERINS] service was successfully send a stop control.
4. The SQL Server [SQLSERVERINS] service entered the stopped state.

Error message:
Cluster resource ‘SQL Server [SQLSERVERINS] ’ in Resource Group ‘SQL_2005’failed.

Now I’m not sure at all after service starts successfully then who/what send stop control to it?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources