ASP.NET ASPNETDB.MDF Cannot open database

Question

I am using membership class for my user management, and it created a database called ASPNETDB.MDF.. I decided to use the same database to handle my other data, and so I added some of my own tables in there...

When I try to access it:

    <connectionStrings>
    <add name="connString" connectionString="Initial Catalog=MyProject;Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\MyName\Documents\Visual Studio 2008\Projects\Project\MyProject\App_Data\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>

Using this:

Dim conn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("connString").ToString)

It gives me this error after I log in through Membership class:

    Cannot open database "MyProject" requested by the login. The login failed.
Login failed for user 'My-PC\Myuser'.

I am not sure what's going on?

Edit: If i don't use Membership class, I can use the database fine.. but when after I login using the membership class, it stops to work..

Sergey · Accepted Answer · 2009-08-10 02:00:16Z

1

Make sure My-Pc\MyUser has access appropriate permissions to 'MyProject' database. For the test environment that my local projects run on, i generally assign myself as the database owner to the database i want to access. That is if i am the only user accessing it. You can do so by running EXEC sp_changedbowner 'My-Pc\MyUser'. Obviously, you want to dedicate a separate account with limited access for your production environment.

answered Aug 10, 2009 at 2:00

Sergey

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

2 Comments

tpae Over a year ago

The owner is set correctly.. It's already My-Pc/MyUser. I can connect to it if I don't use the Membership class, but when I do, and log-in, I can't seem to connect to it.

Sergey Over a year ago

Can you remove 'initial catalog' section? I don't believe you need that if you use user instances.

chris · Accepted Answer · 2009-08-10 01:42:39Z

0

You'll probably need to make sure that the user the web server is running as has read/write access to the db file and directory.

answered Aug 10, 2009 at 1:42

chris

37.6k54 gold badges161 silver badges245 bronze badges

3 Comments

tpae Over a year ago

the user has read/write access to both db file and directory... If I don't use membership class and try to access the database, it works fine...

chris Over a year ago

What does the <membership> section of your web.config look like?

tpae Over a year ago

Strangely, I don't have a section on membership.. I have this: <authentication mode="Forms"> <forms loginUrl="Login.aspx" /> </authentication>

Pavel Chuchuva · Accepted Answer · 2009-08-10 02:05:48Z

0

Try removing "connString" from web.config and using "LocalSqlServer" connection string instead (it is defined in machine.config):

Dim conn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ToString)

answered Aug 10, 2009 at 2:05

Pavel Chuchuva

22.6k11 gold badges103 silver badges119 bronze badges

2 Comments

tpae Over a year ago

Where can i find the machine.config file?

Pavel Chuchuva Over a year ago

On my machine it's in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG

Ardee Aram · Accepted Answer · 2009-10-08 20:17:55Z

0

I also encountered this problem, and I noticed that it does indeed work if I changed the owner of the database to 'My-Pc\MyUser' (via EXEC sp_changedbowner 'My-Pc\MyUser') as pointed out above.

You might also try running this on your database:

exec sp_grantlogin 'My-PC\MyUser2'

This is certainly useful if you want MyUser AND MyUser2 having access to your database. I encountered this scenario when I have to execute aspnet_regsql.exe using MyUser2 credentials (as the owner of my database is ASPNET, which does NOT have login/runas capabilities).

Hope this helps someone :)

answered Oct 8, 2009 at 20:17

Ardee Aram

4,7999 gold badges38 silver badges37 bronze badges

Collectives™ on Stack Overflow

ASP.NET ASPNETDB.MDF Cannot open database

4 Answers 4

2 Comments

3 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related