Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Security > best way to connect mssql2k

Reply
Thread Tools

best way to connect mssql2k

 
 
Guy Brom
Guest
Posts: n/a
 
      04-14-2004
Hi there,

I'm about to make a move from ODBC (dsn) connection to OLEDB native
Connection String.

I was wondering what is the best way to achive this, on this 2 scenarios:

1) IIS and SQL reside on the same machine
2) IIS and SQL are seperated

Should I use mixed mode with a strong username/password?
Should I use windows authentication and grant IIS_ANONYMOUS the right
priviliges? and if so, what are those priviligies?

Thanks!


 
Reply With Quote
 
 
 
 
Ken Schaefer
Guest
Posts: n/a
 
      04-15-2004
Microsoft recommends using Integrated Windows Authentication unless you have
a reason not to use this.

For IIS and SQL Server on the same box, just grant the IUSR_<machinename>
account logon rights, and appropriate accesses to the relevant databases
(just like if you were creating an SQL Server account).

For IIS and SQL Server on separate boxes, this won't work [1], because
IUSR_<machinename> is an account local to the webserver, and can't be
assigned permissions to remote resources. You'd need to use a domain account
(or similar) as the anonymous user account.

Cheers
Ken

[1] Unless IIS is running on a Domain Controller, in which case all accounts
are domain accounts. But running IIS on a DC is generally not recommended.


"Guy Brom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
: Hi there,
:
: I'm about to make a move from ODBC (dsn) connection to OLEDB native
: Connection String.
:
: I was wondering what is the best way to achive this, on this 2 scenarios:
:
: 1) IIS and SQL reside on the same machine
: 2) IIS and SQL are seperated
:
: Should I use mixed mode with a strong username/password?
: Should I use windows authentication and grant IIS_ANONYMOUS the right
: priviliges? and if so, what are those priviligies?
:
: Thanks!
:
:


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Best way to connect a Cisco router to a Norstar Meridian Cisco 0 04-07-2004 02:38 PM
Re: Best way to connect a Cisco router to a Norstar Meridian VOIP 0 04-07-2004 02:38 PM
Re: Best way to connect a Cisco router to a Norstar Meridian VOIP 1 04-07-2004 11:45 AM
Re: Best way to connect a Cisco router to a Norstar Meridian Cisco 1 04-07-2004 11:45 AM
what is the best way to connect to a sql database? msn ASP .Net 2 02-08-2004 04:40 AM



Advertisments