SQL Server is Not started after restarting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Praveen - 26 Sep 2005 11:13 GMT

Hi all,

I have configured my SQL Server to run under domainname\username
account. It is wroking fine till i restart the m/c. If i have
restarted,then Sql service is not being started. I have not changed the
Password also. Everytime i need to go services tab and then i need to
give same user name and psword to start the services. while clicking i
am getting the error message lon on serive request has been set like
that?..

What could be the problem?.

Regards

Reply to this Message

Andrew J. Kelly - 26 Sep 2005 14:09 GMT

You should never change the accounts that SQL Server or SQL Agent run under
via the services panel directly. Use EM instead as it sets the proper
permissions and such as needed that will not happen if changed thru Services
alone.

Signature

Andrew J. Kelly SQL MVP

> Hi all,
>
[quoted text clipped - 9 lines]
>
> Regards

Reply to this Message

Praveen - 27 Sep 2005 07:18 GMT

Even thought I have done thru EM, After restrating my m/c,SQL Service
is not restarted. Or Pls tell me How can i set the serice logon request
to user logon?.

Reply to this Message

Joe Yong - 27 Sep 2005 17:14 GMT

Let's see if I got this right.

Your SQL Server service will not auto-start when you reboot the machine even
before you made any changes to the SQL Server services account (both userid
and password)?

If that's the case, check to ensure the userid you are using for the service
has:
- logon as a service rights
- change access to where your SQL Server files are installed
- read/write access to a couple of reg keys which I don't remember off the
top of my head

Look up services accounts in BOL. If I remember correctly, the requirements
are pretty well documented.

Also, check the error logs to see what prevented the service from starting
automatically (I'm guessing you do have auto-start checked for the service).
This is just in case something else is causing problems.

joe.

> Even thought I have done thru EM, After restrating my m/c,SQL Service
> is not restarted. Or Pls tell me How can i set the serice logon request
> to user logon?.

Reply to this Message

Anthony Thomas - 01 Oct 2005 23:23 GMT

See if this helps.

How to change the SQL Server or SQL Server Agent Service account without
using SQL Enterprise Manager in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811

It has the registry keys and User Access rights Joe is referring to.

Sincerely,

Anthony Thomas

Let's see if I got this right.

Your SQL Server service will not auto-start when you reboot the machine even
before you made any changes to the SQL Server services account (both userid
and password)?

If that's the case, check to ensure the userid you are using for the service
has:
- logon as a service rights
- change access to where your SQL Server files are installed
- read/write access to a couple of reg keys which I don't remember off the
top of my head

Look up services accounts in BOL. If I remember correctly, the requirements
are pretty well documented.

Also, check the error logs to see what prevented the service from starting
automatically (I'm guessing you do have auto-start checked for the service).
This is just in case something else is causing problems.

joe.

> Even thought I have done thru EM, After restrating my m/c,SQL Service
> is not restarted. Or Pls tell me How can i set the serice logon request
> to user logon?.

Reply to this Message