You are currently viewing the BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
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.
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
In attempting to complete the example starting on page 17 with the following connection:
("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 theServer Name and the User Name and I just don't know where else to look for the solution to this problem. Can anyone help?