How do you remotely connect to SQL Server Express Editions?

Sean McHugh

I have the connection working locally but now I want to connect to the database from another computer on the internet. It looks like I will have to change the SQL Server Express Editions settings so I can do another search for that. My question on this forum is mainly if anyone knows what my C# code should look like. If you can provide an example that would be much appreciated.

3 Replies

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

Dharmesh Sharma17y ago

You no need to setting up your SQL SERVER 2005

just to know some thing

1. Internet is working well not tool slow.
2. know IP address or domain name of to want to cannect
3. User id for server authentication.
4. password also

now to try to caoonect remote server to by own sql server
look like this

and code is


and use this connection to where u use

 SqlConnection con = new SqlConnection(@"Data Source=192.0.0.1;Initial Catalog=databasenaem;User ID=userid;Password=password");
If  answer helped you don't forget to Mark  "Do you like Answer" please  :)

Kirtan Patel17y ago
Friend

,Here is What you want

dont forget to mark "Do you like this answer" please it will give me some credits :)

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=Server_IP_Here;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");
            con.Open();

            //Now Performa Query Etc Here

        }

And In Sql Server Configurate Make sure You have enabled remote connections

See below Image
Serban Cosmin17y ago
There should not be any modifications into your code. This is mainly a networking issue: the remote server must be available on the network and required 1433 port accessible ( firewall settings, router config ). You need to replace your local server name in the connection string with the remote server name as well. Also, security settings of the remote server must be properly set, allowing the connecting user the required rights for the certain database you are using.