ASG-2015P2 with SQL2012Express -> Permission Problem

[ditro]

Hello Forum,

I've installed a SQL2012Express and ASG2015-P2 on a new 2012R2 server.
I started the ASG App as Administrator and created a new Database.
I checked the box set environment for all users but this doesn't happen.

When I try to open ASG as normal User there is no environment configured and I can not connect to the existing one.

How can publish the environment to all users?

[DevOma]

Please search for "environments.xml" - checkbox "For All Users" should save this file in AllUsers-Profile - else in your User-Profile

%AppData%\Roaming\ASG-RemoteDesktop\8.0

[ditro]

Hello Oliver,

thank you for your fast reply. That worked.
But now I got the next problem.
The user seems to have no permissions.

[DevOma]

That seems to be a SQL permissions problem - I think you try to use "Integrated" for your SQL connection - then you have to ensure that your windows users have access to the database - check Security of your SQL instance and check if your domain users are granted for the DB

[ditro]

Hello Oliver,

I can also use SQL authentication.
What permissions does the normal user need?

can you send me screens?

kind regards
Dennis

[DevOma]

Try first to set db_owner for your ASGRD database to ensure that this is the right problem :-)

Users need "Connect" and "Execute" - that should work

In MSSQL Management Studio => Security => Logins - click on your user or add one (you can also add Domain groups) - then goto "User mapping" - public is nneded for accessing the db, db_owner for testing - afterwards you can disable "db_owner" and goto your SQL instance => Properties => Permissions - there you can select your db and add Connect and Execute

[ditro]

Hello Oliver,

with SQL authentication I can connect to the database but not with AD authentlication.
It seems, that there is a issue with the AD authentication.

Is there a way of getting debug logs?

kind regards
Dennis

[DevOma]

Perhaps you did not activate TCP/IP protocol - I don't know if this causes the problem but you should try

SQL Server Configuration Manager => Network Configuration => Protocols

There is no log - if you try to connect to an MS SQL Server you get the whole error

[ditro]

Hello Oliver,

it is not a SQL Permission problem.
The Security Group settings within the ASG-RD are missing.
I had to recreate them.

Is there a Guide for Admin Settings and User Settings?
Which is best for Users?

How can I prevent Users from deleting Connection but Add them.

Kind regards
Dennis

[DevOma]

Nobody could decide how you want to setup your security... Thats your part.

Goto properties of a folder or connection - click on Security - there are all options you need...

[ditro]

Hello Oliver,

thats true. The Problem was - that I looked on the wrong places to configure the security settings.

Now all is fine.

kind regards