connect sql 2005 database that is another sysem using asp.net

[azad yadav]

Hi friend, I want to know how to connect sql server 2005 when i am working on another pc in (XP).

[specialdreamsin]

Hi To connect to remote system use this connection string "Data Source=IPAddressOfRemoteSystem,1440;Initial Catalog=YourDB;User ID=uid;Password=pwd; Ramesh Sambari

Knowledge is like honey. Collect it, to make life sweet.

[Manas Bhardwaj]

There is something called ConnectionString[^]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[Mathew P V]

for the database to connect you may have used windows or sql authentication if it is sql authentication connect with the help of the computername and password ie.administrator username and password in the connection string. i think that will do.

[K0306]

you can write the connection string in web.config file and use these connection abject in any where in your project. like and use like this in your form string strSqlCon = ConfigurationSettings.AppSettings["ConnectionString"];