aspnetdb.mdf file is not getting created?

Question

I have VS2012 and I'm creating a website application in ASP.NET using C#. I want to use VS2012 built in membership and role tool to create users and roles.

Problem is that ASPNETDB.mdf database is not getting created in App_Data folder when I launch ASP.net configuration utlility. Moreover there is no refresh utility when I right click on my solution explorer?

My SQL Server 2008 and IIS are on another machine.

How to resolve this issue?

Either create the database and tables yourself - or use the aspnet_regsql.exe utility in your ASP.NET folder to create those objects for you — marc_s
– marc_s, Commented Apr 28, 2015 at 10:11

marc_s · Accepted Answer · 2015-04-28 11:04:36Z

1

You need to either create the database and tables yourself using SQL scripts that Microsoft provides - or use the aspnet_regsql.exe utility in your ASP.NET folder to create those objects for you (in whichever database you choose to create them in).

answered Apr 28, 2015 at 11:04

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

4 Comments

Edison Over a year ago

Inside my app_data folder How can I create this schema.I am asking this from you since it is a bit tough I hope you could guide me here.

marc_s Over a year ago

@khan: you'd have to create the ASPNETDB database on a server first, run the aspnet_regsql utility against it, and when that's done, detach the database from the server and copy the .mdf file to your App_Data folder - or better yet: just leave it on the server!

Edison Over a year ago

I have created the aspnetdb database on server and since VS2013 does not have website configuration tool by default for adding roles and users I used this link blogs.msdn.com/b/webdev/archive/2013/08/19/…. So ASP.net configruation utility is running just fine.Now problem is that aspnet configuration or web site administration tool is not pointing to aspnetdb. that is when I added new users and roles and refreshed my aspnet database on sqlserver it was not updated.Can You help me here?

marc_s Over a year ago

@khan: no sorry, I've never used the ASP.NET membership stuff much... put that into a new question and ask it ! I'm sure someone will be able to help you with this!

Collectives™ on Stack Overflow

aspnetdb.mdf file is not getting created?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related