Connecting to database in ASP MVC3 application with IIS

Question

I've had some problems connecting with my database in a web application. The database is a .mdf and sits in my App_Data Folder. I'm using IIS 7.5 to run and debug my website.

I got following error:

Troubleshoot Error: An attempt to attach an auto-named database for file database location failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I came up with this solution:

http://www.dotnetfunda.com/articles/article905-troubleshoot-error-an-attempt-to-attach-an-autonamed-database-for-file-l-.aspx

BUT this involves leaving my computer's login and password wide open in the web.config. As you may understand, I'm not too happy about that... Is there a way to hide my password from the web.config or solve this problem otherwise? Thanks.

Pete - MSFT · Accepted Answer · 2011-05-23 22:27:51Z

2

Assuming your storing it in connection strings - since ASP.NET 2.0, you can encrypt any section...

run from your site root..

G:\content\snippet-site>C:\Windows\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis -pef "connectionStrings"

This should do the trick.

A bit more info... http://weblogs.asp.net/scottgu/archive/2006/01/09/434893.aspx

answered May 23, 2011 at 22:27

Pete - MSFT

4,3301 gold badge23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matthias Over a year ago

Thanks. This will probably fix it.

Collectives™ on Stack Overflow

Connecting to database in ASP MVC3 application with IIS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related