Database Guide › SQL Server Guidelines › SQL Server Logins › Manually Create a SQL Server Login

Manually Create a SQL Server Login

(Applicable to the CMS)

You can manually create the required SQL Server logins before installing the CMS. Use SQL Server Enterprise Manager to create logins for the: Primary User; Search User; Unrestricted Search User; and Reporting User.

Language Requirement

(Applies only to Data Management console users)

If you manually create a SQL Server login, you must set the default language to US English. Specifically, set the language name to:

us_english (language alias: 'English')

If the login uses any other language, the Data Management console fails to run because of incompatible date formats. For example, do not set the language to:

british (language alias: 'British English')

If you need to reset the language assigned to a login, run the following command as a system admin account such as 'sa':

ALTER LOGIN [WGNUSER] WITH DEFAULT_LANGUAGE=[us_english]

Follow these steps:

1. In Enterprise Manager, go to the Security, Logins folder of the CMS server:
2. In the General tab do the following:
   1. Enter a login name in the Name field. This login must be able to connect to the ‘master’ database. The CMS installation wizard will ask for this login name.
   2. Select ‘SQL Server Authentication’ and specify a password.
3. In the Server Roles tab, grant the dbcreator role to the new login. (SQL Server uses server roles to grant server-wide security permissions to logins.)
4. Click OK.