Tip: SQL Express Configuration Issue

SQL Express Configuration Issue

You can manually configure SQL Express and the Windows Firewall to allow remote access. Use the following steps to enable remote access to SQL Express:

  1. Open the SQL Server Configuration Manager by clicking Start, All Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.
  2. In the left pane of the SQL Server Configuration Manger, expand the node for SQL Server 2005 Network Configuration and select Protocols for SQLEXPRESS.
  3. In the right pane, right-click Named Pipes and choose Enable.
  4. Right-click TCIP/IP and choose Enable.
  5. In the left pane, select SQL Server 2005 Services.
  6. In the right pane, right-click SQL Server Browser and choose Properties.
  7. Click the Services tab in the Properties dialog box.
  8. On the Services page, set the Start Mode property to Automatic and click OK.
  9. Right-click SQL Server Browser and choose Start.
  10. Right-click SQL Server (SQLEXPRESS) and choose Restart.

Use the following steps to configure the Windows Firewall:

  1. Open the Windows Firewall dialog box and click the Exceptions tab.
  2. Click Add Program and Browse to find sqlbrowser.exe and click OK.
  3. Click Add Program and Browse to find sqlservr.exe. Click OK.
  4. Click Add Port and enter "SQL Service" for Name, 1433 for Port number, and select the TCP radio button.
  5. Click OK on the Windows Firewall dialog.


About the Author

Sushankar layak

Hi I am a Software developer, and specialized in Microsoft.Net.

Comments

  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Live Event Date: May 11, 2015 @ 1:00 p.m. ET / 10:00 a.m. PT One of the languages that have always been supported with the Intel® RealSense™ SDK (Software Developer Kit) is JavaScript, specifically so that web-enabled apps could be created. Come hear from Intel Expert Bob Duffy as he reviews his own little "space shooting" game where the orientation of your face controls the aiming reticle to help teach developers how to write apps and games in JavaScript that can use facial and gesture …

  • You may not realize the complexity you could be creating when developing mobile apps – many companies don't initially. You could be doubling your IT costs for development and delivery; not to mention, risking sales, productivity and brand satisfaction. Read this IBM-commissioned Forrester Study to understand the key cost drivers of mobile app delivery -- for both customer-facing and enterprise applications. Find out how you could lower costs and increase success with the right strategy and investment.

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date