Posts: 9
Threads: 5
Joined: Mar 2015
Reputation:
0
Hi
We are using ASG RD Patch 7 with a SQL instance on a separate server.
Please can you advise what SQL permissions users require to connect to the database, be able to create/manage connections etc.?
Thanks
Posts: 11,127
Threads: 100
Joined: Aug 2006
Reputation:
202
Have a look into the help file => Working with environments => Working with database => Necessary permissions on SQL server instance
Regards/Gruss
Oliver
Posts: 4
Threads: 0
Joined: Aug 2009
Reputation:
0
Hi Oliver,
According to the manual db_datareader permission are only required during eval time. We imported our license key into ASG-RD 2015, but still all users require db_datareader rights to be able to login to the application. Is this a bug? We configured the permission as described in the manual. We are running ASG-RD 2015 Patch7.
Best regards,
Roland.
Posts: 11,127
Threads: 100
Joined: Aug 2006
Reputation:
202
Should not be needed - which sql version do you use - I configured that myself and wrote it afterwards to the online help - and it worked with no db_* permissions - only GRANT for "Connect" and "Execute"
Regards/Gruss
Oliver
Posts: 4
Threads: 0
Joined: Aug 2009
Reputation:
0
We're running SQL Server 2012 SP2. We're using Active Directory integrated login. The database was upgraded from ASG-RD 2012.
Posts: 11,127
Threads: 100
Joined: Aug 2006
Reputation:
202
Just tested it with SQL 2012 - if I only give the user the right "Connect" I can't login - when I GRANT "Execute" I can login and everything works fine... No db_* configuration - only public else you can't set permissions for that database/user combination
Regards/Gruss
Oliver
Posts: 11,127
Threads: 100
Joined: Aug 2006
Reputation:
202
Now I got an error accessing the Logs - don't know what is the difference - but I will update the documentation to "GRANT" also "Select"
Regards/Gruss
Oliver