Posts: 13
Threads: 7
Joined: Apr 2020
Reputation:
0
We have a shared Windows Server trying to run ASG with SQL Server on the same server setup with Integrated Windows login. We have licensing for the correct number of admins. I setup and added all of the RD connections in ASG. When my other users login to ASG they already have the database environment showing up but when they try to 'Test Connection' they get the error message of "Connection check failed - The database 'ASGRD' does not exist. Validate the database name". I know this database exists and I know it's not the firewall since everything is on the same server. I verified the other users are entering the same information I'm entering but they get the error message when trying to test the connection to the database. The ASG RD software and the db are all on this Windows Server server which we all login to with individual credentials for accessing our assets. I did use Mixed Mode authentication as well when setting up the database.
Is there guidance on setting up multiple users in the ASG RD software to access the database I created when installing?
Posts: 11,123
Threads: 100
Joined: Aug 2006
Reputation:
202
If you are using "Windows Auth" for accessing the SQL server - you have to check that all users have permissions to access the database? Perhaps try to assign them all to dbowner in SQL Management Studio - you find the documentation on which rights are needed for ASGRD database in online help (just press F1 in the database wizard) - but there is no documentation how to setup your users on the SQL Server
Regards/Gruss
Oliver
Posts: 13
Threads: 7
Joined: Apr 2020
Reputation:
0
So when I setup the database. The installation set me as the only user in the database it created? Now I need to go into the database and add each of the new users to give them access? Is there a way in ASGRD to add this access?
Posts: 13
Threads: 7
Joined: Apr 2020
Reputation:
0
I got it figured out. I mirrored my permissions for the Windows group I wanted to have access in SQL Server Management Studio (Server > Security > Logins > New Login). Everyone is able to access a shared environment now. It would be nice if we didn't have to do this in SQL Server Management Studio and this could be done through ASG software. This should be fairly straight forward to implement since the user who installed has sysadmin privileges to that SQL Server Express instance. This would make your future users not have to worry about this undocumented step.
