Cannot Connect to Named Instance of SQL Server behind a Firewall

I installed SQL Server 2008 Express on all of my workstations at home this weekend to have a test environment to play with before my 70-453. I had never installed SQL Server across a workgroup before, so it was a learning experience.

Two of the workstations were Windows XP Professional and one was Windows Vista Home Premium. The installs were all fairly uneventful. Being SQL Express intalls, i used the SQLEXPRESS named instance. I opened up TCP port 1433 in Windows Firewall and enabled remote connections.

All set, right? No.

OK. Let’s check everything again.

  1. SQL Server Browser service running? Check
  2. Remote connections enabled? Check
  3. Exception for TCP port 1433? Check

All set, right? No.

Crap.

After a half hour of searching and five minutes of cursing I discover the SQL Server Browser service uses UDP port 1434. I added the exception and everything is hunky-dory.

~Ron

Advertisements

0 Responses to “Cannot Connect to Named Instance of SQL Server behind a Firewall”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: