March 20, 2009 at 5:29 am
We are looking at allowing external users access to one of our SQL Servers via a Web App.
What are the recommended solutions for this type of requirement in terms of what type of SQL Login / AD Account to use etc?
March 20, 2009 at 9:25 am
Hi Steve,
It all depends on what these external users are going to do. Windows Authentication would be good to manage since you can put them all in a group and give appropriate permissions to that group.
-Roy
March 20, 2009 at 9:43 am
They would need to access a Web App which in turn would have a SQL Server back-end.
Yes - I was thinking an AD Group / User. Add the group / user to SQL Server with access to relevant DB and then let the app control more granular security.
Would the Web App have to sit in the DMZ?
March 20, 2009 at 1:06 pm
What does the App actually do? Is it a place where they can write SQL's or is everything controlled by the Web App?
If it is just a normal application, then you need only one user in the DB and that will be the user that connects from the Web App. The permission to access the web app can be done by using Windows Authentication on the IIS where the Web App is residing.
Did I make sense to you?
-Roy
March 23, 2009 at 2:50 am
Everything is controlled by the Web App.
And yes all that makes sense. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply