Versions Compared

Old Version 2

changes.mady.by.user Nicholas A Hauenstein

Saved on

compared with

New Version 3

changes.mady.by.user Nicholas A Hauenstein

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: minor edit of final step

...

  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. Close After SQL Server has finished restarting, close SQL Server Configuration Manager.