Chapter 17 SQL Server

sirmilt · October 27th, 2010, 12:03 PM

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?

Milt

flstc98 · April 18th, 2011, 05:33 PM

Hi Milt,

If you are using windows authentication you don't need the user name or password. Try this and see if that gets you around your problem

("server=SIRMILT\SQLEXPRESS;database=pubs;Integrat ed Security=True;")

Let me know if it worked.

cheers

flstc98 · April 18th, 2011, 05:38 PM

Hi again Milt,

it should be

Code:

"server=SIRMILT\SQLEXPRESS;database=pubs;Integrated Security=True;"

not sure where the space in Integrat ed came from in my last post...guess I should use the preview button first :)

cheers