Monday, March 19, 2012

Connecting to MS SQL server 2000 from the different domains using asp.net

Hi,

My problem is somewhat like this that, i want to connect my all applications (developed in asp.net) to one database. In other words i want to make a centralised database that can be accessible from the application running at the different domains. When i did so by using the same username, password, database and server...i recieve an error that,"connection cannot be establised".

If any body have the solution for this problem. then please do write the "connection string" for me that can be efficiantly used on the applications running on differnt domains.

Thanks and Regards,

Steve Dcosta

Considering the domains trust each other and that you have the proper rights for accessing the database server from each of the different domains you can try the following connectionString replacing the correct values for the variables:

data source=putIPHereIncaseNameResolutionFails;user id=user;password=yourPassword;initial catalog=databaseName;persist security info=True

No comments:

Post a Comment