?
Solved

Connecting asp.net web app to SQL database

Posted on 2008-01-30
3
Medium Priority
?
370 Views
Last Modified: 2013-11-26
Hi Experts,

I am configuring my first membership site in Visual Studio 2005 (c#).

I have separately created a database in MS SQL 2005 and then ran the config wizard (aspnet_regsql.exe)  to set up all of the tables and processes etc.

I then successfully connected my new site to this database and the web.config file looks good.

However, when I launch the asp.net configuration wizard from within Visual Studio to create users, roles, etc. it still wants to create the aspnetdb.mdb file.

Am I missing something here? How do I make the asp.net config wizard see the real SQL database (I am not interested in using Express since I have the full edition)?

I have examined many articles and tried the advanced link. But I am oviously missing something.

Thanks!
0
Comment
Question by:jklinger1975
3 Comments
 
LVL 16

Accepted Solution

by:
MikeMCSD earned 1000 total points
ID: 20788663
0
 
LVL 26

Expert Comment

by:Rejojohny
ID: 20789521
try
aspnet_regsql.exe -S <server> -U <login id> -P <password> -d <database> -A all ..

after you do this, can you confirm whether you have this in web.config

<membership defaultProvider="CustomizedMembershipProvider">
      <providers>
         <add name="CustomizedMembershipProvider"
              type="System.Web.Security.SqlMembershipProvider"
              connectionStringName="ConnectionStringNameToYourDatabase" /> -- the datbase and server you used in aspnet_regsql ...
      </providers>
    </membership>
0
 
LVL 1

Author Closing Comment

by:jklinger1975
ID: 31426630
Thanks! That explained it to me.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

592 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