ASP.NET security with SQL Server 2005

[Wannabe]

When i try to access web page i get error message : Login failed for user . The user is not associated with a trusted SQL Server connection. I am running Virtual machines (VMWare) for my development and DB server. Is this sql server 2005 security problem.

[Zecho]

The SQL server has been configured to operate in "Windows Authentication Mode (Windows Authentication)" and doesn't allow. Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

[Walby]

Sounds like the database is expecting SQL Authentication instead of Windows Authentication.View the SQL Server error log to ensure that processes have completed successfully.

[Aberto]

SQL Server 2005 supports encryption capabilities within the database itself, fully integrated with a key management infrastructure. In Windows Authentication mode access is given based on a security token assigned during successful domain logon by a Windows account. To enable both authentication protocols: Go to Enterprise Manager > Right Click on Server Name > Select Properties > Go to Security Tab > Set authentication to SQL Server and Windows.