Community

Product DocsMenu

Coveo Platform 7.0 >
Administrator Help > Third-Party System Procedures > Microsoft SQL Server > Adding the System Administrators Server Role

Adding the Microsoft SQL Server System Administrators Role

The CES administrative account must be a member of the Microsoft SQL Server system administrators server role when you want to install the Coveo SharePoint web service (see Installing the Coveo Web Service, Search Box, and Search Interface into SharePoint).

The procedure applies to Microsoft SQL Server 2008, 2005, and 2000 but varies depending on the SQL Server version:

Microsoft SQL Server 2008 and 2005

  1. Access SQL Server Management Studio (Windows Start menu > All Programs > Microsoft SQL Server 2008 or Microsoft SQL Server 2005).

  2. In the panel on the left, expand localhost > Security, and then click the Logins node.

  3. When the login for the CES administrative account already exists, double-click it. Otherwise, right-click Logins, and then click New Login.

  4. In the Login - New dialog box:

    1. In the Login Name box, enter the CES administrative account.

    2. In the panel on the left, click Server Roles.

    3. In the panel on the right, in the Server roles list, select sysadmin.

    4. Click OK.

Microsoft SQL Server 2000

  1. Access SQL Server Enterprise Manager (Windows Start menu > All Programs > Microsoft SQL Server).

  2. In the panel on the left, expand Microsoft SQL Servers > SQL Server Group > [your server group] > Security.

  3. Click the Logins node.

  4. When the login for the CES administrative account already exists, double-click it. Otherwise, right-click Logins, and then click New Login.

  5. In the SQL Server Login Properties - New Login dialog box: 

    1. In the Login Name box, enter the CES administrative account.

    2. Click the Server Roles tab.

    3. In the Server Role list, select System Administrators.

    4. Click OK.

People who viewed this topic also viewed