Chapter 11

dbcook8 · August 27th, 2008, 10:28 AM

In chapter 11 on the "Try it Out" section on page 356, I have copied the .mdf and .ldf files from the Resource folders into the App_Data folder on the website that I just created for this exercise. When I try to open the database, I get the following error:

Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enable' to generate user instances.

How do I accomplish this?

Thanks,
David

Imar · August 27th, 2008, 10:46 AM

Hi there,

What version of SQL Server are you using? The 2005 Express edition?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

dbcook8 · August 27th, 2008, 10:50 AM

Yes, I am using the 2005 Express Edition that I tried to download along with VWD. I wondered at the time that I downloaded SQL if it had completed correctly. Do you suggest downloading SQL Server again?

Imar · August 27th, 2008, 10:56 AM

Yes, I would try that if you're not sure it's installed correctly.

SQL Express should support user instances out of the box when you install it.

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

dbcook8 · August 27th, 2008, 10:53 PM

I went to the microsoft.com/express page to download SQL Server 2005 Express but all I found was 2008. 2008 is not compatible with VWD 2005. So I uninstalled VWD and tried installing VWD 2008 Express along with SQL Server 2008 Express. SQL Server 2008 Express always fails to install. So now I am at a point that I cannot continue in chapter 11 because I can't get SQL installed. I was really looking forward to working with databases.

Imar · August 28th, 2008, 01:22 AM

You can still download 2005 here: http://www.microsoft.com/sql/edition...s/default.mspx

Maybe you should uninstall the older versions first, reboot and then try again?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

dbcook8 · August 28th, 2008, 10:45 AM

Imar, thanks for you advice. I finally was able to successfully install SQL Server 2005. All is well now, I can display the database.

Imar · August 28th, 2008, 11:42 AM

Great. Glad it's working.

Have fun with the remaining 8 chapters.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

dbcook8 · August 28th, 2008, 01:22 PM

I spoke too soon. Actually after successfully installing SQL Server, the folders showed up in APP_Data, but I could not open any databases. I received the error "could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc".

Imar · August 28th, 2008, 04:34 PM

That doesn't look right all. Are you sure you wiped out the previous installations before reinstalling?

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.