473,671 Members | 2,550 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Login Controls and aspnet_regsql

I have been running and testing stuff ok on my dev machine, but have been
forced to consolidate my databases at my hosting company - i created a db
there, and i ran the aspnet_regsql wizard. I filled that out, and sure enough
i created the tables etc on my remote database.

What i dont know and cant seem to understand or figure is how or where i
tell the system what db these tables are on; i have googled around a little
and cant find the answer - i am sure i need to do something simple.

When i run a createuser wizard and hit the button the system throws up an
error (i cant see the error, it drops me to a standard error page); i presume
the reason is that .net doesnt know the location of the login info.

Please help.

Sep 10 '06 #1
2 1258
Hey

This took me awhile to find as well... add this to your config:

<connectionStri ngs>

<remove name="LocalSqlS erver" />

<add name="LocalSqlS erver" connectionStrin g="Data Source=IP_ADDRE SS;Initial
Catalog=DATABAS E;Integrated Security=True"
providerName="S ystem.Data.SqlC lient" />

</connectionStrin gs>

That should help... this area doesn't seem to be well documented.
"Owen Richardson" <Ow************ @discussions.mi crosoft.comwrot e in
message news:66******** *************** ***********@mic rosoft.com...
>I have been running and testing stuff ok on my dev machine, but have been
forced to consolidate my databases at my hosting company - i created a db
there, and i ran the aspnet_regsql wizard. I filled that out, and sure
enough
i created the tables etc on my remote database.

What i dont know and cant seem to understand or figure is how or where i
tell the system what db these tables are on; i have googled around a
little
and cant find the answer - i am sure i need to do something simple.

When i run a createuser wizard and hit the button the system throws up an
error (i cant see the error, it drops me to a standard error page); i
presume
the reason is that .net doesnt know the location of the login info.

Please help.

Sep 11 '06 #2
Thanks Hayden!

Sep 11 '06 #3

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

Similar topics

5
1730
by: RedEye | last post by:
Hello, I am working on a test site to explore the new login controls and membership features of ASP.NET v2.0. I have tested the controls using SQL Express and have now decided to try using a central SQL Server 2000 database. When I use the all of the included controls with SQL Express everything works great but when I use it against SQL Server 2000 I can't get past the login page. When in Visual Studio IDE and open the web admin page I...
5
1670
by: George Wei | last post by:
Dear all, I try to use the Login control newly provided in VWD 2005 Express. It is said in the online help that it must have SQL Server 2005 Express installed to save the credential infomation. For SQL Server 2005 Express is still in beta and it provides little management tools, it's difficult to manage/manipulate the database objects. So I want to use SQL Server 2000 instead of it, but I can not find any information to configure the...
2
2014
by: clintonG | last post by:
Anybody experience any problems with logging in to a website on a local instance of IIS when the site was created with Beta 2 and loaded into the shipping instance of VS2005? I've read through some of the earlier documents discussing changes but I don't recall any mention of login controls or haven't gotten to any that discuss why login controls would break all of a sudden. Actuallhy it seems to be the Membership system that has blwon up...
4
1313
by: Jarod | last post by:
Hey I will be creating asp.net 2.0 application and I need to create whole database stuff... But I have to use SQL S2000 not 05. So first question do you use default provider ( AspNetSqlProvider or something like this in a real world applications ? )? What's best approach to keep user data I need to have a lot of data from users because I will need their names, phones, photos, some doc-files and so on. And up to know I kept it in one big...
3
1497
by: goot | last post by:
I'm trying to use the login control and have it use the membership provider framework to authenticate users and am having a problem (which i'm sure will turn out to be a stupid mistake on my part)... this is what I have done thus far: Created a database on a sql 2000 server and then used the aspnet_regsql tool to create the membership tables I then modified the web.config as such:
1
9870
by: kSrilluVaishu | last post by:
hi I am getting this error when i am accessing my application site from a browser but not when executing my application.I am using webservice to get data from the data base.I am using login controls with sqlserver(aspnet_regsql); any body help me thank u
2
4517
by: antonyliu2002 | last post by:
I am testing ASP.NET 2.0 Forms athentication with user credentials in SQL Server 2005. I don't want to put user credentials in web.config, so the credentials section is commented out. The following is the relevant part in my web.config. <authentication mode="Forms"> <forms name=".MyWebAppAuth" path="/" loginUrl="Default.aspx" protection="All"
1
1267
by: Vince | last post by:
Hi, While working with the Login controls, VS creates a ASPNETDB.MDF database to store user accounts. Is that database only used for the storage of login credentials and if so, does this mean my site will need a separate database to host a users profile information and other tables Ill be needing?
2
1256
by: greg.hart | last post by:
Hello all, Just wanted to get some clarification on something. I was setting out to create a login page for people to login and then be able to access certain aspects of the website. Instead of doing what I usually do which is store the username password in a db table then compare what the user enters from the text boxes to what's in the db, I thought I would try the login components from the toolbox. In looking at how to wire those...
0
8402
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
8927
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...
1
8605
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8676
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7445
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6237
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
5703
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
4227
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...
2
1816
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.