CodeKicks.com
Focus on Microsoft Technologies - Tutorials, Articles, Code Samples.

Tuesday, November 04, 2008

Cannot open database NorthWind requested by the login. The login failed.Login failed for user domain\username

SQLServerAuthentication_MixedMode if you are getting the following error when connection to SQL Server Database, it indicates your SQL Server is not configured to use SQL Server authentication. for this you need to change your SQL Server configuration in such a way that it allow even SQL connections using username and password.

SQL Server Connection Error "Cannot open database NorthWind requested by the login. The login failed.Login failed for user domain\username"

To resolve this error follow the below steps and comment at the end of this article still you are getting the same error.

How to set up Mixed Mode security (Enterprise Manager)

How to set up Mixed Mode security (Enterprise Manager)

To set up SQL Server Authentication Mode or Mixed Mode security

  1. Expand a server group.
  2. Right-click a server, and then click Properties.
  3. Click the Security tab.
  4. Under Authentication, click SQL Server and Windows.
  5. Under Audit level, select the level at which user accesses to Microsoft® SQL Server™ are recorded in the SQL Server error log:
    • None causes no auditing to be performed.
    • Success causes only successful login attempts to be audited.
    • Failure causes only failed login attempts to be audited.
    • All causes successful and failed login attempts to be audited.

    Security Note  Microsoft recommends auditing, at minimum, failed login attempts. Auditing failed login attempts helps determine if unauthorized users are attempting to access the system.

Post a Comment