Summary
Spider setup issues a warning that you are not able to create SQL users.
Cause
The user you have provided to the setup to connect to the SQL server (if you did not specify a separate user, it is the user account you are logged on with) does not have the permission to create an SQL user on the server.
Resolution
- Assign the user the privilege to create users.
- Create the users you want to use, using an account with the privileges to do so
Additional Information
It is possible to use SQL users that have been created beforehand by an administrator. In this case you do not need the privileges to create users on the SQL server.
If you choose to create the users beforehand, you need two user accounts.
- Spider-Login
- This login is used for the application to connect to the database, also the services use this login
- SpiderAdmin-Login
- This login is used for connections with the Admin Tool
The names of the logins are not preset and can be chosen to fit your environment.
How to: Create a SQL Server Login