SQL Server Performance

Scipt to start SQL server service

Discussion in 'SQL Server 2005 General DBA Questions' started by Akthar, Jun 8, 2007.

  1. Akthar New Member

    hi guys,
    i am looking for a script to start the sql server services once the server is fully started.

    thanks

    AKTHAR
  2. thomas New Member

    net start MSSQLSERVER

    will do it in a command file, but why not just set your service to autostart?
  3. Akthar New Member

    My SQL server service does not start in Auto mode as i am using a domain account. When i restart the server, the network interface starts after the sql server service and it cant find the user name. <br />Is there anyway out.???[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />AKTHAR
  4. MohammedU New Member

    You can use NET START MSSQLSERVER to careate the batch file and execute it once the network service is running...
    But why don't you ask your server engineer to correct the issue?

    One more option is leasve the sql service with autostart and
    In COMPUTER MANAGEMENT/right click SQL SERVICE/click on RECOVERY TAB/

    You see the option called "Computer's response if the service fails" there you change for the FIRST FAILURE to RESTART THE SERVICE after 1/2/3 minutes and the same for second failure....
    This should correct the problem....


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. CG2000 New Member

    You can restart the server, but you don't have sufficient privilages to change the service startup type?

    Forget running a batch script - solve the user privilages issues, by the sound of it you are going to have many more problems up the road with the database and users...
  6. Akthar New Member

    i have tried the service recovery, but it seems that windows doest not retry to start the service.

    AKTHAR
  7. Akthar New Member

    in fact i do have the permissions to start the service, it is just that the NIC starts after the sql service

    AKTHAR
  8. CG2000 New Member

    If you are authenticating with Windows authentication to a server from a remote pc, the server will accept authentication requests when the net service starts, the SQL service will start at some point in the startup routine but it will be ready to take connections (via Windows authentication). The nic is controlled by the O/S on the remote pc (Win NT), the O/S dictates the start of the net service - as soon as the remote O/S is ready to start the net service you can authenticate (provided you have sufficient permissions) to the server.

    If you are logging on directly to a server the local authentication service is in place and the SQL service starts - no nic issues. If you can authenticate and you have sufficient permissions you can administer the settings, and initiate a connection to SQL.

    The NIC issue you are identifying is a non-starter. You have user authentication issues, and maybe systems issues, resolve them and your problems will be resolved.

  9. Akthar New Member

    Thanks for the help. in fact...
    I have 1 domain controller + 1 SQL Server. The sql server authenticates on the Domain Controller. When i restart the SQL Server, it cant authenticate on the Domain Controller as it seems that the NIC is not yet ready. Once the Server is started i can manually starts the Sql Server Service.

    thanks

    AKTHAR
  10. CG2000 New Member

    Akthar;

    You might want to look in the Event Log to look for associated errors with the NIC and the net service.

    I don't know if you are running Active Directory - but I have seen DNS problems with some Active Directory implementations (especially W2K AD) where there are authentication errors between servers. This can cause delayed authentication, problems or delays with starting various services, or servers disappearing suddenly, etc. Once the AD DNS configuration issues are resolved everything is able to communicate more reliably. Just a suggestion, don't know if it is applicable to your enviroment...
  11. Akthar New Member

    hi,
    many thanks for these infos. I have check for DNS issue, none. I had also a look in my eventviewr, where i can see that the domain controller is not available when the server starts.
    i have to find a way to delay the sql server service to start!!!!!!!



    AKTHAR
  12. satya Moderator

    You can take help of WAIT command in MSDOS (I think) to pause for a moment until the domain services are available, provided if you are wrapping up the process in a batch file.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  13. Akthar New Member

    services are set to start Automatically. I am not using any batch file to insert a wait command.

    AKTHAR
  14. satya Moderator

    Then those domain controller starting issues will be generated unless you sort those issues first, it is good to proceed in this way if you haven't got a chance to resolve the network related issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  15. Akthar New Member

    Yes, but is there a way that i can delay the sql service to start after few minutes.

    AKTHAR
  16. satya Moderator

    Not unless you control in a manner of pausing using a batch file on Windows operating system, otherwise by default it will go ahead in starting up the services.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page