Configure SQL Express 2005 for remote access

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

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: 189

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

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Categories cloud

.NET ASP.NET iphone linux python Windows mysql android sql windows-7 html c ruby-on-rails css objective-c ubuntu networking sql-server wpf asp.net-mvc ruby database Xml apache AJAX osx security regex django Performance 12.04 windows-xp mac web-development iphone-sdk vb.net Silverlight apache2 flash server perl best-practices email installation eclipse visual-studio algorithm windows-server-2008 winforms wcf firefox bash dns /Oracle