SQL Server on Windows XP Pro and ASP

I want to set up SQL Server on Windows XP Pro so that I can use the database
capabilities of ASP and IIS. I am probably using some incorrect settings,
but I am not sure what they are. Here is what I am currently doing:

Nathan Sokalski wrote:
> I agree that the site about what the connection strings should look
> like is a very good site, but I think my problem is in the settings
> in my configuration. I am having trouble figuring out what settings I
> need to change, and what I need to change them to. I think it would
> help me more if someone told some of the changes I need to make in
> control panel,

No one has told you any because there aren't any. As long as you have MDAC
installed (which is very likely due to the fact that you did not get a
"could not create object" error, you should be able to connect to the
database without making any settings in the control panel.

I suspect your problem is due to your attempt to use integrated security.
Beginners usually do not realize that asp is not running under their
security: the Internet Guest account is the account used when asp pages are
running.

Instead of attempting to use integrated security, I suggest creating a SQL
login using SQL Enterprise Manager (have you installed the SQL client
tools?).

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

You are attempting a connection from an app that allows anonymous access. It
uses the IUSR account to connect when a non-domain account connects.

You have choices:
1) Get rid of anon access and force all users to log in
2) Switch to mixed mode authentication (ie, adding a user name and password)
NOTE: SQL Server will have to be set up mixed mode.
3) Add IUSR_ComputerName (where ComputerName is the name of the computer in
question) to the SQL Server (works real well, but a major security hole).

Share This Page

Welcome to The Coding Forums!

Welcome to the Coding Forums, the place to chat about anything related to programming and coding languages.

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. You'll be able to ask questions about coding or chat with the community and help others.
Sign up now!