Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > C# and C > C# 2008 > BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4
This is the forum to discuss the Wrox book Beginning Microsoft Visual C# 2008 by Karli Watson, Christian Nagel, Jacob Hammer Pedersen, Jon D. Reid, Morgan Skinner, Eric White; ISBN: 9780470191354
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 9th, 2010, 12:55 AM
Registered User
 
Join Date: Feb 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default chapter 19 page 660 Cannot Create a New Database

Chapter 19 page 660 Cannot Create a New Database. I can get to step 4: "Enter (local) for the server name, and BegVCSharpEvents for the database name." then I recieve pop up window with the following message: "A network-related or instanse specific error occurred while establishing connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server).

Please help me to solve this problem.
  #2 (permalink)  
Old February 9th, 2010, 01:48 PM
Authorized User
 
Join Date: Nov 2009
Location: Portsmouth,NH
Posts: 22
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via Yahoo to msherburne84
Default

Depending upon what you are running for Sql server. If you are running sql server express addition locally, check to make sure that the instance name is the same as what it says when you created the sql server instance. usually if you left the default settings the instance should be (localhost). If you have Sql Server running on a server connected to a LAN then you probably have not configured sql server to allow remote access to it. Let me know what set up you are running.
  #3 (permalink)  
Old August 13th, 2010, 07:03 PM
Registered User
 
Join Date: Aug 2010
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hello,
I am having the same problem. From what I've checked so far, it looks that I am running a sql server express addition locally, how do I check the instance name? Thanks in advance!
  #4 (permalink)  
Old September 3rd, 2010, 02:14 AM
Registered User
 
Join Date: Sep 2010
Location: Perth Australia
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default SQL Server Configuration Manager

Hello. I had the same problem but manged to resolve it on my PC using SQL Server Configuration Manager. This will show you the instances of SQL you have on your machine. Under Network Configuration I enabled protocols TCP/IP and Named Pipes.
You must restart the server when you make any changes for it to have any effect which you can do from the Configuration Manager.

When creating the database in VS for the server name hit Refresh then the server should be visible from the drop down list. e.g. computerName\SQLExpress.
I hope this helps.
The Following User Says Thank You to RobIOC For This Useful Post:
fuzzball (September 5th, 2010)
  #5 (permalink)  
Old September 5th, 2010, 01:52 PM
Registered User
 
Join Date: Aug 2010
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Default

@ RobIOC
Thank you!
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 19 johanyu BOOK: Beginning VB.NET 2nd Edition/Beginning VB.NET 2003 3 November 12th, 2007 10:50 AM
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



All times are GMT -4. The time now is 12:47 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.