Connect to SQL Server database from classic ASP using windows authentication

Question

I am normally a .NET developer so have no experience with classic ASP.

I have been asked by a client to have a look at their classic ASP site. I am trying to recreate their site on my local machine so can have a play with but am having difficulty connecting to my copy of the database. The database has been recreated on SQL Server 2008 using windows authentication and I'm having difficulty with the connection string.

This is what I have so far:

Provider=SQLOLEDB;Data Source=MY-PC\SQLExpress;Initial Catalog=testdb;Integrated Security=SSPI;Persist Security Info=False;

Keeps saying

login failed.

Any ideas?

AnthonyWJones · Accepted Answer · 2012-04-17 17:39:17Z

3

Modify the anonymous user account details that your local site uses to your own logon account.

The problem is that ASP scripts always run using impersonation either of the user associated with an authenticated connection or as the anonymous user account. The anonymous user is normally the rescricted IUSR account.

You could just turn off anonymous access and turn on Windows Integrated but I find its best for local development purposes to just change the anonymous user.

answered Apr 17, 2012 at 17:39

AnthonyWJones

190k35 gold badges236 silver badges307 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Peden · Accepted Answer · 2012-04-17 16:14:04Z

1

You need to create a login/user in SQL Server for the identity of the app pool in which your application is running.

answered Apr 17, 2012 at 16:14

David Peden

18.6k6 gold badges56 silver badges76 bronze badges

Collectives™ on Stack Overflow

Connect to SQL Server database from classic ASP using windows authentication

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related