Connecting to SQL Server from Web pages

[Robert]

What user/account do I need to setup on my SQL 2000
Server, that requires the use of a Trusted Connection
(Integrated Security=SSPI), in order for my postings to
be able to make a connection to the database.

The SqlConnection would look something like this?

Data Source=MYSQL01;Initial Catalog=WebDB;Integrated
Security=SSPI;Persist Security Info=False;

Under what authority are postings going to be running
under in a MCMS site? This is a public site that we can
assume the end user will not be required to log into.

Web server is Windows 2003 using IIS 6.0 with MCMS 2002.
SQL 2000 server is also running Windows 2003 and only
allows trusted connections.

Is it the IUSR that needs to be added to the SQL Server
as a valid login? Or some other system account?

 

[Cowboy \(Gregory A. Beamer\)]

You are best to run the data access thread under a trusted account than to
attempt to set up IUSR_ComputerName as a trusted account. It takes a bit
more programming, but reduces a potentially huge security hole. It is much
easier to simply allow IUSR access if simplicity is your sole goal.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

 

[Robert]

Ok, how would I go about running the data access thread
under a trusted account? How do I set this up? Sorry,
but I am very new to the .NET development environment.

 

[Robert]

When using a SqlConnection to connect to a SQL 2000
server does the connection string need to specify a
Provider?

Is this a valid way to specify a connection to a SQL
Server?

Dim myConn As New SqlConnection("Data
Source=MYSQL01;Initial Catalog=MyWebDB;Integrated
Security=SSPI;Persist Security Info=False;Application
Name=MyAppName;")

Do I need to specify a "Provider" in the above connection
string?

 

[George Ter-Saakov]

You are using OLE DB connection. You suppose to use it only with OLEDB
package,
With SQL package use folowing
"server=MYSQL01;Trusted_Connection=false;database=db;User
ID=usr;Password=pwd"



George.