Wrox Programmer Forums
Go Back   Wrox Programmer Forums > C# and C > C# 2005 > BOOK: Beginning Visual C# 2005
|
BOOK: Beginning Visual C# 2005
This is the forum to discuss the Wrox book Beginning Visual C# 2005 by Karli Watson, Christian Nagel, Jacob Hammer Pedersen, Jon D. Reid, Morgan Skinner, Eric White; ISBN: 9780764578472
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual C# 2005 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 November 24th, 2006, 04:43 AM
Registered User
 
Join Date: Nov 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 18 Create new database

When creating a new SQL Server Database as in the Try It Out on page 612 of the book 'Beginning Visual C# 2005' I get the next error:

"An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open an connection to SQL Server)"

Does anyone know what this error message means and more importantly how I can solve this problem.

Thanks,
Alex
 
Old November 24th, 2006, 05:00 AM
Registered User
 
Join Date: Nov 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I searced the MSDN website and found the next solution:

"I was conneting to <machine name> as my server... after changing it to <machine name>\SQLExpress it started working fine."

This works for me.

Alex
 
Old January 6th, 2007, 02:16 PM
Registered User
 
Join Date: Feb 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I came to the forum to post the same problem. Thanks for your solution.

 
Old February 23rd, 2007, 09:08 PM
Registered User
 
Join Date: Feb 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I tried localhost\sqlexpress and found that that also works.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 18 re: VSS kevinstruckhoff BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 August 8th, 2006 11:04 AM
CHAPTER 18 example not working also! diegoborgh BOOK: Beginning JavaServer Pages 0 May 26th, 2005 11:16 PM
Cannot Create "Wiley" Database - Chapter 3 triplegee BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 3 April 6th, 2005 10:46 AM





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