Connect to sql server from anothe PC

Question

hi.. all In LAN how to connect the sql server database from another system. i need a code.. thank you

Kunal Vaishya · Answer

Hi Click here to Refer this Link for Step by Step Configuration.

Ravi Shekhar · Answer

If your systems are in network you can use your IP as data source in connection string in application. If you want to access sql server of other system from your system then... Open sql server management studio --> server name --> browse for more --> network servers --> then choose database engine. here your all data source bind which is in network though lan or wireless. Mark as Answer  if it helps you.

Sandeep Singh Shekhawat · Answer

I think there is no need code. You need only some setting in your sql server which is on remote machine. Please go through below link http://www.mohamedibrahim.net/blog/2009/10/10/setup-configure-microsoft-sql-server-to-allow-remote-connection-remote-sql-management-studio-access/ http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses.aspx

anji marothu · Answer

thank for you reply sir.. i didn't find where it is in sql server

Kunal Vaishya · Answer

Hi Set Enable pipeline setting in SQLServerManagment in SErver PC and Connect from Local pc via IP or Server name