Skip to content

Specify Forums

Personal tools
You are here: Home » Specify Procedures » Configuring SQL 2005 to Accept Remote Connections

Configuring SQL 2005 to Accept Remote Connections

Document Actions
  1. Open the SQL Server Configuration Manager.
    SQL Server Configuration Manager
  2. If SQL Server Browser has a red square next to it, then you will need to change it to start automatically. Right click on "SQL Server Browser".
    Browser Properties
  3. Select the "Service" tab, then make sure that "Start Mode" is set to "Automatic".
    Service tab
  4. Click to apply this change and OK until you get back to the Configuration Manager.
  5. Expand "SQL Server 2005 Network Configuration" and then select "Protocols for SQLEXPRESS".
    Configuration protocols
  6. Make sure that all protocols are enabled, if they are not, right-click and select enable.
  7. Restart your server and sql browser to finish.
Created by cj
Last modified 2006-09-28 04:00 PM
 

Powered by Plone

This site conforms to the following standards: