Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0
SQL Authentication requires:
  • Creating a new SQL account
  • Enabling Mixed Mode 
  • Named Pipes  and SQL Browser enabled for a non-local SQL Server
For instructions on Creating the SQL account or Installing SQL Server see Installing and Configuring SQL Server article.

Instructions for enabling Mixed Mode
  1. Connect to the SQL Server in SQL Management Studio
  2. Right click on the instance node and select Properties
  3. Navigate to the Security Tab
  4. Under Server Authentication select "SQL Server and Windows Authentication Mode".
  5. Click Ok
  6. Restart the SQL Server, by right clicking on the instance node and selecting Restart
Instructions for Enabling Named Pipes and SQL Browser

If your SQL server is running on a separate machine, you will need to turn on Named Pipes and SQL Browser to ensure the SQL server can be accessed from an external machine
  1. In Programs, open SQL Server Configuration Manager
  2. Click on the SQL Server Network Configuration node
  3. Then select Protocols for MSSQLSERVER
  4. Enable Protocols:
    1. Shared Memory
    2. Named Pipes
    3. TCP/IP
  5. Then to enable the SQL Browser
  6. Select the SQL Server Services node
  7. Right click SQL Server Browser and select Start

Article ID: 193, Created On: 11/7/2011, Modified: 11/8/2011