ASP & SQL Problems

[GWatson]

I have setup a new SQL server, but this time on Windows 2003 box. Used the "Copy Database Wizard" to copy the database server to the new SQL server. Created a new ODBC connection, created a new site with in IIS to allow me to test it. All the settings are the same in IIS as the old database site. The ASP files etc are all the same, except for the line which defines which ODBC connection to use.

The ASP file looks like this:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_Phone_STRING
MM_Phone_STRING = "dsn=PhoneTest;uid=phoneuser1;pwd=*******;"
%>"

Error Message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'user1r'. Reason: Not associated with a trusted SQL Server connection.


Intranet server - Windows 2000
SQL Server - Windows 2003 Server with SQL 2000 SP3a

This problem is resolved by enabling "allow anonymous SID/Name translations" within the security policy on the SQL server. However, this is a potential security threat and Microsoft don't recommend it.

Tried or verified so far:
SQL server is set to use "SQL Server and Windows" authentication
ODBC connection is fine on the Intranet server "Test Succesful"
All the IIS settings are the same
All the ASP and web files are the same, just copied over.

 

[Lothario]

Did you go through this KB

http://support.microsoft.com/kb/307002/EN-US/

-L