"Linchi Shea" wrote:

> > We checked that a connection can be made from an outside application to all
>
> An obvious question, but did you try to connect to the SQL instance from the
> web server machine using osql.exe with the same ODBC DSN name? Also try it
> with a SQL Server login.
>
> Linchi
>
> "itmanager" wrote:
>
> > We are running into a strange problem here. We have a web application running
> > under .NET 1.1 that connects to various SQL Server instances identified
> > through a series of System ODBC DSNs set up on the web server.
> >
> > If the SQL Server is running on a regular standalone server, we can connect
> > without a problem; however, if the SQL Server instance is running on a
> > virtual server (using VMWare), the following error is returned:
> >
> > SQL Server does not exist or access denied.
> >
> > We checked that a connection can be made from an outside application to all
> > SQL Server instances and the user name and passwords are valid. As this
> > problem appears to be happening only when using running under a web
> > application, it appears it may have something to do with the security context
> > of the web user - we tried using various accounts to no avail.
> >
> > Is there anything different that one has to use in a connection string in
> > order to connect to a SQL Server running in a virtual server environment?
> >