Mike Eghtebas
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.
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.
Why are you thinking the issue is with the firewall? This is not a local issue?
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Microsoft recommends that as minimum requirement: https://support.microsoft.
Just installed SP1 and I can now connect even if I specify the network protocol. Strange!
ASKER
@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:
@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).
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:
@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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.