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.

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.

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!

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.

@ RobIOC
Thank you!