...
- Create / edit your service user. This is the user you will use to run the Configuration service. This user should have reader/writer permissions on the two databases you've created.
Run Now run the Configuration Wizard (under the Install user's account). On the database connections tab, ensure that the 'Install User' account matches the install user account you setup in the database. Ensure that the 'Don't Create...' checkbox is checked.
Info title Windows Authentication If you are using Windows Authentication, the ConfigurationWizard must be run from the Windows Domain Account that has db_owner permissions on the database. Alternatively, you can use the runas command to impersonate this user. Run the following from a Windows command prompt:
runas /user:MyUser ConfigurationWizard.exe
...
wizard using an account that has (at minimum):
DBO permissions on the database (in order to create tables, edit schemas etc.)
Local administrator rights (in order to manage local folders, services, certificates, etc.)
You may need to use the 'runas' functionality from a command line in order to impersonate a user which has these required privileges:
| Code Block | ||||
|---|---|---|---|---|
| ||||
runas /user:MyUser ConfigurationWizard.exe |
Please ensure that on the connections tab of the configuration wizard you have checked the 'Skip Sql Server sysadmin operations...'