Re: IIS Security Question
From: TheWanderer (nobody_at_spamcop.net)
Date: 10/31/03
- Previous message: Yoshihiro Kawabata: "Re: How to deny DBCC SQLPERF(logspace)"
- In reply to: digitalfish: "IIS Security Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 30 Oct 2003 23:58:10 GMT
I just use the SA account
"digitalfish" <digital.fish@ntlworld.com> wrote in message
news:3fa04383$0$12708$fa0fcedb@lovejoy.zen.co.uk...
> I have a windows 2000 server box running SQL 2000. This box is a domain
> controller, running AD, DNS, DHCP etc. SQL is currently using mixed-mode
> authentication, although this can be changed if necessary. My web server
box
> is a separate machine also running windows 2000 server, running IIS 6. I
> have created a user role in my database with only select permissions on a
> few tables - this role will be my 'internet user' account.
>
> How do I configure IIS (& ASP) on my web server to use this 'internet
user'
> role to connect to my database? Do I have to create a new user account in
> SQL and then hard-code the username and password in my ASP scripts, or can
I
> specify that IIS runs under a certain user account and then use windows
> authentication to communicate with SQL?
>
> Thanks for any help,
> df
>
>
- Previous message: Yoshihiro Kawabata: "Re: How to deny DBCC SQLPERF(logspace)"
- In reply to: digitalfish: "IIS Security Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
