This project is read-only.

ADO.NET code example fails login with Northwind DB

Jan 23, 2017 at 2:32 AM
Edited Jan 24, 2017 at 10:28 PM

I was having difficulty connecting to the Northwind database.

I always suspect first the db connection string and so it is shown below. But the accessing vb application (which uses windows authentication) says the Northwind db login failed? The Northwind DB opens up fine in SSMS.

Dim connectionString As String = _
"Server=serverName\SQLEXPRESS; " _
& "Initial Catalog=Northwind; " _
& "Integrated Security=SSPI; "
Thank you.
Jan 23, 2017 at 8:06 AM
Unexpectedly, remarkably, my database copy was spelled "NORTHWND" which did not match the connection string. So no help needed at this time, perhaps later though. Thank you for now.
Marked as answer by kennr on 1/23/2017 at 12:06 AM