Loading SQLserver database with ASPNET userID
How to configure the IIS, ASPNET userID, Windows or SQL Authentiation, std or integrated security for SQLserver database?
The VS.net 2002 web server and SQL Server client are at the same PC, while the SQL Server database is at another PC. The dataset and DataGrid were created successfully. However, when trying to run a Web Form with a table, a server error msg: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection, popped up.
I tried to create a login/user, computername/ASPNET, for the database and table. An error msg popped up: Error 15401: Windows NT user or group 'ComputerName\ASPNET' not found.
How do I solve this ASPNET userID and SQLserver Security problem?
C. Jeffrey Wang