Wrox Programmer Forums
|
BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7
This is the forum to discuss the Wrox book Beginning Microsoft Visual Basic 2008 by Thearon Willis, Bryan Newsome; ISBN: 9780470191347
Welcome to the p2p.wrox.com Forums.

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
 
Old October 27th, 2010, 12:03 PM
Authorized User
 
Join Date: Aug 2005
Posts: 88
Thanks: 4
Thanked 0 Times in 0 Posts
Default Chapter 17 SQL Server

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
 
Old April 18th, 2011, 05:33 PM
Registered User
 
Join Date: Apr 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old April 18th, 2011, 05:38 PM
Registered User
 
Join Date: Apr 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 17 HenzFast BOOK: Beginning Microsoft Visual Basic 2008 ISBN: 978-0-470-19134-7 2 April 14th, 2009 03:28 AM
Chapter 17 First Try It Out paloyme BOOK: Beginning Visual Basic 2005 ISBN: 978-0-7645-7401-6 7 August 23rd, 2006 11:14 AM
Chapter 17 first Try It Out paloyme Visual Basic 2005 Basics 0 April 17th, 2006 04:34 AM
Chapter 17 Gaby BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 3 September 8th, 2005 11:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.