Add a login

You can add a login that uses either Windows authentication (recommended) or SQL Server authentication.

To add a login

1. In SQL Server Management Studio, expand the server group and then expand the SQL Server associated with the AVEVA Historian.

2. Expand Security and then right-click the Logins folder.

3. In the shortcut menu that appears, click New Login. The SQL Server Login Properties dialog box appears.

   

4. Do the following:

   1. In the Name box, type the name of the new login. If you are using Windows authentication, click Search and browse the network for a Windows user account.

   2. In the Authentication group, configure the new login to use Windows authentication or SQL Server authentication. If you use SQL Server authentication, you must enter a password for the login.

   3. In the Database list, select the database that the login will use by default.

   4. Select a language from the Language list, or leave as <Default> to use United States English.

5. Click Server Roles.

   

6. To assign the new login to an existing server role(s), select the appropriate check box in the list. This will probably not be necessary unless you are defining a power user who will require specific administrative capabilities on the server.

7. Click the User Mapping tab.

   

8. The User column contains the username to map to the login ID. The default username is the same as the login name.

9. Select the databases that can be accessed by the new login. AVEVA Historian users generally require access to the Runtime and Holding databases. They only need access to the primary database if they are to be granted administrative (or higher) privileges.

   When you select a database, available database roles for that database appear in the Database Roles list.

   By default, all new logins are a member of the Public database role. You can select an additional or different role for the login for a particular database.

10. When you have configured the login, click OK.

11. If you created a login with a SQL Server password, you are prompted to confirm the new password. Confirm the password and then click OK.