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
Related Articles
Spider Setup: System Requirements - SQL server verify sql user database authorization 6Number of Views Spider Setup: System Requirements - SQL execute permissions on database msdb 19Number of Views Spider Setup: System Requirements - SQL Server 7Number of Views Spider Setup: System Requirements - SQL server get available all database names 5Number of Views Spider Setup: System Requirements - Microsoft .Net 9Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago