Security :: Get @list To Work In This Query On Aspnetdb
May 27, 2010[Code]....
[Code]....
[Code]....
[Code]....
Ive searched quite a while to do this.. havent found any revelant answer i already have a database named GAD.MDF with tables inside. However i wanna use the membership API to use the tables generated in the aspnetdb.mdf. Is there a way to generate thoses tables in my own database and then use my database instead? cause many host only enable us to use one database.
View 4 RepliesI used aspnet_regsql -W wizard approach to create DB for membership tables. and added script as follows in web.Config
[code]....
I'm just curious, why its not bigint or int ? is that because GUID is easy to generate ?
View 8 RepliesI have setup a Web Site Administration Tool for a web application and it work great
Now i have another custom application that was built on a different server and site but i want to use the users in the existingWeb Site Administration Tool for authentication and authorisation.So i deployed the custom application to the the same server where the Web Site Administration Tool resides. and just changed the connection string to point to the same database.But when i login with a username and pass it says login no correct.http://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication&applicationUrl=/myapplicationwhen i go to the link above it works and i can see all my usershttp://myserver/IntranetAdminTool/default.aspx?pplicationPhysicalPath=C:Inetpubmyapplication2&applicationUrl=/myapplication2When i go to this link i can't see users as its th new custom application i just moved to the site.
I get error There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem:Server cannot access application directory 'C:Inetpubmyapplication2'. The directory does not exist or is not accessible because of security settings.Is my approach a resonable one and is this possible?
In one of my web app's pages, the code behind needs to grab the UserId of the person logged in, so that it can then be inserted into a table which was added to the original aspnetdb.mdf. This table contains a column with a uniqueidentifier primary key which is in direct relationship with the aspnet_Users table; however I seem to have trouble retrieving the UserId. This table contains the additional information of a user which is not included in the provider, and it has a one-to-one relationship with aspnet_Users.
I hope this makes sense. I haven't written any code for it yet; I'm only at the thinking part of this stage. But my mind keeps going blank.(perhaps I need a break from the solution???).
I am using C# in my Web app's code behind.
I am getting to like how to use a profiles in aspnetdb membership
But these profiles are stores in a string.
Q: How does one get this profile data into a table, or get TSQL to show data in a column format.
I had a web application. We needed to move it to anotherserver, after we moved that, the membership database (aspnetdb) did not work.....finally i solved the problem, and now I have another problem. although in the web.config enablepasswordretrieval is set to true, and the type is clear, i get error in password retrieval.
View 7 RepliesI have developed a Silverlight app using forms authentication and the asp net membership, aspnetdb, the whole enchilada.The bug I see is that the password for my users change by them self every bow and then, the way I fix them is by deleting the user and creating them again, this has been I problem all the time.In a post I read the problem was manifesting because I didn't have a machineKey in my web.config, I now do, so I dunno what the problem is this time...Is there a definitive fix to this? can you please provide assistance?
View 11 RepliesI am using Visual Studio 2008 Express.
I did this simple test:
I created a new Web project with a simple page that has a Log In. There were no databases in App_Data.
I used the configuration tool to create a Role and User.
I refreshed the project folder and behold AspNetDB.mdf has appeared in the App_Data folder.
I have checked the Web.Config file and there is NO Connection string to this database.
So how do I move the Roles/Users application data storage away from AspNetDB.mdf to my own database ?
I am creating a website, where my client is planning to target 1000's or user registrations with their login area etc. Is it a good idea to use role management/aspnetdb for this purpose?
View 9 RepliesI am in the begininng stages of designing (or redisigning) a site. I am using VWD Express 2010 and the project is configured for .net 4.0. I am designing it offline so its currently just on my laptop, which is also running sql server express 2008 R2.
When I ran the ASP.Net Configuration tool, it automatically created a database called aspnetdb in the app_data folder where it stores all the user and roll info. How can I use a different database that has the same schema as well as some additional tables of my own. I want to point it to mylocally running sql server.
Currently in security setting in website configuration, there us only User, Roles, And Access Rules.i want to add Groups as top level for Users. is it possible?
View 4 RepliesI used the wizard and went through the steps to set it up and clicked DONE and closed the ASP.NET configuration window/wizard and the database was not created. What might be wrong here?
View 1 RepliesI built a website that tracks submissions online (SQL server express 08 edition). It has its own User table thats linked to other data tables specific to the business of the website. But I found out recently that I can save lot of time by integrating ASP.NET standard Login Controls that can automate lot of coding and make my life easier. Now since then, I added the login controls, integrated the work flow into my website (just user , role navigation so far) and noticed VS creates its own user tables , view, SPs etc. I am okay with that.I need all my submissions to be linked to a particular user that enters each sumission. Now since my user (userid) moved from my personal custom table to a standard ASPNETDB.mdf table... how do I link my original website database and tables to this Default User table / (ASPNETDB.mdf) created by VS.
View 5 RepliesHow to get the username and password of the user in ASPNETDB. I am using ASP.NET 2.0 and C#.
I have configured the membership provider. I want to retrieve the username and password from the aspnet db?
I'm using VWD 2010 asp.net 4.0 and SQL Server 2008 Express
I created a website that uses security with aspnetdb configuration
now I have hundred users that need to access this website
And I don't want manually insert them one by one
Is there any way (T SQL Stored Proc or ASP.NET VB code) to automated this bulk insert?
I currently have a website up and running and working correctly with godaddy.com using the out-of-the box authentication with an aspnetdb sqlserver database. I have users on this site and am very hesitant to change anything with this database or the web.config file from the working site for fear of wrecking it
So, my challenge is that I need to authenticate a separate application using the same aspnetdb.mdf file without any crossover to my 1st application. I've noticed that the ApplicationName that is currently in my aspnetdb database for the working application is just "/". I know that I'll need to have 2 separate entries in the aspnet_Applications table to define these two applications and then somehow register those names within their respective web.config files - but wanted to have step by step instructions on how to this so as to not "break" the 1st working application that is already live.
Can anyone point me to a document on what changes I will need to make?
Also, with the default create user wizards I'm using, how will it know to create the new user information with the correct application ID so that the user information from one application is not visible to managers of the second application and vice/versa?
my current vs2005, when setting up the login control, and using the built in admin the db function right on the
login control, creates the aspnetdb db in the folder, app_data, directly under the vs project folder. I want to get the db
in a folder of my choice under wwwroot in my inetpub. can this be done? otherwise it seems i have to copy the vs version
using my server mgt sql express. i've seen how to respecify the roles and membership functionality from the 4guys article
[URL], which i'm ready to do when the db is moved.
also isn't something like this necessary anyway when moving a vs project to some actual web app server?
Change user's password via stored procedure in ASPNETDB. Changed to another post [URL]
View 1 RepliesI need to know how to change aspnetdb to store profile information unique to each user so that I can restrict records in an sql table to only show that user's records.
So if I make a "companyID" int, identity column where would I put it?
Also, when I write the where clause to companyID = profile (companyID) would that work?
i have a problem, i want to decrypt password in aspnetdb, the password created by web administration tool in vs, i want to decrypt it without using MemberShipProvider, i there any way.
View 2 RepliesI am having problems getting the security.aspx to load up on my primary development computer which is using Windows 7 Ultimate and Windows IE 8. Clicking on the ASP.NET Configuration icon from the IDE in the Solution Explorer within Visual Web Developer 2008 Express Edition loads up default.aspx with no problem. But when I click on the "Security" hyperlink to access "security.aspx" I get a message along the lines of "The configured SQL data source provider is not properly configured". It goes on to state a list of potential reasons for this problem. One that includes not having the proper credentials or permissions. Im almost 100% sure it has something to do with permissions because I can't even get to the "security.aspx" page from opening a new empty project. I have recently installed Visual Web Developer 2008 Express Edition on my laptop which is running Vista with all latest updates and this issue does "not" exists. I can click the "ASP.NET" icon, load up "default.aspx" and click "Security" and it loads the page with absolutely no issues.
I have discovered a weird workaround but I don't like having to do this. If I add the following lines to my "web.config" file from any given project I can get to the "security.aspx" page without getting any SQL messages about improper configuration or permissions.
<<remove "LocalSqlServer">
<add
name="LocalSqlServer"
connectionString="data
source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
providerName="System.Data.SqlClient"/>
Basically, what I have to do to get to the security page to load without error is add a remove statement and then I just cut'n'paste almost the exact same connectionString from machine.config in the Microsoft.netFrameWorkV2.0.5027config directory. This does away with the "Improperly configured SQL datasource message" and gets me a new error message along the lines of "Could not create a SQL instance". My memory is fuzzy on exact error messages since Im not at development computer right now. However, when I change the User Instance attribute from true to false, then I have success at last.
I am writing a linq query to select a blogpost,
[code]....
The blogpost i am testing got 3 tags attached to it. The table structure is:
(table)BlogPost -> (table)BlogPostTags <- (table)Tags
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
I want to know how to Update / delete the table records in ASPNETDB.MDF in single update / delete query ?
View 1 Replies