Hi, I am hvg application developed in VB.Net 2005 previously it was on running on single pc and using local database. But now i want o install the same application on multiple pcs and want to centralize the database to avoid duplicacy. I am using this connection string "Dim sqlcon As New SqlConnection("uid=sa;pwd=sa;Server=\\10.52.4.10;database=dainik")" for connecting to remote database. But its not working, while when i registering the same system database in sql server it is working properly. Kindly guide me.

Hi Girish Kardam,

Good night. 

I normally use the below connection string in my applications and it works.  I use SQL Server authentication. Please be sure that you have the right username and password.

Public Sub TestConnection2DB()

Dim myConnection As New SqlClient.SqlConnection

myConnection.ConnectionString = "Database=dainik;Data Source=10.52.4.10;User Id=sa;Password=sa"

End Sub

I hope it helps you to continue your project.

Best regards,

Daniel Cabarcas