473,568 Members | 2,923 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to reference a membership database that is not in App_Data SQL Server Express database?

If I understand correctly, the SQL script called "InstallMembers hip.sql" can
be used to create a membership database that exists in the instance of SQL
Server 2005 used for my main application. Having created such a database,
how can I get the ASP.NET Web Site Administration Tool to reference that
database instead of the one that exists in the App_Data folder SQL Server
Express database? Also, how can I get the membership controls in my
application to reference the newly created database instead of the one that
exists in the App_Data folder SQL Server Express database?
Thanks,

Keith
Jul 2 '06 #1
1 1531
I found the answer to this question in a very good article entitled:
ASP.NET 2.0 and the Provider Model, without SQL Express
located at:
http://weblogs.asp.net/bsimser/archi...x?Pending=true
I followed the instructions and it worked.

Thanks,

Keith

"Keith" <kb******@dslex treme.comwrote in message
news:12******** *****@corp.supe rnews.com...
If I understand correctly, the SQL script called "InstallMembers hip.sql"
can be used to create a membership database that exists in the instance of
SQL Server 2005 used for my main application. Having created such a
database, how can I get the ASP.NET Web Site Administration Tool to
reference that database instead of the one that exists in the App_Data
folder SQL Server Express database? Also, how can I get the membership
controls in my application to reference the newly created database instead
of the one that exists in the App_Data folder SQL Server Express database?
Thanks,

Keith


Jul 3 '06 #2

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

Similar topics

8
2248
by: VB Programmer | last post by:
I would appreciate your assistance on this ASP.NET 2.0 site.... This is the wierd problem: While accessing the built in .NET functions for 'profiling' or 'membership' an error is generated (see following 2 examples): ---- EXAMPLE 1 -------- OK --> Dim p As New ProfileCommon OK --> p = Profile.GetProfile(Me.ddlRacer.SelectedItem.Text)...
3
1628
by: Carl M. | last post by:
Okay, I'm 18 hours into this now and am at a loss. What I've done is create an application on my local workstation using VWD Express using the membership/roles provider and SQL Server Express configured for local authentication. I have an aspnetdb database in my app_data folder configured with several users. Everything works fine when I run...
4
1497
by: Pony Tsui | last post by:
I was install the starter kits CLUB, and created a CLUB WEB SITE, this application use the MemberInfo table in club.mdf to store the membership'data, but i can not find out where to define or configure the MemberShipProvider relative to the MemberInfo Table, it just define the connectionString in the web.config. thanks. -- Pony Tsui
0
997
by: Jack | last post by:
Hello, I need some help in getting my simple web app to work. I can't seem to get the configuration of the Membership/Roles working by pointing my website to a SQL 2005 database as opposed to the default App_Data\ASPNETDB.MDF file. I've got two boxes, one with XP & VS2005 and the other is windows 2003 with IIS 6.0, ASP.NET 2.0 & SQL...
3
4125
by: jason | last post by:
I've been playing around with new (for 2.0) membershp functionality. I was able to build a simple login form that secures a directory on a project I built locally on my development desktop. However, when I attempt to follow the same steps on the remote test server (a website I access via filesystem security accross my lan ).. I get the...
0
1594
by: Jonathan Wood | last post by:
I seem to be having errors creating and accessing an SQL database. Unfortunatley, I am brand new to SQL setup and administration issues so this really is not my area of expertise. I know I had to install some type of IIS component to run databases from Visual Studio 2003. Since then, I've installed Visual Studio 2005. I know VS 2005 has...
2
4112
by: Patrick F | last post by:
Hi, i have SQL Server 2005 and a database set that is called, myCompany the problem is that i cant connect from my page to it, here is from the web.config: ( i have got this connectionstring from my sqldataobject on my page) <add name="ConStr" connectionString="Data Source=localhost;Initial Catalog=myCompany;Integrated Security=True"...
1
5904
by: Mrozik | last post by:
Hi! I have Web Application with forms authentication. Data and security model resides in Oracle database. I have 'login' page with MS 'Login' control. In my LoggingIn event for debug purposes I have only: FormsAuthentication.RedirectFromLoginPage( "testlogin', false); (all users are authenticated) It works fine till now - I have still...
0
1619
by: PinkBishop | last post by:
Question regarding the ASP.NET 2.O Membership / Role component The following works fine on local machine and networked dev box. ASP.NET Membership protecting files and folders. I am trying to run the Membership component. I have loaded to production where host is running Win2k Server, IIS 5, ASP.NET 2.0, SQL Express
0
7693
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...
0
7604
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...
0
7916
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. ...
0
8117
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...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5217
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...
0
3651
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...
1
2101
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
1
1207
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.