Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ksenthil
Starting Member
1 Post |
 Posted - 2009-08-13 : 14:35:21
|
I am new to SQL 2005. I want to give SQL authentication login to developer to have in web.config file for developer to access sql server through application. But same time i don't want developer to login in the SQLCLIENT using the same login and password. Please help. Thanks, It does not matter how slowly you go so long as you do not stop. --Confucius-- |
|
|
EMarkM
Starting Member
16 Posts |
Posted - 2009-08-14 : 06:48:58
|
| Rather than a SQL login, you could create a Windows user in Active Directory for the application to "run as", and only grant access to that user.Don't tell the developer the password for this Windows user: just get an admin to make sure that that's what the app runs under. This will work if the app runs as a service, but I don't know enough about application authentication (or your specific case) to state whether an ad hoc connection could be set up in this way.Let us know how you get on... |
 |
|
|
|
|
|
Assign Application role in sql authentication