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" <an*******@discussions.microsoft.com> wrote in message
news:c7****************************@phx.gbl...

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?

[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.

-----Original Message-----
You are best to run the data access thread under a trusted account than toattempt to set up IUSR_ComputerName as a trusted account. It takes a bitmore programming, but reduces a potentially huge security hole. It is mucheasier 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" <an*******@discussions.microsoft.com> wrote in messagenews:c7****************************@phx.gbl...

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?

.

[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?

-----Original Message-----
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?
.

[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.

"Robert" <an*******@discussions.microsoft.com> wrote in message
news:d6****************************@phx.gbl...

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?

-----Original Message-----
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?
.