I can't start sql server from Computer Management-services

Question

 

Hi

    I have installed sql server 2005 developers edition , but I can't start it.I'm told that the service started and then stopped because it had no work to do!I have also tried connecting from Visual Studio 2008 , with no luck.In SQL Management Studio , I have a registered server named 'mycomputer' , but when I enter this in the connect to server dialog box , I'm not able to connect , as the name is not recoginised.My computer is running Xp professional sp3 , and I'm logged on as administrator.

   Can anyone help?

    regards

Answer 1

Hi,

Could you post the full error message and codes, please.

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 2

Never encountered this issue. May be the following links will be helpful:

http://social.msdn.microsoft.com/Forums/en-SG/sqldatabaseengine/thread/24a9d481-7251-425a-ac02-2ef627ef6738

http://www.sqlservercentral.com/Forums/Topic186166-146-1.aspx

- Krishnakumar S

Answer 3

Can you also go to the Windows event log and include any SQL Server service error messages when you try to start the service.  If the service is not running, you will not be able to connect from SSMS/VS/app, etc.

Thanks,
Sam Lester (MSFT)

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

Answer 4

 Thanks for the replys and sorry for the late response.

   So ,from Computer Management - Services if I try to start SQL Server , I get:-

      "The SQL Server (MSSQLSERVER)service on local computer started and then stopped.Some services stop automatically if they have no work to do,for example,the Performance logs and alerts service."

If I try to start SQL Server Agent , I get:-

    "Could not start the SQL Sever Agent(MSSQLSERVER)service on local computer.

         Error 1068:The dependency service or group failed to start."

I notice that SQL Server V V S Writer,Integration Services,Full Text Search,Browser,Analysis Services have all started.

The Active Directory Helper has the Start option greyed out.

These are the eight SQL related services I can see in Computer Management - Services.I wonder if I am missing one or more?

  

Answer 5

Can you check that the account you have specified for that service is still valid?  And is it possible that you might have an Evaluation edition (as opposed to the Developer edition that you thought you installed)?  If it expires, you can see this error as well.

One workaround to try is to change the service used for MSSQLSERVER to local system and start it up.  If it starts, change the service context back to the credentials you were previously using.

Thanks,
Sam Lester (MSFT)

---

This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

Answer 6

Can you follow the KB article and change the startup account of the sql server.

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 7

 Thanks both

         I'll give this at try.

 

Answer 8

 Thanks Ashwin

               I will have a look at this article.

Thanks Sam

          I loaded  SQL Developer edition from the disc with Visual Studio 2008 Professional edition."For academic use only" , as it says on the box.I don't think that there is an expiry date.

              

     

 

Answer 9

Hi again

    I had a look at the article suggested by Ashwin.However , it suggests:-

    

1. Change the startup account of both the MSSQLSERVER and SQLServerAgent to use the Local System account.
2. Restart the computer.

   According to Computer Management - Services , both of these have Local System under the 'Log On As' column and have Manual as 'Startup Type'.So , I'm not clear what is meant by startup account here.

   The computer is a Work Group member , would this be a factor  perhaps?

Answer 10

Hi

When was the computer restarted? It could be the fact that it was under a domain account and after changing the startup account it was not restarted.

The startup account is the account specified under "Log On As".

As per the article it says

This problem occurs if both of the following conditions are met:

• The server computer is in a workgroup and not part of a domain.
• Both the MSSQLSERVER and SQLServerAgent services are set to use a domain account for the startup.

The fact that yours is a workgroup it partly satisfies the conditions and if the services were previously set for domain account and after changing that if the computer was not restarted we will get into this issue.

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 11

 

  Hi

    So , since the computer is in a workgroup(Can it be a member of a domain at the same time?), I have to change the startup account of both SQL server and agent to ....what?I'm unsure about this , can I perhaps do it from Computer Management-Local Users And Groups.

   Thanks for your patience!

Answer 12

you computer can either be in a workgroup or a member of a domain not both at the same time.

You need to change the startup account of both sql server and agent to local system account if your computer is in a workgroup. You need to do this from SQL Server configuration Manager.

Once you do this you need to restart your computer for this error to go out as per the KB article.

HTH

---

Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

Answer 13

  Hi again Ashwin

          My problem is both the SQl server and agent currently have Local System as the startup account .As my computer is in a Workgroup , I can't see how I'm getting the problem , since only one of the conditions for the problem is present.I have'nt previously attempted to change the startup accounts.Is there perhaps another problem not yet considered?

               regards

Answer 14

Check the Windows application log using event viewer, as there are host of different problems for the service not to start. it may be a bad password or wrong logon account as the previous posts suggest, but since you are insisting that they have local system as logon accounts then the error may be something else. I have seen problems like error log file location being a problem and lot of other things.

Answer 15

Hello,

The link below might help you

http://support.microsoft.com/kb/307288

Answer 16

 Thanks , Willsonsingh .I'll check the Windows application log also , thanks Power-dba.

Answer 17

 

     Ok , so today I've uninstalled and then re-installed this sql 2005 Developer Edition , and now it works!!I'm able to connect from Management Studio.I did't do anything differently during this process , as far as I recall , except select Mixed Mode instead of Windows Authentication Mode when prompted.Even then , I connected using the latter option.

            Thanks all for your time and effort in helping me with this problem.If only I'd taken the above step earlier!

                regards