Unable to open the database

Sep 26, 2010 at 10:28 AM

Hi!

One of the most difficult is to open the MVC Music Store's database by SQL server developer via Visual Studio 2010, it says that you need to have instance "sqlexpress" and pop-up message state that you need to have SQL server express in order to open it.

How should I do to change the name of the instance of the program and to be enable to use SQL server developer instead of SQL express?

/Johan T

Sep 28, 2010 at 4:54 AM
Edited Sep 30, 2010 at 11:42 PM

in the web.config connectionstrings section.

you can find more info in this website  http://www.connectionstring.com

 

EDIT: sorry, the website should read http://www.connectionstrings.com/

Sep 30, 2010 at 4:41 PM

starcub's suggestion should work. But if you want to do the same thing via IDE, then when you are creating the .edmx file, there is a "New Connection" button. Click it and select the "Server Name" from the drop down list. FIll in rest of the relevent information and you are all set.

- Tushar G. Walavalkar