• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 693
  • Last Modified:

aspnet_regsql does not show user created DB

I have just started with ASP.NET and MS SQL programming.
I am currently following the steps listed in this tutorial


Using MS Visual Web Developer Express 2010 and SQL Server Express 2010

In Solution Explorer, I right clicked app_data, add an item, selected data, SQL server database, named it userdb.mdf.
Then I switched to Database Explorer and double clicked userdb.mdf and it was able to connect fine and as expected it listed the empty folders - Tables, Views etc.
Connection String property shows data source as .\SQLEXPRESS

Next I launched %WINDIR%\Microsoft.NET\Framework\v4.0.30319\aspnet_regsql.exe

I entered following details
Selected "Windows Authentication"
Now when I try to select the DB from Database drop down, I do not see userdb. I only see master, model, msdb, and tempdb. What am I missing?

  • 2
1 Solution
sunnycoderAuthor Commented:
Ok, I was able to type the DB name in that drop down. The wizard completed without showing any errors. However, there are no tables in the DB!!!
sunnycoderAuthor Commented:
Finally got it ... Detach the DB in VWD, Right click the DB, Modify Connection - Use SQL server instead of DB from file.

Seeking a PAQ/Refund
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now