This action is performed on the SQL Server that hosts GoldMine's Database.
To create a new SQL User, do the following:
| 1. | Open Enterprise Manager.
|
| 2. | Login as either sa or Administrator (or a user with equivalent privileges).
|
| 3. | Expand the Microsoft SQL Servers object.
|
| 4. | Expand the SQL Server where the GoldMine database is located.
|
| 5. | Expand the Security folder.
|
| 6. | Right-click on Logins and select New Login.
|
| 7. | Provide a Login name in the Name field.
|
| 8. | Select SQL Server Authentication.
|
| 9. | Provide a password in the Password field.
|
| 10. | Change the default database to the GoldMine database for the Database drop down under Defaults.
|
| 11. | Click on the Database Access tab.
|
| 12. | Click Permit next to the GoldMine database in the Specify which databases can be accessed by this login section.
|
| 13. | Click db_owner in the Database roles for section.
|
| 15. | Reenter the password set in step 8 when prompted. |
| 1. | Open SQL Server Management Studio.
|
| 2. | Login as either sa or Administrator (or a user with equivalent privileges).
|
| 3. | Expand the Security folder.
|
| 4. | Expand the Logins folder.
|
| 5. | Right-click on the Logins folder and select New Login.
|
| 6. | Provide a Login name in the Login Name field.
|
| 7. | Select SQL Server Authentication.
|
| 8. | Provide a password in the Password and Confirm password fields.
|
| 9. | Uncheck the following: Enforce password policy, Enforce password expiration and User must change password at next login.
|
| 11. | Click Map next to the GoldMine database in the Users mapped to this login section.
|
| 12. | Type dbo in the Default Schema field.
|
| 13. | Click db_owner in the Database role membership section.
|
Return to the Pre-Installation Checklist
