JP Sartre could have helped but:

DWMX2004 on XPproSP2 with IIS5.1 in and asp.net application on an SQL 2000 server

When testing an SQL server connection I get a message saying that the connection is open but the SQL server does not exist or that access is denied.

The same data source/catalog/uname/password are allowed in enterprise manager and to create a DSN from DW if I have MMHTTPDB.asp open.

Nor can I view live data.

If I access the database with a browser from a URL, all the controls for add/edit /delete work fine. Thus the server seems to be A-OK.

So how do I properly establish a connection.

Yes I have uploaded the web.cofig which looks like this:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="StoreFrontConfiguration" type="StoreFront.SystemBase.StoreFrontConfiguration, SystemBase" />
</configSections>
<StoreFrontConfiguration>
<add key="StoreFront.DataAccess.ConnectionString" value="Provider=SQLOLEDB;server=UUUU.VVV.com;uid=XXX;pwd=YYY;database=ZZZ;Connection Reset=FALSE" />
<add key="StoreFrontLogging" value="false" />
<add key="ProductLoading" value="1" />
<add key="CleanUp" value="1440" />
</StoreFrontConfiguration>
<startup>
<supportedRuntime version="v1.0.3705" />
</startup>
<system.web>
<pages smartNavigation="false" />
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation about
debugging ASP.NET files.
-->
<compilation defaultLanguage="vb" debug="false" />
<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.
<customErrors mode="RemoteOnly" />
-->
<customErrors mode="On" defaultRedirect="error.html" />
<!-- AUTHENTICATION
This section sets the authentication policies of the application. Possible modes are "Windows",
"Forms", "Passport" and "None"
-->
<authentication mode="Windows" />
<!-- AUTHORIZATION
This section sets the authorization policies of the application. You can allow or deny access
to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous
(unauthenticated) users.
-->
<authorization>
<allow users="*" />
<!-- Allow all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page within an application.
Set trace enabled="true" to enable application trace logging. If pageOutput="true", the
trace information will be displayed at the bottom of each page. Otherwise, you can view the
application trace log by browsing the "trace.axd" page from your web application
root.
-->
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong to a particular session.
If cookies are not available, a session can be tracked by adding a session identifier to the URL.
To disable cookies, set sessionState cookieless="true".
-->
<sessionState mode="InProc" stateConnectionString="tcpip=localhost:42424" sqlConnectionString="" cookieless="false" timeout="20" />
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
<appSettings>
<add key="MM_CONNECTION_HANDLER_vetcart" value="sqlserver.htm" />
<add key="MM_CONNECTION_STRING_vetcart" value="Persist Security Info=False;Data Source=[UUU.VVV.com];Initial Catalog=[XXX];User ID=[YYY];Password=[ZZZ]" />
<add key="MM_CONNECTION_DATABASETYPE_vetcart" value="SQLServer" />
<add key="MM_CONNECTION_SCHEMA_vetcart" value="" />
<add key="MM_CONNECTION_CATALOG_vetcart" value="" />
</appSettings>
</configuration>