sql server connect: connection string does not work for a different server -- sql server connect

connection string does not work for a different server

Carlos
2/21/2005 9:48:09 PM

sql server connect:

Hi all,

I currently have an ASP .Net project running locally,
and accessing a local SQL server 2000 database. The
project runs fine since it is able to open the connection to the database,
and perform operations on it locally using
a connection dtata string pointing to the local data source.
However, when I wanted to point to a different server
using the same definitions, the connection did not work.

The only changes have been the name of the data source.
From (local) to SQL9, and the catalog from openhouse to srm. A user with the
same ID, and password was defined
in the target SQl server using the same permissions, and the authentication
is windows and SQL server.

I am able to ping to the server, and access the tables of this database
using enterprise manager using the user
that was defined. At this point I do not know what to
do. Any suggestion is greatly appreciated.

Thanks,

Carlos.

Re: connection string does not work for a different server

Vikram Vamshi
2/22/2005 12:27:50 PM

Can you post the error/exception you get?

--
Vikram Vamshi
Eclipsys Corporation
[quoted text, click to view]