Configure Database Users

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Databases > Admin >

Configure Database Users

EarthSoft recommends an experienced SQL Server Database Administrator manage a SQL Server instance and all user access to SQL Server. This form was created primarily for workstation installations of Microsoft SQL Express, which may not include management tools.

 

Notes:

When installing SQL Server Express, a password must be provided for the SA (System Administrator) account. This is not the same as the computer administrator password. SQL Server has an account named sa that is the default system administrator account. Accessing this form with SQL Server credentials which are not a member of the sysadmin role will cause errors and likely result in no changes to SQL Server.

As of EQuIS Version 6, EarthSoft no longer supports SQL Server 2008 or earlier; it must be SQL Server 2008 R2 or later.

 

Accessing - EQuIS Professional

 

1.Launch EQuIS.exe

2.Log in to Microsoft SQL Server using credentials that are granted SQL sysadmin role. Typically, a Windows administration account is a member of this role.

3.Click EQuIS, point to Configure, and select Configure Database User(s).

 

Accessing - EQuIS Enterprise Manager

 

1.Launch manager.exe

2.Log in to Microsoft SQL Server using credentials that are granted SQL sysadmin role. Typically, a Windows administration account is a member of this role.

3.From the Ribbon group Manage, select Users.

 

15384-ConfigureUsers

 

The form lists all SQL logins and the databases they have permission to access. When using SQL Express it is possible to add new SQL logins and establish basic permissions on the EQuIS Databases assigned to them by clicking User in the form footer. Checking Administrator grants the user membership in the SQL Server role sysadmin. Checking Creator grants the user membership in the SQL Server role dbcreator.

 

To assign an EQuIS Database to a user, select the user and click User Databases in the form footer. A new record will be entered. Select the database cell in the new record and select one of the EQuIS Databases hosted by the Microsoft SQL Server instance you are currently connected to. Checking Full Access grants db_owner role membership to the user for the selected database. Checking Read/Write grants db_datareader and db_datawriter role membership to the user for the selected database. Checking only Read-Only grants db_datareader role membership to the user for the selected database.

 

Warning: EQuIS Professional users will not be able to connect to an EQuIS Database and consume a license if the login credentials are only granted db_datareader membership. In this case a Read-Only login is only suitable for access to the EQuIS Database by third party tools (e.g. Microsoft Office, SQL Management Studio) when the user should not be permitted to modify any EQuIS data.