Can not connect to a SQL Server express database with VB.net

Asked Dec 11 '14 at 13:22

Active Feb 28 '17 at 12:12

Viewed 751 times

I am attempting to connect to a SQL Server Express Database through VB.net. As I run my connect string I am getting an error. Here is the code that I am using to connect. It works fine for another SQL Server database, however it errors out with the sql server express database.

Imports System.Data
Imports System.Data.SqlClient

Public sqlCnn As SqlConnection

Dim strCONN As String = "Data Source=CAFS\ADEMERO;Initial Catalog=OurDB;User ID=sa;Password=PASSWORD1!"

Try
    sqlCnn = New SqlConnection(strCONN)
    sqlCnn.Open()

    Return True
Catch ex As Exception
    MessageBox.Show(ex.Message, 
              "Content Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Stop)
    Return False
End Try

Any assistance you can lend would be a great help.

edited Feb 28 '17 at 12:12

klashar

2,519
2
28
38

asked Dec 11 '14 at 13:22

Mike the Gardener

2

What error are you getting? – User999999 Dec 11 '14 at 13:23
Isn't the Sql Express instance called SQLEXPRESS? Not ADEMERO. – idstam Dec 11 '14 at 13:27
check your connection string – enapi Dec 11 '14 at 13:39
I tried that as well and it did not work. I think it has something to do with the protocols being disabled. I am looking into it. – Mike the Gardener Dec 11 '14 at 13:57
I am getting "Error 28 - Server doesn't support requested protocol" – Mike the Gardener Dec 11 '14 at 13:58
maybe this helps [http://stackoverflow.com/questions/13238219/sql-server-express-cannot-connect-error-28-server-doesnt-support-requested-p] – enapi Dec 11 '14 at 14:00
I just tried that and that did not work either. Now I am baffled. – Mike the Gardener Dec 11 '14 at 15:23
I got it! I also had to change the enable setting for the protocol on the server side. Thanks for everyone's help! – Mike the Gardener Dec 11 '14 at 17:00

Can not connect to a SQL Server express database with VB.net

0 Answers0