sql server service wont start after vista updates

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

SQL Server 2005 Forums

SQL Server Administration (2005)

sql server service wont start after vista updates

Author

Topic

rbadn
Starting Member

3 Posts

Posted - 2007-08-20 : 09:46:47

hey

I have a notebook with windows vista ultimate edition. For developement i have Ms visual studio 2005 and sql server 2005(with all the required and latest SPs) on it. For the past few months i have been working on the machine without any hitches. Just 2 -3 days back some windows updates got installed on the machine and guess what!!!!!! the sql server service just stopped working. The service wont start no matter what. I
have tried almost solution that i came across on the internet and it wont work out. I unistalled and reinstalled the server as but to no avail. The database engine now wont intall as the sql service wont start during the server installlation.

While browsing through the internet i didnt come across anyone with a similar problem! Am i the first one to be in such a situation
give your comments and share any relevant experience.

P.s the windows upgrades installed on the system were all security upgrades so why should they effect the sql server working.

Rgds

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-20 : 09:51:05

Which account is SQL Server Engine using?
Have you run the User Elevation Tool?

E 12°55'05.25"
N 56°04'39.16"

rbadn
Starting Member

3 Posts

Posted - 2007-08-20 : 10:21:37

no i ahvent run user elevation tool?? infact i ahve no idea of what user elevation tool is. The server is using local system account.

just to be specific the problem that i have now is that the database engine wont install after the vista updates as the sql server service doesnot start during installation.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-20 : 10:23:59

Do you get any errors?

E 12°55'05.25"
N 56°04'39.16"

rbadn
Starting Member

3 Posts

Posted - 2007-08-20 : 10:58:24

hey ... these are the errors that i get in the event log when the service start up fails during installation. They are in sequence
==============================================
Log Name: Application
Source: MSSQLSERVER
Date: 20/08/2007 00:08:13
Event ID: 17137
Task Category: (2)
Level: Information
Keywords: Classic
User: N/A
Computer: Adnan-PC
Description:
The description for Event ID 17137 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

model

=========================================
Log Name: Application
Source: MSSQLSERVER
Date: 20/08/2007 00:08:13
Event ID: 17182
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: Adnan-PC
Description:
The description for Event ID 17182 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

139f
80

========================================================
Log Name: Application
Source: MSSQLSERVER
Date: 20/08/2007 00:08:13
Event ID: 17182
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: Adnan-PC
Description:
The description for Event ID 17182 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

139f
1
================================================================
Log Name: Application
Source: MSSQLSERVER
Date: 20/08/2007 00:08:13
Event ID: 17826
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: Adnan-PC
Description:
The description for Event ID 17826 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:
================================================================
Log Name: Application
Source: MSSQLSERVER
Date: 20/08/2007 00:08:13
Event ID: 17120
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: Adnan-PC
Description:
The description for Event ID 17120 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

FRunCM

===========================================================================
Log Name: Application
Source: MsiInstaller
Date: 20/08/2007 00:08:17
Event ID: 10005
Task Category: None
Level: Error
Keywords: Classic
User: Adnan-PC\Adnan
Computer: Adnan-PC
Description:
Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.

===========================================================================

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources