[RESOLVED] ASPNETDB SQL 2005 not opening in SQL2008

[Raziiq]

Hey there.

Well i have built a website in Visual Web Developer 2008. I Also have Visual Studio 2008 installed. In my website, for membership and login, i gone through the Website Configuration and an ASPNETDB database was created for me. All fine no worries.

Now i installed MS SQL Server 2008, and before installing that it wanted me to remove other SQL version (2005), so i uninstalled that. Now i have SQL Server 2008 on my pc, but now when i double click my ASPNETDB in solution Explorer of Visual Web Developer it gives me the following error

Connection to SQL Server .mdf file required SQL Server 2005 to be installed

Well, that makes sense as i have uninstalled SQL 2005.

Now my problem is, i want to open that SQL Server 2005's Db (ASPNETDB) in SQL Server Management Studio 2008, and when i go to file and open, it gives me this error

Make sure the Application for .mdf is installed

Is there anyway i can make that SQL 2005 created .mdf to open in SQL 2008 Studio??

[gep13]

Hey,

Within Visual Studio, can you go to:

Tools | Options, then Database Tools | Data Connections.

What is listed there in the SQL Server Instance Name?

Gary

[techgnome]

What you need to do is attach the database, not open it. I'm a little shocked that 2008 made you uninstall 2005 first. I've got several machines with both installed w/o any problems.

-tg

[gep13]

Hey,

I agree, I have both installed on my home machine, and they live happily side by side. Which one Visual Studio "uses" depends on the Instance Name, as I was directing you to above.

Gary

[Raziiq]

Hey,

Within Visual Studio, can you go to:

Tools | Options, then Database Tools | Data Connections.

What is listed there in the SQL Server Instance Name?

Gary

It says SQLEXPRESS.

I dont know man, there are lots of stuff installed in my PC, like Database publishing, SQL Server 2005, SQL Server 2008, etc, dont know why it gave me an error of uninstalling

[gep13]

Hey,

Ok, so this is still referring to the previous SQL Server Express instance that you said you have uninstalled from your machine.

Do the following:

Click Start | run
Type services.msc and hit enter

In the window that opens, scroll down to SQL Server. The part in brackets is the instance name. What does it say?

Gary

[Raziiq]

Hey,

Ok, so this is still referring to the previous SQL Server Express instance that you said you have uninstalled from your machine.

Do the following:

Click Start | run
Type services.msc and hit enter

In the window that opens, scroll down to SQL Server. The part in brackets is the instance name. What does it say?

Gary

There is no SQL Server service running right now. Do you want me to install SQLExpress 2005 on my PC?? I have already downloaded that

[SeanGrebey]

What you need to do is attach the database, not open it. I'm a little shocked that 2008 made you uninstall 2005 first. I've got several machines with both installed w/o any problems.

-tg

I don't think it makes you, but I remember there being some option to upgrade it which I remember specifically not doing so I could run them side by side.

[gep13]

There is no SQL Server service running right now. Do you want me to install SQLExpress 2005 on my PC?? I have already downloaded that

I thought the whole point was that you are moving away from 2005, to 2008?

In which case, what I am suggesting is that you put the SQL Server 2008 instance name into Visual Studio.

Gary

[Raziiq]

Hi Guys, thanks for the replies.

Alright i am installed SQL Server Express 2005 and then i tried to open the same ASPNETDB.mdf file in my SQL management Studio 2008, it gives me this error of reinstalling the SQL SERVER 2005.

here is the screenshot

[gep13]

Hey,

Okay, I think that error message says it all. Looks to me like your installations are in a bit of a mix up. I would suggest that you completely remove all components of SQL Server, and start again.

Gary

[Raziiq]

Well i have reinstalled everything. Now this is what i have got.

I have Management Studio 2008. I Connect to the Local Databases, and right click the Databases and click attach, a new Windows popups up saying "add", when i click add, i get this stupid error.

[Raziiq]

Alright i have got hold of that error , problem solved, i followed instructions here and worked perfectly for me.

http://www.linglom.com/2009/03/28/en...-2008-express/

[gep13]

Hey,

Glad to hear that you got it working!!

Gary