473,769 Members | 2,345 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

adding Membership tables to database, how?

hey

asp.net 2.0

I'm wondering how to add the Membership tables to a database. When I create
a website project and wants to register users, users are then automatically
registered in the database ASPNETDB. (not sure name is correct?). But
instead of that I want to use another database I create on my own. A
database created in Sql Server 2005. So how do I create these Membership
tables and stored procedures in this database. I've done this before and
have simply forgotten how it's done :( I know there is a command or a script
or something like that which I need to run against the database.

any suggestions?
Sep 9 '08 #1
1 2223
Hello Jeff,

aspnet_regsql.e xe -E -S localhost -d Northwind -A all -sqlexportonly c:\membership.s ql
and you get your script to run against new DB

http://blog.krisvandermast.com/Creat...pnetdbmdf.aspx
---
WBR,
Michael Nemtsev [Microsoft MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
Jhey
J>
Jasp.net 2.0
J>
JI'm wondering how to add the Membership tables to a database. When I
Jcreate a website project and wants to register users, users are then
Jautomatically registered in the database ASPNETDB. (not sure name is
Jcorrect?). But instead of that I want to use another database I
Jcreate on my own. A database created in Sql Server 2005. So how do I
Jcreate these Membership tables and stored procedures in this
Jdatabase. I've done this before and have simply forgotten how it's
Jdone :( I know there is a command or a script or something like that
Jwhich I need to run against the database.
J>
Jany suggestions?
J>
Sep 9 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
11794
by: WB | last post by:
Hi, I am revamping my company's website with ASP.Net 2.0. In order to use our existing user data in our SQL 2000, I have written a custom membership provider. However, when I try to logon with the Login control, it gives an error: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. Is it because I have not run the aspnet_regsql.exe yet? Do I have to?
6
1672
by: Bob | last post by:
What is the best way to store custom information in the database when using the Membership class? I need to store an access level and I know I can write to the database manually but I was wondering if there was something built in for this. Thanks Bob
5
2909
by: Mahernoz | last post by:
Hi Everyone! I have a problem here. I have used the latest asp.net membership & profiles functionality in my site. I have 2 roles admin and user. I also have a user named admin. Now, my website is running perfectly, but i want to deploy it.
3
1343
by: bbawa1 | last post by:
Hi, I am working on Membership and roles in Asp.net 2.0. I am using logincontrols in asp.net 2.0. When I use these login controls it automatically creates ASPNETDB.mdf database. which has it's own tables for membership. But I can't move this database to live server. Over live server I have only one database TWSAN I just want to copy tables from this database to TWSAN. Is this possible. Thanks,
3
2018
by: Michael Lang | last post by:
Hi there, I have a web application that works fine on my local dev machine. However I'm having less success on my hosting environment. When I detach the database for this site, copy it to my hosting environment and attach it through their interface, I can connect to the database in my hosting environment through the SQL Management studio, see all stored procs, functions, tables, and the data in the tables I had entered on my local dev...
3
1940
by: GaryDean | last post by:
I have serveral applications now running that are using the MembershipProvider classes and they are each using their own security tables in SQL Server 2005 instead of the express databases - they are all work well. Now we have a need to have many different asp.net websites and web services use a single security database because they all share the same user and administrator community. It doesn't seem there will be a problem with all of...
6
2933
by: Jonathan Wood | last post by:
Although this will be a challenge at my level of ASP.NET knowledge, I'm thinking I should implement my own membership provider class. Looking over the methods I must implement, a number of questions come to mind. 1. How would one implement GetNumberOfUsersOnline? I'm not sure where there is any indication of this? And it this affected by the "Remember me next time" checkbox, which doesn't seem to work like it does on any other site...
1
2644
by: cs_in_va | last post by:
I currently have a database with tables and data hosted with GoDaddy and now I want to add ASP.NET membership to restrict access and have people login etc. I have watched several videos on this from ASP.NET, but they are always working with a local installation not a remote hosted installation. Will I need another database? I don't know where to start. Thanks
2
212
by: shapper | last post by:
Hello, Where can I find the tool, and the scripts to if possible, to deploy ASP.NET membership on my SQL database? And can I change the tables names? For example, instead of using aspnet_Users just use Users? Thanks, Miguel
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10222
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10050
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7413
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6675
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5310
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3967
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3570
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.