ASP connection to SQL 2008
Posted on 2010-09-16
We recently completed an upgrade to our database from MS SQL2005 to MS SQL 2008. The upgrade is finished & our custom database application connects to the new db successfully. I also have an ASP (classic) web page which connected to the 2005 database to pull down some info from one of the tables as reports. It worked fine under the SQL2005 server, but stopped working after the upgrade. I get the error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I've tweaked with the the connection string dozens of different ways with no success. I was able to create a .udl file with a successful connection, but that connection string didn't work either. I've tried both Windows Integrated Authentication & SQL authentication (the SQL server is set up to use both) with no results. Users & Roles are set up in the new 2008 database exactly how it was on the 2005 database (like I said, our db application works fine).
The odd thing is that when I go into IIS Manager on our web server (it is an isolated intranet), I can to into directory security & if I change the authentication method to "Enable anonymous access" the page starts working. I don't want to leave this enabled because of other reasons. The thing is, I never had to have this enabled before the upgrade, everything worked fine then. I just don't know why allowing anonymous access to the website would start the page working again. The user account used by anonymous access doesn't even have rights in SQL.