Solved

aspnet_regsql does not show user created DB

Posted on 2010-09-17
2
679 Views
Last Modified: 2012-05-10
I have just started with ASP.NET and MS SQL programming.
I am currently following the steps listed in this tutorial

http://www.asp.net/security/tutorials/creating-the-membership-schema-in-sql-server-cs

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
Server : .\SQLEXPRESS
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?

Thanks!
0
Comment
Question by:sunnycoder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 45

Author Comment

by:sunnycoder
ID: 33699937
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!!!
0
 
LVL 45

Accepted Solution

by:
sunnycoder earned 0 total points
ID: 33700373
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
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question