I am working in a joint venture of four different contractors doing one big project. Many of the application will have to use the different ADFS servers each of the four companies have. Some are desktop application connecting directly to SQL which will be hosted in IaaS. Can SQL Server grant permissions to four different domains?

  • you're going to have to get creative here with SQL Users, a proxy server in front of the sql server, or move the domains in a forest and make trust relationships between them. – Ali Razeghi Jan 29 '17 at 1:44
  • you mean reverse proxy? how would I go about doing that? I don't think they will want trust between the domains it's just a project not a merger :) – j. doe Jan 29 '17 at 10:21
  • naw, a reverse proxy will help you traverse network level issues but not domain level issues. Sadly in this case you might need to use SQL Server users and talk about it with your security team – Ali Razeghi Jan 29 '17 at 19:46

DB Links can be configured with different accounts for each DB Link. But it would still be an ugly mess as far as security and management.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.