Link to home
Start Free TrialLog in
Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America

asked on

SQL Server 2014 firewall setting

After windows 10 upgrade, I am not able to connect to SQL Server.

Question: Could you please help me to make sure the fire wall 1) turned on and 2) it has correct settings?

I am reading: "... If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked."

From: https://technet.microsoft.com/en-us/library/ms175043(v=sql.120).aspx 
"As an alternative to configuring SQL Server to listen on a fixed port and opening the port, you can list the SQL Server executable (Sqlservr.exe) as an exception to the blocked programs. Use this method when you want to continue to use dynamic ports. Only one instance of SQL Server can be accessed in this way."

We can apply easiest method which helps connect to database engine because this database is for practice purpose and doesn't contain any critical data.
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Why are you thinking the issue is with the firewall? This is not a local issue?
Avatar of Mike Eghtebas

ASKER

In my laptop, I had Windows 7 and SQL Server 2014 working just fine. But, after Windows 10 upgrade I am having connecting to database engine. At this point I am focusing on the firewall issue to make sure:

1. It is turned on.
2. It has correct setting (any setting to allow database engine to connect).

for background infor see: https://www.experts-exchange.com/questions/28703140/SQL-Server-Login-After-Windows-10-upgrade.html
SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did you install SQL Server 2014 SP1 before upgrading to Windows 10?
Microsoft recommends that as minimum requirement: https://support.microsoft.com/en-us/kb/2681562
Just installed SP1 and I can now connect even if I specify the network protocol. Strange!
@Eric,

re:> I had a similar issue yesterday. I had "Network Library = dbmssocn" in my connection string. I removed it and it is now working properly. Do you have this setting too?

I am double clicking on SSMS icon, it prompts me with login screen with the default login shown below. When I click on connect, I get:User generated image
@Vitor,

I have been using SQL Server with Windows 7 for at least 6 months. After Windows 10 upgrade I am having this problem.

As stated above, I need step by step instructions to determine:

1. Is Firewall is turned on.
2. Does the Firewall have correct setting (any setting to allow database engine to connect).
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I got it working. The problem seemed to be some of the server was set to automatic (and disabled) but I changed them to running and Manual.