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 |
|
Robwhittaker
Yak Posting Veteran
85 Posts |
 Posted - 2002-12-09 : 05:29:53
|
| Hi all,this is just a quick question on what is possible/best thing to do.If we have an IIS server which servers various applications, where the data lives on a SQLServer DB, a) is there anyway to do windows authenticated logons to the SQLServerb) Are we best anyway, to have the different apps connecting as different users on the server depending on what DB they need access to, using a password authenticated connection string?ThanksRob |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-09 : 07:32:16
|
quote:
Hi all,this is just a quick question on what is possible/best thing to do.If we have an IIS server which servers various applications, where the data lives on a SQLServer DB, a) is there anyway to do windows authenticated logons to the SQLServerb) Are we best anyway, to have the different apps connecting as different users on the server depending on what DB they need access to, using a password authenticated connection string?ThanksRob
the answer for the second question: according to me it is always good to have seperate connection strings for different databases .regarding the first question yes there u can use the windows authentication mode for connecting the user to the database server:right click the sql server in enterprise manager ,under the connection heading change the authentication mode to windows .Edited by - harshal_in on 12/09/2002 07:35:57 |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-12-09 : 08:13:31
|
| I think this is possible, but sometimes the impersonation across a web server is tricky. I've never made it work real well and choose to separate the logins. Test it out before committing to this strategy. |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-12-09 : 14:38:44
|
| I've always used a seperate SQL Login and password for each application. Then assign rights accordingly. As far as I know you can not use NT Auth if SQL and IIS are on seperate machines unless you want it to be challange response and have them log in to the domain an extra time.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
|
|
Connecting IIS to SQLServer