?
Solved

Allowing Remote Connections to SQL Server 2005 through Windows Firewall

Posted on 2015-01-19
6
Medium Priority
?
194 Views
Last Modified: 2015-01-19
Hi all,

I am trying to allow sql remote connections to SQL Express 2005.

Now if I turn off the windows firewall I can connect successfully, However when I turn on the public profile settings it stops any connection being made.

I've added UDP port 1434 and TCP port 1433 to be allowed as both incomgin and outgoing ruls on the fire wall.

However when I try to connect through VS im getting the 40 error, saying the server doesnt exist?

Any ideas?
0
Comment
Question by:flynny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 24

Expert Comment

by:VB ITS
ID: 40557427
Have you tried all the steps in this article? http://support.microsoft.com/kb/914277

Take note of the text in bold blue text as they collapse to reveal instructions when clicked.
0
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 40557461
Do you have more SQL Server instances in that server?
And are you sure that instance is listening on 1433?
0
 

Author Comment

by:flynny
ID: 40557506
Thanks for the replies guys,

Vitor,

Yes there is an instance of SQL Server 2008 running on the server as well. How do I identify theport thats being used on the instance?

(As far as I was aware 1434 UDP redirected to the correct instance? am I wrong?)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40557508
The 1433 and 1434 are used by default for the first installed instance but you can confirm it in SQL Server Configuration Manager by checking in the TCP/IP properties of the instance.
0
 

Author Closing Comment

by:flynny
ID: 40557511
Many thanks Vitor, there insrance was running on a different port.

http://sqlandme.com/2013/05/01/sql-server-finding-tcp-port-number-sql-instance-is-listening-on/

helped me identify and solve.

Thanks for pointing me in the right direction.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40557518
Just a warning. If the server is behind a firewall you won't want to set a dynamic port for that instance because after each reboot it may use a different port so it's better you chose a static port.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question