Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 12-08-2009
Member
 
Join Date: Dec 2008
Posts: 87
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.
Reply With Quote
  #2  
Old 12-08-2009
Member
 
Join Date: May 2008
Posts: 2,293
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)".
Reply With Quote
  #3  
Old 12-08-2009
Member
 
Join Date: Jan 2009
Posts: 199
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.
Reply With Quote
  #4  
Old 12-08-2009
Member
 
Join Date: Dec 2008
Posts: 177
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "ASP.NET security with SQL Server 2005"
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


All times are GMT +5.5. The time now is 04:10 PM.