Chapter 11 Sample database Connection Closed

Imar · April 15th, 2009, 04:08 PM

That explains it....

I prefer to use the SQL Server Configuration Manager from the start menu. Once everything is up and running, I don't really need instant access to my instances anymore.

Anyway, interesting to see how connection to .\SqlExpress from SQL Management Studio will go...

Imar

sanmarie · April 15th, 2009, 08:53 PM

Hi Imar,

I was able to attach the PlanetWrox.mdf file in SQL Server management studio and open the two tables with no problems but double clicking it in VWD still didn't work. I really didn't want to reinstall SQL Server Express. So, after a long conversation with mom, I just right clicked on the PlanetWrox.mdf in VWD and clicked "Refresh." That opened all the database items. I guess double clicking the file didn't work for me.

I guess my setup is just different: I have the SQL Server express icon in my task bar and double click doesn't work.

So, thanks for all your help. See you on the next question.

San

ostrandernw · May 29th, 2009, 08:07 AM

Imar,
I have been working through the ASP.NET 2.0 but decided to purchase your book insead, great work by the way.
I am having the same issue with chapter 11 in Visual Studio 2008 it shows the PlanetWrox data base with the red x. I get a error 26 when I try to connect to it through visual studio. I have check my sql server (express) and it is set up for remote connections.
I can attach the data base in Management studio and navigate through it fine.
My server instance is listed in the server explorer window on visual studio.

Is there something else I can check.
Thanks for the quick responsed also its nice to have this kind of service.
Neal

Imar · May 29th, 2009, 05:50 PM

Hi there,

Have you tried SQL Server Management Studio Express? It's a useful tool to manage your SQL Server database.

http://www.microsoft.com/express/sql/download/

While it won't fix your problem right awway, it may help in finding the cause of the problem.....

Cheers,

Imar

ostrandernw · May 29th, 2009, 06:25 PM

I have SQL Server Management Studio Express and I am able to attach the database and explore it using SQL Server Management Studio Express. But for some reason I can connect to the database using server explorer in Visual Studio 2008 Pro.

Does Visual Studio 2005 Support ASP.NET 3.5?

Thanks
Neal

Imar · May 30th, 2009, 04:50 AM

I assume you mean "can't connect"?

Did you attach the database to SQL Server *and* try to view it through the App_Data folder by double-clicking it? That won't work. When you view it from App_Data, the database is attached to SQL Server on the fly. If it is already attached, you need to view it by making a new connection on the Server / Database Explorer window.

If that doesn't help, check out the permissions for the App_Data folder using a Windows Explorer.

Quote:

Does Visual Studio 2005 Support ASP.NET 3.5?

Nope, it doesn't. For ASP.NET 3.5 you need Visual Studio 2008.

Cheers,

Imar