|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
ASP.NET security with SQL Server 2005 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. |
#2
| |||
| |||
Re: ASP.NET security with SQL Server 2005 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)". |
#3
| |||
| |||
Re: ASP.NET security with SQL Server 2005 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. |
#4
| |||
| |||
Re: ASP.NET security with SQL Server 2005 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. |
![]() |
|
Tags: aspnet, security, sql server 2005 |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Security Update for SQL Server 2005 Service Pack 2 (KB970895) | Ken G | Windows Update | 1 | 05-06-2011 07:35 AM |
Security Update for SQL Server 2005 Service Pack 3 (KB970892) | sido | Windows Update | 27 | 12-03-2010 05:51 AM |
Security Update for SQL Server 2005 Service Pack 2 (KB948109) | mizsub | Windows Update | 16 | 16-10-2009 12:52 PM |
Uninstall and Remove Trend Micro Internet Security Pro and (PC-Cillin) Internet Security 2005/2006/2007/2008 Manually | fumble | Tips & Tweaks | 0 | 15-07-2008 12:47 PM |
Upgrade fails: SQL Server Express 2005 to SQL Server 2005 | Steve BB | Small Business Server | 3 | 11-06-2008 07:37 PM |