Problem with SQL Adapter ASP.NET VWDE 2005

Hi,

I am a bit desperate for some help.  All of a sudden when in VWDE 2005 and I click on a SQLAdapter and try and edit the connection (run through the wizard) I get the following error:

"Database schema could not be retrieved for this connection.  Please make sure the connection settings are correct and that the database is online"

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection"

I have the correct user in the users section on my SQL 2000 database and I have the impersonate line with the same user name in my web.copnfig file.

This worked yesterday.  It does the same on all existing SQLAdapters and new ones.

Any help would be great
2326acAsked:
Who is Participating?
 
Vadim RappCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.