Breadcrumbs

SQL Server Setup

  1. SQL Servers (Principal, Mirror & Witness) must be in a Domain

  2. Configure SQL Server Service with the Domain Administrator Account

    1. Go to the SQL Server Configuration Manager. Select SQL Server Services

    2. In the right pane, right-click on SQL Server (MSSQLSERVER). Select, Properties

    3. Click on Log On tab, select This Account radio button and click on Browse to select the Domain Administrator Account

    4. Click, OK. Restart the service

  3. As the SQL Server service is configured with Domain Administrator Account, the user needs to configure the Security Login with the same account

    1. Open SSMS in the Object Explorer, expand the Security tab.

    2. Right-click on Login then select New Login. Click on Search button to select the Domain Administrator Account