Solved

SQL Service wont start

Posted on 2011-09-26
8
337 Views
Last Modified: 2012-05-23
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
0
Comment
Question by:KTM200
8 Comments
 
LVL 3

Expert Comment

by:John_Arifin
Comment Utility
0
 
LVL 25

Expert Comment

by:TempDBA
Comment Utility
What recent changes you made? Did u upgrade your OS or some other software?
Besides, have you got a backup of master database?
0
 
LVL 18

Expert Comment

by:x-men
Comment Utility
can you start it executing from the command prompt? (not start service)
0
 

Author Comment

by:KTM200
Comment Utility
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
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 18

Expert Comment

by:x-men
Comment Utility
what's the error when you run the sqlservr.exe
0
 

Author Comment

by:KTM200
Comment Utility
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?

0
 

Author Comment

by:KTM200
Comment Utility
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
0
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
Comment Utility
instal the SQL 2005 client and managemt tools
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now