January 13, 2010 at 4:34 pm
Hi All,
I am trying to set up access to a web based reporting application for users outside of my network and am not sure how to set up user accounts and how authentication can be handled.
The application currently does not require a username/password input as the users domain and login are passed directly to the Db and all of the required access is handled there.
Have set up firewall access from the remote location but not sure how to set up SQL to recognise and accept connections.
Any help would be appreciated.
Cheers
Andy
January 13, 2010 at 8:30 pm
Andy Carroll (1/13/2010)
Hi All,I am trying to set up access to a web based reporting application for users outside of my network and am not sure how to set up user accounts and how authentication can be handled.
The application currently does not require a username/password input as the users domain and login are passed directly to the Db and all of the required access is handled there.
Have set up firewall access from the remote location but not sure how to set up SQL to recognise and accept connections.
Any help would be appreciated.
Cheers
Andy
You have to do two things manually add the people to SQL Server on the server level in management under security to create the login and add the people to the database. Then make sure these people can use the database and then you need to create an authorization section in the application Web.Config and define an allow section. Check the thread below for existing code you can use.
http://www.sqlservercentral.com/Forums/Topic840117-146-1.aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply