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

  • 10 Rules that Make or Break Enterprise App Development Projects In today's app-driven world, application development is a top priority. Even so, 68% of enterprise application delivery projects fail. Designing and building applications that pay for themselves and adapt to future needs is incredibly difficult. Executing one successful project is lucky, but making it a repeatable process and strategic advantage? That's where the money is. With help from our most experienced project leads and software engineers, …

  • Live Event Date: August 19, 2014 @ 11:00 a.m. ET / 8:00 a.m. PT You deployed your app with the Bluemix PaaS and it's gaining some serious traction, so it's time to make some tweaks. Did you design your application in a way that it can scale in the cloud? Were you even thinking about the cloud when you built the app? If not, chances are your app is going to break. Check out this upcoming webcast to learn various techniques for designing applications that will scale successfully in Bluemix, for the …

Most Popular Programming Stories

More for Developers

Latest Developer Headlines

RSS Feeds