Note

If you have an existing installation of Microsoft SQL Server that is configured to use Mixed Mode Authentication, and the sa account is enabled, and you have already enabled TCP/IP for Microsoft SQL Server, you may skip these steps.

Enabling Mixed Mode Authentication and the sa account

  1. Open SQL Server 2008 Management Studio.
  2. Connect to your SQL Server using Windows Authentication.
  3. In Object Explorer, right-click the name of the server, and then click Properties.
  4. On the Security tab, select SQL Server and Windows Authentication mode.

    Note

    This allows users that are controlled by Windows, and users that are only registered with SQL Server to be able to access resources managed by SQL Server.

  5. Click the OK button, and confirm your choice in any prompts that may appear.
  6. In Object Explorer, right-click the name of the server, click Restart, and then confirm your choice in any prompts that may appear.
  7. In Object Explorer, expand the Security > Logins node.
  8. Right-click on the sa login, and then click Properties.
  9. On the Status tab, configure the settings using the values shown in the table below:

    Setting

    Value

    Permission to connect to the database engine

    Grant

    Login

    Enabled
  10. On the General tab, in the Password box, type a strong memorable password.
  11. Type this same password in the Confirm Password box.
  12. Click the OK button.

Enabling TCP/IP Protocol for Microsoft SQL Server

  1. On the Start menu, click All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
  2. In SQL Server Configuration Manager, expand the node SQL Server Configuration Manager (Local) > SQL Server Network Configuration and then click on Protocols for SQLEXPRESS.
  3. If TCP/IP is disabled, right-click TCP/IP and then click Enable.
  4. If Named Pipes is enabled, right-click Named Pipes and then click Disable.
  5. Double-click TCP/IP to open the properties for the protocol.
  6. On the Protocol tab, set Listen All to Yes.
  7. On the IP Addresses tab, disable TCP Dynamic Ports by leaving it blank on all interfaces.
  8. On the IP Addresses tab, set the TCP Port to 1433 on all interfaces.
  9. Click OK to save the changes.
  10. In SQL Server Configuration Manager, expand the node SQL Server Configuration Manager (Local) > SQL Native Client 10.0 Configuration, and then click on the Client Protocols node.
  11. If TCP/IP is disabled, right-click TCP/IP and then click Enable.
  12. If Named Pipes is enabled, right-click Named Pipes and then click Disable.
  13. Double-click TCP/IP to open the properties for the protocol.
  14. Set the Default Port to 1433, and then click OK to save changes.
  15. In SQL Server Configuration Manager, click the SQL Server Services node.
  16. Right-click SQL Server (SQLEXPRESS), and then click Restart.
  17. After SQL Server has finished restarting, close SQL Server Configuration Manager.
  • No labels