Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Enabling Remote Connections - SQL Server 2005 Express

RSS
Modified on Wed, Oct 22, 2008, 8:47 PM by Administrator Categorized as SQL Server
To enable remote connections for SQL Server 2005 Express Edition, perform the following procedure.

  1. Start Menu > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.
  2. Click Surface Area Configuration for Services and Connections.
  3. Expand Database Engine and click Remote Connections.
  4. Select Local and Remote Connections.
  5. Select Both TCPIP and named pipes.
  6. Use Database > Service to restart the database.

A reboot may be necessary

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.