Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Server Database grants required
#1
Is there a list of exact database grants that are required to log in to a SQL Server ASG RemoteDesktop 2015 database?
 
I have created a database through the RemoteDesktop 2015 application GUI, and am using Windows domain Authentication to log in to the database.  My account has dbo permissions on the database, and administrative permissions within ASG RD.  I am able to access the database.  I have added selected users via the Tools ---> Security Groups panel in RemoteDesktop 2015.

None of these users are able to log in.  From the database side, they have all been granted db_datareader, db_datawriter, and execute access to the ASGRD database.  From the setup screen, we are able to test create / test the connection successfully as these users.  We are also able to connect to and query the database via SQL Server Management Studio.
 
However once we try to open the connection, ASG fails to log in.  Are there additional permissions required within the app or on the database itself?  When dbo permissions are (temporarily) added to any of these users in the database, the login works fine...but this isn’t obviously feasible in the long run.  This indicates to me that there may be some database permissions that need applying.
Reply
#2
There are 2 parts of security - the db_datareader, db_datawriter and execute is one - the other is if you right click the database goto Properties => Permissions

From Help file => select your ASG-RD database and goto Properties. In the category "Permissions" you have to grant your user(s) the right to "Connect", "Execute" and "Select".

Did you check this?
Regards/Gruss
Oliver
Reply
#3
(16-06-2017, 11:09 AM)DevOma Wrote: There are 2 parts of security - the db_datareader, db_datawriter and execute is one - the other is if you right click the database goto Properties => Permissions

From Help file => select your ASG-RD database and goto Properties. In the category "Permissions" you have to grant your user(s) the right to "Connect", "Execute" and "Select".

Did you check this?

Thank you, that did the trick.
Reply




Users browsing this thread: 1 Guest(s)