My SQLConnection fails from an aspx using Basic authentication and an
integrated authentication connection string. An ASP in the same folder
works 100% OK and I am also able to connect to and work with the database
using my Windows account through Visual Studio 2003 as well as SQL
Enterprise Manager - so it seems as though permissions are configured
correctly on the DB.
Here's my error message:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Here's my connection string:
data source=mySQLserver;initial catalog=WEB_USAGE_DEV_DB;Integrated
Security=True;workstation id=ASP_NET
What am I missing? Why isn't the aspx/IIS sending my credentials to SQL
Server (when an ASP in the same folder with the same connection string is)?
--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/