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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-19 : 07:46:15
|
| Sami writes "We are about to host SQL Server 2000 database in the web. We have 2 types of users. Browse and Update. We want to create 2 ODBC data sources using different user ids, one for each, so that the browse pages have only the browse data source.I read everywhere that windows authentication is better than SQL Server authentication. How can I use windows authentication to have two different data sources with different users and authorization?Thanks®ardsSami" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-19 : 14:33:58
|
| The DSN will use whoever is logged into the system unless it is a service. If it is a service, it will use the logon account information for the service. So if you create two services, if the application is service based, then you could use two different accounts. But if the application needs to be running on the desktop in order for it to be up and running, then you can't use two different accounts for Windows authentication.Why are you trying to do this though?Tara |
 |
|
|
|
|
|
SQL2K authentication and security in web environment