How to use SQL Server 2008 R2 instead of SQL Server Express in Visual Studio 2010?

Question

Hi

I have visual studio 2010 professional installed on my development machine. Later on I also installed SQL Server 2008 R2 as well. Whenever I create an ASP.NET website, vs 2010 uses SQL Server Express for databases. I don't want this behaviour. Instead I would like to use only SQL Server 2008 R2 for my databases such as user accounts.

I did manage to use SQL Server 2008 R2 for other databases but how to do it for User Accounts Database instead of ASPNETDB.MDF.

I hope my question is clear.

Thanks

Answer 1

Hi,

Could you please explain more about the situation? Because, in general you can change your connection string very easily to use SQL Server 2008 R2.

Cheers

---

MCP, MCTS, MCITP

Answer 2

Would you please check-out below thread

http://social.msdn.microsoft.com/Forums/uk/sqlgetstarted/thread/099d2472-b1ff-402c-be5e-bc36f4433de2

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 3

Actually I don't want to use SQL Server Express Edition in the first place. I want to start off with SQL Server 2008 R2.

Answer 4

Thanks for the link. I did check that already. Deployment is not my issue. And as I said before, I only want to use SQL Server 2008 R2 for development.

Answer 5

Hi Ahmed Ibrahim. I am sorry. I checked the wrong page. But I am there now at the right one. Hope it is the one I am looking for.

Answer 6

So you need to achieve same thing like below thread ?

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/f0005162-9abe-4956-be34-d79ddfe09ea9/

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 7

HI Nice !

You might need to have a look at below threads;

http://forums.asp.net/t/1606632.aspx/1

http://msdn.microsoft.com/en-us/library/ms185319.aspx

Please let me know if this helps. Hopefully i have answered you correctly.

Thanks, Hasham

Answer 8

Hi Hasham Niaz

Thanks for the reply and links. I'll check that too.