juststartingout:
The solution was to add the ASP.NET machine account to the SQL database permissions on the host web server using SQL Management Studio.
Hello
I have a NET2.0 application using the standard Login control using the ASPNETDB.MDF database. When I have created a new user using the Website Administration Tool and tested it locally on the development server it works fine and the user is authenticated, however, as soon as I've copied the website to a remote IIS server including the database files, it fails to authenticate the user.
I have set the provider details correctly in the Website Administration Tool (AspNetSqlProvider) and set the authentication type to Forms.
Please can you help? Why won't the application communicate with the database remotely?
Thanks,
David