Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    31

    Unanswered: SQL Server Service

    after server is restrated the SQL server service get stuck for very long time, when we kill the sql server process id and starts the service from the services console the service starts in no time,
    there are no errors in the windows events viewer, and in the SQL server logs.
    in happens when the service is under local system accont or domain/user account.
    there no start up procedures or parameters.
    the sever configuration is defualt

    what can cuase the problem
    Thanks,

  2. #2
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    Make sure u've latest service-packs installed both for sql and windows. When u start sql; run all DBCC checks on the server.

  3. #3
    Join Date
    Dec 2003
    Posts
    31
    sql sp 3
    w2k sp 4

    which dbcc command i should run?
    thanks,

  4. #4
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    DBCC CHECKDB and DBCC CHECKALLOC are most commonly used for each db to check its health and status, for SQL often stops abnormally if transaction log gets full and couldn't expand due to disk space or its configuration. These tests may help u.

  5. #5
    Join Date
    Dec 2003
    Posts
    31
    there is no problemas in any of the databases
    it seems that there is a security problem...
    Thanks

  6. #6
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    Hi, do u've the same problem for both local and domain-user service accounts. If the startup user is a domain user account, add it to local admin-group.
    U've mentioned that SQL stucks; means u can't log into it during that time or the service doesn't just starts up?

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Review SQL server erorr log for complete information and list out here the last lines where it exactly hangs.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •