Solved

aspnet_regsql does not show user created DB

Posted on 2010-09-17
2
681 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

690 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