Login not working -- visual studio .net setup

Peter
3/6/2006 10:19:26 PM

Hello,
My VS2005 login routine works perfectly on localhost, but once the web is
copied to the production server login works no more. "An error has occured
while establishing a connection to the server." etc etc.
I have a Windows 2000 and 2003 servers and both show same error. All other
pages work fine. Connection to SQL is good. Web.config has been modified to
accomodate SQL logging. Users have been added to database by use of
Administration Tool on local development box. What is missing from the Server
that prevents login? After consulting 3 books on ASP.NET 2.0 I'm till sitting
without solution, as all the examples shown run on local box not a server.
I dont want to instal VS2005 on my production box. Any ideas?

Thanks in advance
Peter

Wayne Wengert
3/22/2006 9:43:39 AM

Peter;

I am far from n expert but I just went through moving a project with a login
control to a hosted site so I'll offer what I learned. When you move to a
rwemote SQL Server (e.g. SQL Server 2000) you need to add the set of aspnet_
tables which are used by the login processes.

This link may help:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Wayne

[quoted text, click to view]

visual studio .net setup : Login not working