Solved

SQL Service wont start

Posted on 2011-09-26
8
341 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
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
 

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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql query 12 67
Incremental load example 2 52
SQl Agent job fails--SSIS package looses password 6 45
Table create permissions on SQL Server 2005 9 40
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

947 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

21 Experts available now in Live!

Get 1:1 Help Now