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