While i was using asp.net membership provider database(aspnetdb) on asp.net development server for storing username and password it was working right but as soon as i added my pages to intranet(IIS 6.0) USER was not able to login due to ASPNETDB Database.Now how can i use asp.net membership with that database using SQL Server2005
View 1 RepliesI am getting this error when trying to connect a database from another computer in my home network:
System.Data.SqlClient.SqlException : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
this database is using windows authentication. sqlserver 2008.
What is the connectionstring that I need to use in order to get the database?
Can it be done? I tried renaming it once, and kept getting errors after that, something about authorization. I changed the Name of the DB, and the Name in the connection string in web.config, but didn't work.
View 5 Repliesi would like to move all membership tables from aspnetdb.mdf to another mdf file. I don't have connection string in web.config that points to aspnetdb.mdf. I found links like [URL], but aspnet_regsql.exe allows to move all security data to sql server, not mdf file.
View 5 RepliesWhat is the best way to move my ASPNETDB.MDF from SQLExpress 2000 to SQLExpress 20005 on anothere server
View 2 RepliesIve 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 am using vusiaul studio 2005. I have been unable to use the express database. I can create it, by simply tryign to log in. But if I try to open the ASPNETDB.MDF database itself I get the following error:
"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."
I have SQL 2005 loaded on my machine. I would think this would be enough. Anyone know where I can ge the Beta 2 download or does anyone have another resolution for this?
I have an aspnetdb and I have created another aspnetdb for another website, but instead of starting from scratch, I would like to import all the data from the one that has users and other data into the new aspnetdb. Is there a way to do this? Are any tools available?
View 2 RepliesI'm having a hard time wrapping my head around how to use the Memberships in MVC. I know there is the built in ASPNETDB database which has all the basic tables for users and such. But what if I wanted to add a relationship between one of my custom tables and this built in user table?
If I had a database table that contained blog comments, we'll call it Comment. And each Comment had a userID associated with it could I do something like?
User.Comments.Add(someCommentObj)
I used aspnet_regsql -W wizard approach to create DB for membership tables. and added script as follows in web.Config
[code]....
I 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?
I wanna connect to aspnetdb but it makes an error says "Login failed for user" this is the connection string in web config :
<add name="UserProfiles" connectionString="Data Source=KIA;Initial Catalog=aspnetdb;Integrated Security=True;"
providerName="System.Data.SqlClient" />
and this is my code:
SqlConnection connection = new SqlConnection();
SqlCommand ComNewCheckSum = new SqlCommand();
connection.ConnectionString = ConfigurationManager.ConnectionStrings["UserProfiles"].ConnectionString;
connection.Open();
ComNewCheckSum.Connection = connection;
ComNewCheckSum.CommandText = String.Format("select UserID from aspnet_Users where UserName = {0}", _UserName);
return Convert.ToInt32(ComNewCheckSum.ExecuteScalar());
how can i pass through error?
I 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 have not found information how to do the following:
how to add a new table using EFCodeFirst to the existing database aspnetdb.mdf?
I'm working on a new asp.net 4.0 resume web site. I'm starting off with SQL Server Express 2005 and using the standard security and login features given with ASPNETDB.mdf. My site will be hosted on GoDaddy.com.
Quesiton. Should the tables that will contain the information that users will be putting in like resumes, contact information and such go into ASPNETDB.mdf or should it go into a separate database.
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?
I have a ASP.Net website that interacts with Dynamic CRM. It's also uses a local ASPNETDB.MDF for forms authentication. For the CRM I need to impersonate the identity created on the domain for this purpose. When identity impersonate is enabled I no longer have access to the local Membership Database. How can I allow the domain user used for the impersonation access to the membership database?
View 1 RepliesI have created an ASP.NET database application using SQL Server express on one of my home network PC's. I can access SQL Server Express from the other PC's (using SQL Server Authentication) so I know it is set up ok for network access. I can run the web site on the host PC under IIS & everything works ok.
When I try to access the application from another PC using http://192.168.0.8/TestApp/Default.aspx it is not available. I can ping 192.168.0.8 & it is accessible.
why I can not view the web site from another PC on the network?
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'm using Visual Studio 2010 RTM and MS Sql Server 2008 R2 EXPRESS with Advanced Services.I create a new simple asp.net web site. When I click on asp.net configuration, it opens as expected.When I click on the Security Tab, I get the message, Unable to connect to SQL Server database.It will not create the default aspnetdb.mdf file.I can create a connection to the sql server in VS from the database explorer.I can connect to the sql server with sqlcmd as a trusted connection.I have even managed to verify the default instance of .SQLEXPRESS with named pipesusing the sc command and the MSSQL$instance name.I have verified that my machine dot config file for the 2.0 .net contains the proper info (without altering it).I've spent many nights trying to figure this one out.VS2008 and MS SQL Server EXPRESS 2008 worked.I noticed that the default asp.net web site uses a connection other than the default localsqlserverand the template automatically adds a login in the ui with role, membership & profile in the web config.
View 3 RepliesI have web application project and i want to edit aspnetdb Database, but id does not appear in App_Data folder.I even cant see web.config file for subfolerds. When i create web site project in vs, i can see the aspnetdb Database.Vs Version : 2008
View 4 RepliesI have a simple database search engine set up on my company's intranet and I'd like to add auto-complete... Can somebody walk me through this? The database is Access. I'll need to make sure I'm using parameterized queries as well.
View 12 Replieswe are migrating existing windows form application to asp.net(3.5) intranet portal, there is a requirement whereby database connection should be made by the logged in windows user. Is it possible to achieve this functionality?
View 1 Repliesi have an application using asp member control i start copy this application to a new machine,in the old machine it is using sql 2000 sp4 express but in the new one i install sql 2005 sp3 express and he give me this error
Cannot open database "aspnetdb.mdf" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "aspnetdb.mdf" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Source Error:
[Code]....
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...
I have created some of my tables also ....in ASPNETDB ..
In my local PC the site was running fine ...
But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
My hosting provider connection string ..
<add name="ConnectionString" connectionString="Data Source=69.16.253.19;Initial Catalog=usa_data;Persist Security Info=True;User Id=user;Password=pass" providerName="System.Data.SqlClient"/>
My hosting provider gave me the connection string to connect to the SQL Server 2005 but it doesn't work...
I don't understand why my site was running fine using the production SQL Server 2005 in my local PC when I include ASPNETDB.MDF file in App_Data in my local pc only ..if I remove file ASPNETDB.MDF from App_Data of my local pc ... the site stops working ...
Can anybody tell em how to fix this ... !! I am very tensed since last 3-4 days