Dear All !
    I have developed a Software for a Hospital using 2005 & Sql Express.  Now i want to connect this data through lan. What connection string should i give. Please suggest. Below is my current connection string which i have used for it.

Dim conn As New SqlConnection()
conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Data\Sadar_Hospital.mdf;Integrated Security=True;User Instance=True"

You just replace ".\SQLEXPRESS" with the name of the new server. Depending on the security setup you may have to change to a username/password authentication. If authentication will be based on the windows domain username then you can use the existing Integrated Security.