This check is performed on the SQL Server that host's GoldMine's Database.
To check to see what database mappings and roles a username has, 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 (usually (local)) where the GoldMine database is located.
|
| 5. | Expand the Security folder.
|
| 7. | Right-click on the SQL User and select Properties.
|
| 8. | Click on the Database Access tab.
|
| 9. | Verify that the Permit checkbox is checked next to the GoldMine database in the Specify which databases can be accessed by this login section.
|
| 10. | Verify that the db_owner checkbox is checked in the Database roles for section. |
| 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 SQL User and select Properties.
|
| 6. | Click on the User Mapping page in the left column.
|
| 7. | Verify that the Map checkbox is checked next to the GoldMine database under the Users mapped to this login: list.
|
| 8. | Verify that the db_owner checkbox is checked in the Database role membership section. |
Return to the Pre-Installation Checklist
