Loading

How to access sql server 2008 r2 database in LAN in C#

Rahul Kaushik

I am creating an application and need to access a database which is loacted in the other computer system in a LAN itself. Let server name of SQL server is RAHUL\SQLEXPRESS

without any password. So how to connect my c# application with that.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
you can connect to any database either in your LAN, on client side behind firewall or on Azure, as long as you have access credentials for that.

To connect simply using Visual Studio, go to View -> Server Explorer
Inthat server explorer, right click on data connections and click add connection.

the wizard will guide you for next steps
Amit Gupta9y ago
Nothing to worry about it. Check this link
http://stackoverflow.com/questions/22282681/difficulty-connect-to-sql-server-express-on-lan