Hi, I have set up a small SQL Server database for users to login and also create accounts. I have uploaded the .sql file to the server and had it successfully imported. However when I test the pages online I am getting a Server Error in '/' Application (see code below). I was sure that I had done everything right but obviously not. Any advice would be greatly appreciated.
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.