CodeKicks.com
Focus on Microsoft Technologies - Tutorials, Articles, Code Samples.

Friday, January 28, 2011

Configure SQL Express 2005 for remote access

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.

Post a Comment