SQL & ASP 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.

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 files are the same.

This doing my head in....

Graeme

 

[SQLSister]

Does the user have rights in the copied database?

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[SQLBill]

And sometimes if the user is in the new server/database, their permissions don't always get copied correctly. Then you end up with Orphaned Logins.

Refer to the BOL for help with that. (Also search this site for Orpaned Users and Orphaned Logins.)

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875