Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 11th, 2005, 05:59 AM
Authorized User
Join Date: Jan 2004
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server Connection String

I have an application that connects to a SQL Server 2000 database using Trusted connection. Authentication is acheived via user's Windows NT login passed to the database.

When using the following connection string, the data in the database can be seen:-
Conn="DRIVER={SQL Server};SERVER={MULTIMEDIA2};DSN=pms;DATABASE={cab inetoffice};uid=;pwd=;

However, IIS 6.0 has SPN set, therefore I changed the connection string to:-
Conn="Provider=SQLOLEDB.1;Data Source=MULTIMEDIA2;Initial Catalog=cabinetoffice; Integrated Security=SSPI; Persist Security Info = False;"

But now I can't see the data in the database. Eh??

Old January 11th, 2005, 06:15 PM
Friend of Wrox
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41

There is allot of information on this one everywhere you look on the net as well as this forum. Check out:


Wind is your friend
Old January 12th, 2005, 04:48 AM
Authorized User
Join Date: Jan 2004
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts


But what is happening here is that a Windows GROUP is created. SQL Server is on one machine and IIS is on another. You don't need to add the login IUSR_machine name in Sql. SQL will pick up the user from the Windows Group in the point above.

So why isn't this working?

Old January 12th, 2005, 02:49 PM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Where is the Group defined? On the SQL Server?

And where did you add the IUSR account to the group?

The IUSR is a *local* account, and cannot be used on a different server directly. You'll need to set up a mirrored account, or use a different (domain) account for IIS.


Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: This Mess We're In by P J Harvey (Track 7 from the album: Stories From The City, Stories From The Sea) What's This?
Old January 13th, 2005, 05:22 AM
Authorized User
Join Date: Jan 2004
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks, that was the right solution.

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Express Connection String dkaufmann VB Databases Basics 4 November 3rd, 2006 01:48 PM
Sql Server 2000 Connection String ricpue BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 July 5th, 2006 05:26 PM
Problem with SQL SERVER Connection String Non Linear BOOK: Beginning ASP 3.0 3 October 20th, 2005 12:35 AM
sql server 2000 connection string nikotromus Access VBA 6 February 13th, 2005 10:01 PM
connection string for sql server rj1406 ASP.NET 1.0 and 1.1 Basics 6 September 16th, 2004 02:49 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.