Ytukyg

I'm working on an application in VB which has to connect to a SQL Server 2014 Express database with the following info:

DBName: testDB

DBHost: USER-PCSQLEXPRESS

DBUser: testuser

DBPass: testpass

and the following code to make the connection:

Public Shared Sub connect(DBName As String, DBHost As String, DBUser As String, DBPass As String)



    Dim builder As SqlConnectionStringBuilder = New SqlConnectionStringBuilder()

    builder.DataSource = DBHost

    builder.UserID = DBUser

    builder.Password = DBPass

    builder.InitialCatalog = DBName



    connection = New SqlConnection(builder.ConnectionString)

    connection.Open()



End Sub

I'm able to login normally with this information (using SSMS) but not with the code here. Now I know that this code works as I've used it on a different machine where it worked fine. In both cases the server is hosted locally. I've enabled all protocols in the Network Configuration but I'm still not able to login via this code. Also I set the login to also work with SQL login.

I'm printing the exception it gives me and it sais

Cannot open database "TestDB" requested by the login. The login failed. Login failed for user 'testuser'.

Why does it allow me to login via SSMS and not via my program?

Try to vary this row:

Dim builder As SqlConnectionStringBuilder = New 

    SqlConnectionStringBuilder("Integrated Security=SSPI;") 

OR

Dim builder As SqlConnectionStringBuilder = New 

    SqlConnectionStringBuilder("Integrated Security=true;")

What this means:

Integrated Security = False : User ID and Password are specified in the connection.

Integrated Security = true : the current Windows account credentials are used for authentication. However, be carefully it does not work in all SQL providers. It will throw an exception with OleDb provider.

Integrated Security = SSPI : this is equivalent to true, but it works with SQL Client and OleDb providers.

Please, see connection strings at MSDN.

Your error Cannot open database "TestDB" requested by the login. The login failed. Login failed for user 'testuser'. means:

• you've written incorrect login or user of database TestDB
  


• user testuser does not exist in your database
  

Run to see whether testuser exists in your database:

USE YourDatabase

SELECT * FROM sysusers

In addition, be sure that you've set a correct password of database user.

Update by Nick.McDermaid:

I was able to detirmine that I need to grand acess to the database for that user!