Hi sir
i have implemented the Try it out exercise of connecting SQL Server to database on page 406.
I have done all the thing according to your instruction. I have checked the security tab of my App_Data folder, it has modify permission checked.
I have log in to the administer account of my computer.
I mean to say that i have fulfill all the pre-requisite that you have told.
But in spite of this my data base is not connecting and it is giving the following 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: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)"


Please guide sir

Hi there,

Are you sure you have an instance of SQL Server installed called .\SqlExpress? Also, what do you have in VWD under Tools | Options | Database tools | Data Connections | SQL Server Instance Name?

Can you access your database using SQL Server Management Studio?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Sir i have installed the complete visual studio with SQL Express server 2008. Below i am sending you URL of the image of my control panel so that you can see weather SQL Express is installed or not
.http://s1254.photobucket.com/albums/...ntrolPanel.jpg

in VWD under Tools | Options | Database tools | Data Connections | SQL Server Instance Name is SQLEXPRESS.
From where i can access my database using SQL Server Management Studio?

Hi there,

Hard to see from that image what the version of SQL Server is, and what the name of your instance is.

Try downloading the SSMS and then log in to .\SqlExpress. You can download SSMS from here: http://www.microsoft.com/en-us/downl....aspx?id=22985

Also, in the Windows Start Menu look for an item such as SQL Server Configuration Manager. That should list the installed instances and that might shed some light.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hi sir,
i have
Microsoft SQL Server 2008 R2-Transact-SQL Language
Microsoft SQL Server 2008 R2 Managment objects
Microsoft SQL Server 2008 R2 Data-Tier Application P....
Microsoft SQL Server 2008 R2 Data-Tier Application T...

installed in my system. and from this i conclude that i have installed the Microsoft SQL server 2008.
Still i am facing the same problem.
Please please guide as my book study is stop due to this reason.

Yes, we concluded that already in your previous message.

But what we haven't concluded, and which is important to solve this, is which license version of SQL Server you have installed. If you installed SQL Server Express, it should respond to .\SqlExpress. If you installed a commercial version, it (typically) responds to . or MachineName.

So, take another look at the SQL Server Configuration Manager. Under the "SQL Server Services" node it should list the installed instances. What does it say in the Name column? Then for each listed server, right-click it and choose Properties. Switch to the Advanced tab and scroll down to the Version property. What number do you see for each installed instance of SQL Server?

Also, have you tried installing SSMS and logging in to your SQL Server instance?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Sir i have installed the SSMS and in its installtion i have found SQL Server Installtion center window in which there are different options and i don't understand what to do.
I am sending the image of SQL Server Installtion center window please guide now what to do.
here is the image of SQL Server Installtion cente URL
http://s1254.photobucket.com/albums/...tioncenter.jpg
and you are talking about SQL Server Configuration Manager, i don't found it in my system and start menu. Where it may be.

Please guide sir now what to do? I am waiting for your reply.

Not sure if this is Express or not. Can you provide more information on how you start the installation?

The configuration manager should be in the Start Menu after you, I believe, install SQL Server, or SSMS.

Also, try clearing the box under Tools | Options | Database tools | Data Connections | SQL Server Instance Name and try again. Maybe you do have a notmal version of SQL Server.

If all this doesn't help, please be *very* specific about what you're doing, what you're installing etc. Also, try looking in the Services section of the Control Panel. Your SQL Server should be listed there as well, with or without Express in its name.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Sir i have installed SSMS, now in SQL Server configuration manager under the "SQL Server Services" node there
are two installed instances.One of them is SQL Server(SQLEXPRESS) and the other is SQL Server Agent(SQLEXPRESS).
The version number of SQL Server(SQLEXPRESS) is 10.1.2531.0. SQL Server Agent(SQLEXPRESS) does not have any version
property.
But sir the state of the both the sevices is stopped.
And sir in the service section these two instances SQL Server(SQLEXPRESS) and SQL Server Agent(SQLEXPRESS) are also
inlisted.
Now when i try to make connection of database in "Connecting to the SQL Server Sample Database" exercise on page 406 i
faced with the following error.
"connection to SQL Server database file(.mdf) require SQL Server 2005 Express or SQL Server 2008 Express to be installed
and running on the local computer."
now here is the URL of my control Panel image

http://s1254.photobucket.com/albums/...ontroPanel.jpg
Now what to do sir and why is this error if i installed the SSMS or it mean i have to install the SQL express Server sepatately? and one thing more that i have uninstalled the SQL Express server before the installtion of SSMS.

Hi there,

If the services are stopped, you need to start them or they won't work. I think you can do tat from the configuration manager. Otherwise, open up Administrative Tools from the Control Panel in WIndows and then open the Services item. There you can start them as well.

Why??? SSMS is used to manage SQL Server including the Express edition. By uninstalling the examples will never work, and you won't have anything to manage with SSMS.....

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!