Solved

SQL Service wont start

Posted on 2011-09-26
8
350 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 3

Expert Comment

by:John_Arifin
ID: 36598553
0
 
LVL 25

Expert Comment

by:TempDBA
ID: 36598659
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
ID: 36598887
can you start it executing from the command prompt? (not start service)
0
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 

Author Comment

by:KTM200
ID: 36599689
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
 
LVL 18

Expert Comment

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

Author Comment

by:KTM200
ID: 36712126
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
ID: 36712160
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
ID: 36715520
instal the SQL 2005 client and managemt tools
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

726 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