MSSQL server and Operating system

  • Hi ,

    Does any one a link or having any material which gives better details about dependency about SQL server and operating system

    Rajganesh

  • Your best bet is Books Online that came with SQL Server or is downloadable from Microsoft. SQL Server runs as a service on the Windows operating system and can use Windows security and password policies. As your question is rather broad, it's a hard one to answer. Can you provide more specific questions? If so, we can probably point you to the specific material.

    SQL Server 2005 Books Online

    K. Brian Kelley
    @kbriankelley

  • Like for an example , if you are stopping SQL server services what all os related things gets affected amd how is the service stopped

  • Nothing on the OS is affected. The server stops and SQL does not respond to clients, but the OS isn't changed.

    There should be more resources available for the OS and other services.

  • In general, SQL Server runs as a Windows service. It stops the same as any other controllable service, such as IIS Admin, WWW Publishing Service, etc. As to what else is affected, only those services which are dependent on the SQL Server service. This should only be the SQL Server Agent service for that particular instance. As Steve indicated, nothing else is affected, especially not anything else on the OS side.

    K. Brian Kelley
    @kbriankelley

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply