Chapter 11

G276 · February 6th, 2009, 09:36 PM

page 356, #4 - When I double click to open the database, I get the error:

A network-related or instance-specific error occurred while establishing a 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

How do I check if I have SQL Server 2005 Express edition installed properly on my computer, as described in Chapter 1, page 3?

How can I connect to the server from Management Studio Express?

The book has been great up to this point, but I have been stuck on this page for many hours. I was looking forward to learning the database stuff. By the way, the teaching format of the book is the best - it's like you really want the readers to learn it, rather than just read it.

Thanks,
Greg

Imar · February 7th, 2009, 04:46 AM

Hi there,

You can check for SQL Server in your start menu. If you install it, you get a main programs group called "Microsoft SQL Server 2005". This group in turn contains an item called Configuration Tools | SQL Server Configuration Manager

Once in the Configuration Manager you should see a list of SQL Server 2005 Services that in turns should include a SQLExpress Named instance.

Other ways to determine whether Express is installed or not:
http://stackoverflow.com/questions/1...their-versions

For more info on obtaining and installing SQL Express 2005, take a look here:

https://www.microsoft.com/Sqlserver/...s/express.aspx
http://www.microsoft.com/downloads/d...displaylang=en
http://articles.techrepublic.com.com...1-6102265.html

Quote:

By the way, the teaching format of the book is the best - it's like you really want the readers to learn it, rather than just read it.

Absolutely; that was one of my main goals for the book when writing it. Thanks!

Imar