Wiki

Options

New Case Case Status
Log In

Wiki

Options

 
Knowledge Base Articles»KB100016 - EtaPRO SQL Server D…
  • RSS Feed

Last modified on 12/5/2018 5:05 PM by User.

Tags:

KB100016 - EtaPRO SQL Server Databases - Attaching a database/Configuring a user

Attaching EtaPRO SQL Server Databases

Using SQL Management Studio

 

In this step, databases can be attached using the SQL Management Studio.

1. Launch SQL Server Management Studio from the Start|All Apps|Microsoft SQL Server 2014 menu.

 

2. If the account used to install software is not a SQL sysadmin, you will need to use the default “sa” account installed with EtaPRO (SQL Express, Password: Changeme1!) or an alternative SQL sysadmin account. If SQL was not installed by GP Strategies, the person installing SQL Server should provide the SQL sysadmin account information. To connect to the server, change Authentication to SQL Server Authentication and enter the Login and Password.

 

3. Click Connect to open Microsoft SQL Server Management Studio. Right-click on Databases node and select the Attach…command

 

4. The Attach Databases dialog displays. Click the Add button to browse for a database file. Select the database and then click OK.

 

5. The Locate Database Files dialog displays. Select the database and click OK.

 

6. Click OK on the Attach Databases dialog to complete the task. The database is now displayed under the Databases node.

7. Repeat these steps to attach additional EtaPRO databases.

 

 

Configuring a SQL Database User

The SQL account used to run EtaPRO must have database owner permissions for each of the databases used by EtaPRO. This can be achieved by using the “sa” user account. For enhanced security, it is recommended that a separate user with limited permissions be used. A SQL Database user for use with EtaPRO can be created as follows:

 

1. Launch SQL Server Management Studio from the Start menu.

2. If the account used to install software is not a SQL sysadmin, you will need to use the default “sa” account installed with EtaPRO (SQL Express Password: Changeme1!) or an alternative SQL sysadmin account. If SQL was not installed by GP Strategies, the person installing SQL Server should provide the SQL sysadmin account information. To connect to the server, change Authentication to SQL Server Authentication and enter the Login and Password.

3. To verify the correct SQL configuration, right-click on the SQL Server instance name node and select the Properties command.

4. Click Security node to verify that the SQL Server and Windows Authentication mode (mixed-mode) is selected.

5. Click OK and expand the Security|Logins branch.

6. Right-click on the Logins node and select New Login… command

7. A new SQL Server account will be created using SQL Server authentication. GP Strategies recommends the name “etaproservice” or some variation. Set the password and take care not to lose it – it will be needed later during the EtaPRO Configuration Settings step.

8. Grant the new account public permissions.

9. Now map the newly created EtaPRO SQL account to the EtaPRO SQL databases. Expand the Security|Logins node and right-click on the new etaproservice (or comparable) account and select the Properties command.

10. The Login Properties dialog displays. Click on the User Mapping option. Place a checkmark next to each EtaPRO database to map to this account. Assign all databases the db_owner role. For an EtaPRO APR database, the db_ddladmin role should also be selected.