Chapter 11 Sample database Connection Closed

sanmarie · April 14th, 2009, 11:42 PM

Hi Imar,

Love your book. It's midnight and I won't be able to try your solution until tomorrow evening when I get home from work but I thought I would just post the problem now.

I'm at Chapter 11 where you say to drag the PlanetWrox.mdf and PlanetWrox_log.ldf files from the resources folder into VWD. I did this but when I double click the .mdf file, it brings me to the Database Explorer which shows the database icon with a little red x on it indicating that the connection is closed. The properties window also shows the "State" property as "Closed"

I'm using SQL Server 2005. This is my connection string:
Data Source=.\SQLEXPRESS;AttachDbFilename=C:\TestSite\A pp_Data\PlanetWrox.mdf;Integrated Security=True;User Instance=True

I checked the permissions on the App_Data folder and my windows user account does have modify and all the other permissions on that folder.

Hope I was clear enough in explaining the problem. Thanks and I will respond to your input soon.

San

Imar · April 15th, 2009, 02:31 PM

Hi there,

Does this:

>> I'm using SQL Server 2005

imply the full version of SQL Server? Or do you have a locally installed Express instance called .\SqlExpress?

Imar

sanmarie · April 15th, 2009, 02:39 PM

It's a locally installed Express Instance.

I installed this some time ago when I had a trial version of VS 2005 and when I start my windows XP machine, I can see that my SQLExpress instance is running in the task bar.

Imar · April 15th, 2009, 02:42 PM

Task bar = task manager? (Not wanting to nitpick; just interested in where you see it).

Can you connect to the database using SQL Server Management Studio?

Imar

sanmarie · April 15th, 2009, 03:09 PM

Yea, I mean the task bar.

Hmm. I didn't try through management studio. I'll try in 2 hours when I get home from work. Hopefully you'll still be online. Should I try anything else if I can't connect through SQL Server management studio?

Imar · April 15th, 2009, 03:13 PM

I assume you mean the task *manager*? The task bar is where you see icons for open Windows, a location where you typically don't find SQL Server.

If you can't connect with Management Studio, SQL Server may not be installed correctly. If you're not reyling on it for other databases, an uninstall and a reinstall is probably the quickest way to fix things.

Cheers,

Imar

sanmarie · April 15th, 2009, 03:18 PM

I meant the task bar because I set my instance of SQL server to start up when windows starts. It is a white barrel icon with a green arrow button that displays in the task bar. It allows me to start and stop my instance of SQL server 2005. I didn't check the task manager to see if its running there.

I'll check, reinstall if it doesn't work and get back to you.

Thanks

Imar · April 15th, 2009, 03:22 PM

You mean this one: http://images.google.com/images?hl=e...&gbv=2&aq=f&oq=

That icon was there for SQL Server 2000, right? I've never seen it for 2005....

Imar

sanmarie · April 15th, 2009, 03:35 PM

Well, I had SQL Server 2000 installed first, then I installed SQL Server 2005 Express. The icon on the task bar allows me to switch between different instances of SQL Server 2005 express. Maybe I still have the icon from my SQL Server 2000 days but when I check it, the instance that is running is the SQLServerExpress one.

sanmarie · April 15th, 2009, 03:44 PM

Yes, The link that you sent is exactly what displays in my task bar. Well, it displays as a white barrel with a green arrow on my task bar. When I double click it, a window like the one you sent in the link, pops up allowing me to stop or start the instance or switch to a different instance.

It's hard to believe that they would put that icon in SQL Server 2000 then remove it in 2005. It makes accessing the instance easy.