After using an Access database for a long time and trying and failing to get SQL Server working at least 3 times, I decided to try again using the Pubs database
I am using Visual Basic 2008 Professional and have SQL Server Express R2 on my PC.
My login screen for the SQLSERVER 2008 R2 MANAGEMENT STUDIO shows this in the Login screen:
Server Name: SIRMILT\SQLEXPRESS
Authentication: Windows Authentication
User Name: SIRMILT\SIRMILT
When I run the SQL Server Management Studio 2008 Express R2 the Pubs database is visible under the item"Databases"
In attempting to accrss this table in Visual Basic 2008 Professional using the following connection string:
("server=SIRMILT\SQLEXPRESS;database=pubs;user id=SIRMILT; password=;")
I get the error "Login failed for user 'SIRMILT'."
I have tried different variations of both the Server Name and the User Name and I just don't know where else to look for the solution to this problem. Can anyone help?
View Complete Post