Avatar of franklinan
 asked on

Error trying to connect SQLServer Express on REMOTE Computer with my VB.NET application

I have this really simple code to try to connect from a remote computer to my Database on SQl server 2005 Express :

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim cn As New SqlConnection
            cn.ConnectionString = "Data Source=\SQLEXPRESS;Initial Catalog=Historic;Persist Security Info=True;User ID=ZC;Password=DZC"
            MessageBox.Show("Conx abierta", "hola", MessageBoxButtons.OK)
        Catch ex As SqlException
            MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK)
        End Try

    End Sub

To trials, I've my Firwall OFF, and also I'VE SET UP MY SQL Server Express CONFIGURATION MANAGER, enabling my TCP/IP Conncetions !

What is happening ? ? ? My error message says that my server is not found....Maybe because I've my Server on the default config, but is not true,I've my sql server set up correctly I think.... Ant HELP ? ? ? ?  ?

Visual Basic.NET

Avatar of undefined
Last Comment

8/22/2022 - Mon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Tnaks !"! ! ! !

The only thing was missed was the SQL Server Browser Service..... Thanks ! ! ! !

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy