Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Accessing the SQL Database available in other server with my same LAN
Iam very new to VB.Net. Even I can say today only I started the project in VB.NET
Currently we are having 3-servers. Myself is logged-in to server called - " SERVER-1 " & My User name with server - " Bond ", Password - " 007 "
And the SQL SERVER 2005 is available in another system and that server called "SERVER-2" and his user name is " Raj" , Password - "123"
but all are in same LAN
How to connect with that sql server available in another machine ?
The following details I collected from that sql server..........
Server Name : abcde2
user name : SERVER-1 Raj
Dim con As New SqlConnection("server=server-2; database=emp_management; uid=Server-1Raj")