Login from different domains

[Sahlsa]

I have installed my ASG-RD database on domain A, and given the domain users Connect, Select and Execute rights in SQL. If they logon to the DB-server and start ASG-RD it works fine with and witout the integrated logon.

If ASG-RD is installed on the laptops which are in Domain B (no trust), they are not able to connect, even if "integrated logon" is disabled and the login/pass/domain is entered manually.

The issue is that on the DB access tab there is also a logon which looks like it can only be a local user. I would like to avoid handing out the SA-login, but how can the users access the DB when they cannot use the integrated logon ?

If I type in the SA-login when editing the connection it works, so the domain logon for the first part works.

[DevOma]

As you mentioned - there are 2 different logins - for the application login you can use untrusted domains (with the latest version) - for the SQL-Server you can do it also - you have to specify a domain user for the "Database Access Properties" - you also can use a local database user (instead of using sa user)

[Sahlsa]

What is the syntax for a domain login to the database ?

There is no option for choosing a domain and I have had no luck with name@domainA or domainA\username.

[DevOma]

Ok I tested myself and it seems not to work.

I think the best solution would be to create a local database user and grant the permissions you want to this user - so you do not need to give your sa account credentials to anybody else. I think that's the only solution