asked on

SQL Service wont start

Hi all, please could someone assist. I have very little knowledge of SQL and my SQL server service starts and then stops immediately. I get this error log:

Event ID: 17055
18052 :
Error: 9003, Severity: 20, State: 1

I have recreated the Admin profile on the server and tried logging on as another user with admin rights but the service will not start

Any assistance would be appreciated

Many Thanks

John_Arifin

Hope this can help.
http://www.dbforums.com/microsoft-sql-server/1203681-error-9003-severity-20-state-1-a.html

TempDBA

What recent changes you made? Did u upgrade your OS or some other software?
Besides, have you got a backup of master database?

x-men

can you start it executing from the command prompt? (not start service)

KTM200

ASKER

Hi all, nothing new installed but the server did shutdown incorrectly due to a power outage. Looked at the doc but dont have the rebuild.exe in the bin folder. also tried starting from command prompt but no luck

x-men

what's the error when you run the sqlservr.exe

KTM200

ASKER

Hi All, I gave up and removed SQL Server 2000 and have loaded SQL 2005 but now under SQL Configuration Manager i get this error in the Configuration manager:

Connection Failed, Check SQL Server registration properties

Any ideas?

KTM200

ASKER

When I right click and click connect i get this error:

A connection could not be establish to (Local)
Reason: [SQL-DMO]You must use SQL Server 2005 Management Tools to connect to this server...
Please verify that SQL Server is running and check your SQl Server registration properties

Please help

ASKER CERTIFIED SOLUTION

x-men

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial