1 / 13

Chapter 0

Chapter 0. SQL Server Remote Connection. Content. Remote connection Firewall Configuration. 1. Remote connection. 1.1. Launch SQL Server Surface Area Configuration 1.2. Configure Remote Connection 1.3. Configure SQL Server Browser 1.4. Confirm Configuration 1.5. Configure services.

temple
Download Presentation

Chapter 0

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Chapter 0 SQL Server Remote Connection

  2. Content • Remote connection • Firewall Configuration

  3. 1. Remote connection 1.1. Launch SQL Server Surface Area Configuration 1.2. Configure Remote Connection 1.3. Configure SQL Server Browser 1.4. Confirm Configuration 1.5. Configure services

  4. 1.1. Launch SQL Server Surface Area Configuration • Start Menu > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration

  5. 1.2. Configure Remote Connection • SQLEXPRESS > Database Engine > Remote Connections

  6. 1.3. Configure SQL Server Browser • SQLEXPRESS > SQL Server Browser > Service

  7. 1.4. Confirm Configuration

  8. 1.5. Configure services 1.5.1. Restart SQL Server Service 1.5.2. Start SQL Server Browser Service

  9. 1.5.1. Restart SQL Server Service • Control Panel > Administrative Tools > Services

  10. 1.5.2. Start SQL Server Browser Service • Control Panel > Administrative Tools > Services

  11. 2. Firewall Configuration 2.1. Configure Exception for SQL server 2.2. Configure Exception for SQL Browser

  12. 2.1. Configure Exception for SQL server • Control Panel > Windows Firewall > Exception > Add Program • Then Browse… > Microsoft SQL Server > MSSQL.1 > MSSQL > Binn

  13. 2.2. Configure Exception for SQL Browser • Control Panel > Windows Firewall > Exception > Add Program • Then Browse… > Microsoft SQL Server > 90 > Shared

More Related