troubleshooting Question

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

Avatar of franklinan
franklinan asked on
Visual Basic.NET
2 Comments1 Solution235 ViewsLast Modified:
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
        Try
            cn.ConnectionString = "Data Source=192.168.1.45\SQLEXPRESS;Initial Catalog=Historic;Persist Security Info=True;User ID=ZC;Password=DZC"
            cn.Open()
            MessageBox.Show("Conx abierta", "hola", MessageBoxButtons.OK)
            cn.Close()
        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 ? ? ? ?  ?

Thanks
ASKER CERTIFIED SOLUTION
LordWabbitLordWabbit

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros