How to access a Ms sql 2000 database on a remote server via ado.net
-
Hi, I need to access a database on a remote computer using ado.net. I'm using Ms Sql server 2000, and my computer is not on the same domain as the remote computer, but I physically have access to this computer. Can somebody help me about the procedure to use ? I already accessed ms sql 2000 databases but it was on my computer, so the server was '(local)'. How do I do for a distant one ? Is there a way of using the remote computer IP adressm, or something else ? Thanks for helping.
p.f. Goudjo-Ako Bringing our energy together !
-
Hi, I need to access a database on a remote computer using ado.net. I'm using Ms Sql server 2000, and my computer is not on the same domain as the remote computer, but I physically have access to this computer. Can somebody help me about the procedure to use ? I already accessed ms sql 2000 databases but it was on my computer, so the server was '(local)'. How do I do for a distant one ? Is there a way of using the remote computer IP adressm, or something else ? Thanks for helping.
p.f. Goudjo-Ako Bringing our energy together !
-
alter your current connection string to point to the remote SQL Server IE:
User id=YOURUSERNAME; password=YOURUSERsPASSWORD; Data Source=YOURREMOTESQLSERVER; Initial Catalog=YOURDATABASENAME;Hope this is helpful.User id=username; password=userpassword; Data Source=120.120.120.120; Initial Catalog=dbName; Data Source=IP Address where your database is located. i thing it is use full for you...! :)
Pavan Pareta