|
Home > Archive > Microsoft Content Management Server > February 2004 > How to connect to SQL from a posting
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to connect to SQL from a posting
|
|
| Robert 2004-02-06, 8:38 am |
| 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?
| |
| Stefan [MSFT] 2004-02-06, 9:39 am |
| Hi Robert,
you should post this question to an IIS/ASP.NET related newsgroup.
This is not a CMS related question.
Cheers,
Stefan.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert" <anonymous@discussions.microsoft.com> wrote in message
news:b45801c3ecf8$f6a74df0$a101280a@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?
| |
| Marcy 2004-02-10, 11:37 am |
| Robert,
Here is what we are doing. It works great and is very secure.
We connect to a custom database from our CMS site. The custom database is
on a separate SQL Server box. We use Windows Security to connect to SQL
Server.
Our CMS site is running on Windows 2003/IIS6.0. Our CMS site runs under the
Default App Pool in IIS. The App Pool Identity is set to run as the
Pre-defined Network Service Account.
You can create a login on your SQL Server for the Network Service account.
You must use the following syntax for the login: Domain\MachineName$
You can then grant appropriate rights to this SQL Server login.
As long as you're not using impersonation in your ASP.NET app then the
following connection string should work fine
Data Source=MYSQL01;Initial Catalog=WebDB;Integrated
Security=SSPI;Persist Security Info=False;
Hope this answer saves you lots of time.
-Marcy
"Robert" <anonymous@discussions.microsoft.com> wrote in message
news:b45801c3ecf8$f6a74df0$a101280a@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?
|
|
|
|
|