Re: SQL Server is Not started after restarting

From: Joe Yong (NO_jyong_SPAM_at_scalabilityexperts.com)
Date: 09/27/05 

Date: Tue, 27 Sep 2005 11:14:20 -0500

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.

"Praveen" <apveen@gmail.com> wrote in message
news:1127801888.243254.151390@g44g2000cwa.googlegroups.com...
> 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?.
>

Relevant Pages

  • Re: User ASPNET in SQL Server 2000
    ... and turn off anonymous access. ... a logon box will pop up if the user cannot ... >While I love integrated security in SQL Server, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Capture SQL Server Connections
    ... LOGON TRIGGERS are only support in SQL Server 2005+. ... As long as the LOGON TRIGGER is running the connection is not yet made ... connecting so I can provide a custom authenication mechanism? ...
    (microsoft.public.sqlserver.server)
  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Run As Command
    ... Declare @VCHCOMMAND Char, ... if you are using BACKUP DATABASE command to backup the database then ... to use a seperate logon for the destination server. ... to SQL server bacause SQL Server cannot see that domain. ...
    (microsoft.public.sqlserver.security)
  • Re: User ASPNET in SQL Server 2000
    ... I want to logon to the virtual catalog from the internet ... as the windows user then I want to logon to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet.security)