Solved

ASP Login

Posted on 2009-05-04
5
252 Views
Last Modified: 2012-05-06
I have a new ASP.Net 2.0 website I developed and am using the default ASPNETDB.MDF under the APP_DATA folder to store user name and passwords that I create using the Web Site Administration Tool.

I am trying to deploy this Web Site on a separate Windows 2003 server box and have copied the contents of my Web Project Folder into c:\Inetpub\wwwroot. So the APP_DATA is now a sub-folder of wwwroot.

When I run the Web Site in a browser it will not accept any logins that I had created on the development server, acts as if there are no user's setup. I have installed SQL Server Express on the production server but still no luck. Why?
0
Comment
Question by:michouis
  • 2
  • 2
5 Comments
 
LVL 21

Expert Comment

by:silemone
ID: 24297347
in the webconfig or where ever your connection string is for your db, is it pointing to the right db server?
0
 
LVL 41

Expert Comment

by:guru_sami
ID: 24297428
As mentioned in post above....first thing to check is it is pointing to correct database....
There could be may other reasons...
check this:
http://www.codeproject.com/KB/aspnet/LoginControlError.aspx
0
 

Author Comment

by:michouis
ID: 24297828
There is no connection string defined for this Express database file in my webconfig. I used the built-in ASP Login control and selected the default SQL Express provider. Then I setup user's using the Website Admin tool. Works great on the development server. Does not work on the production server. The ASPNET.MDF file is in C:\Inetpub\wwwroot\App_Data folder. Like i said, i installed Express SQL Server 2005 on the production box. Why is it not working?? I am typing the login/password values manually, same as i do on the development server... Must be some setting in SQL Express on the production server. Also, when you install Express SQL Server there is no Enterprise Managment tool included. How are you supposed to create any tables?
0
 
LVL 41

Accepted Solution

by:
guru_sami earned 500 total points
ID: 24297944
Since you don't have any setting in your web.config...the default settings are used from your machine.config.
Check the machine.config in your dev and prod machines ...look the connectionStrings section....
you will get better idea...

Try this:
In web.config.... add membership provider section as it is in the link in my previous post....
0
 

Author Closing Comment

by:michouis
ID: 31577632
I have solved this by adding a customized provider to use our main SQL Server 2005 database... thanks for your clues..
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question