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: 184
Please follow the below steps as shown in pictures to configure SQL Server Express 2005 for remote access.
Fig1: Open SQL Serve Configuration Manager
Fig2: Navigate to SQL Serve 2005 N/W configuration and click on Protocols node
Fig3: Enable TCP/IP Protocol
Fig4: Enable Named Pipes Protocol
Fig5: After enabling TCP/IP and Named Pipes protocols
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