connection string does not work for a different server

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.Can you post the error/exception you get?
Vikram Vamshi
Eclipsys Corporation
"Carlos" <chsanin@.earthlink.net> wrote in message
news:u52OyjIGFHA.3824@.TK2MSFTNGP10.phx.gbl...
> 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.
>