Configure SQL Express 2005 for remote access

Posted on Microsoft .NET Support Team See other posts from Microsoft .NET Support Team
Published on Fri, 28 Jan 2011 09:46:00 +0000 Indexed on 2011/01/28 23:34 UTC
Read the original article Hit count: 156

Filed under:

Please follow the below steps as shown in pictures to configure SQL Server Express 2005 for remote access.

clip_image002

Fig1: Open SQL Serve Configuration Manager

clip_image004

Fig2: Navigate to SQL Serve 2005 N/W configuration and click on Protocols node

clip_image006

Fig3: Enable TCP/IP Protocol

clip_image008

Fig4: Enable Named Pipes Protocol

clip_image010

Fig5: After enabling TCP/IP and Named Pipes protocols

clip_image012

Fig6: Finally click on TCP/IP to configure the port number to listen N/W requests to SQL Express 2005.

© Microsoft .NET Support Team or respective owner