Solved

Allowing Remote Connections to SQL Server 2005 through Windows Firewall

Posted on 2015-01-19
6
187 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
  • 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 46

Accepted Solution

by:
Vitor Montalvão earned 500 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 46

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 46

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql calculate reminders 11 69
What is the best way to calculate hours worked 5 61
Testing connection to sql 7 58
McAfee LiveSafe firewall is blocking a safe website 3 88
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…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now