<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am a bit desperate for some help. &nbsp;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:<br />
<br />
&quot;Database schema could not be retrieved for this connection. &nbsp;Please make sure the connection settings are correct and that the database is online&quot;<br />
<br />
&quot;Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection&quot; <br />
<br />
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.<br />
<br />
This worked yesterday. &nbsp;It does the same on all existing SQLAdapters and new ones.<br />
<br />
Any help would be great
</div>
</div>


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

Problem with SQL Adapter ASP.NET VWDE 2005

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.