Fix: SQL Network Interfaces Error 28 – Server doesn’t support requested protocol
Today I am going to discuss about Microsoft SQL Server Error 28 that most of the SQL Server users might have faced at least once in their career. It belongs to SQL Server connectivity issue SQL Network Interfaces Error 28.
Microsoft SQL Server Error 28
This is very common error that most of the people have gone through. Microsoft SQL Server Error 28 details are given below:
An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 – Server doesn’t support requested protocol) (Microsoft SQL Server, Error: -1)
Sometime you might get same error as below description.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 – Server doesn’t support requested protocol)
Root Cause
Generally, we get SQL Network Interfaces Error 28 while connecting to SQL Server instance either using SQL Server Management studio or using any other way. There might be several reasons behind generating Microsoft SQL Server Error 28. I have tried to capture all such reasons in below points..
- A specified SQL Server instance name is not valid. Wrong SQL Server Instance Name can lead to generate Microsoft SQL Server Error 28.
- Remote access is not enabled for your SQL Server instance.
- The firewall on the server has refused the connection because ports used by SQLBROWSER.EXE and SQLSERVR.EXE is still blocked.
- The SQL Server Browser service (sqlbrowser) is not started.
Solution
We need to check and validate multiple factors to fix Microsoft SQL Server error 28. Check all factors given in below step by step points to fix all possibilities for this SQL error 28.
- Validate whether server on which SQL Server is hosted is reachable from your client machine or not. Run ping and telnet to make sure server connectivity.
- Make sure SQL Server is running fine on your server. Check SQL Server services.
- Firewall ports 1433 for SQL Server and 1434 for SQL Server Browser services should be opened.
- Verify correct SQL Server Instance name. Check the spelling of the SQL Server instance name that is specified in the connection string.
- Make sure to enter full SQL Server Instance name in case you have named instance like SERVERNAME\SQL2017.
- Make sure that the SQL Server Browser service is started on the server.
- Enable Remote connection for your SQL Server Instance. Most of the people face Microsoft SQL Server error 28 because remote connection was disabled on the SQL Server Instance. Use the SQL Server Configuration Manager tool to enable SQL Server to accept remote connections over the TCP or named pipes protocols. Below steps you can follow to enable remote connections.
- Launch SQL Server Configuration Manager. Expand SQL Server Network Configuration from left side pane and then click Protocols for InstanceName. If your server has default instance then it will look like “Protocols for MSSQLSERVER”
- You can see all three protocols in right side pane. Shared Memory, Named Pipes and TCP/IP.
- Make sure to enable Named Pipes and TCP/IP. Right-click at the protocol name and then click Enable. The icon for the protocol will change to show that the protocol is enabled.
- You need to restart the SQL Server services to bring the changes into effect so restart your SQL Server services.
Related Articles
- Fix SQL Server Error 40: A Network related or Instance specific Error Occurred while establishing a connection to SQL Server
- How to Fix SQL Server Error 53: Could Not Open a Connection on SQL Server?
- Fix Error 4064: Cannot open user default database
- SAP Connectivity Issue After AlwaysON Automatic failover
- Fix Error 976: Cannot connect to Secondary Replica of AOAG
Here, i have shown you how to fix sql error 28. I hope you like this article. Please follow our Facebook page and Twitter handle to get latest updates.
I am working as a Technical Architect in one of the top IT consulting firm. I have expertise on all versions of SQL Server since SQL Server 2000. I have lead multiple SQL Server projects like consolidation, upgrades, migrations, HA & DR. I love to share my knowledge. You can contact me on my social accounts for any consulting work.
Latest posts by Manvendra Deo Singh (see all)
- How to Fix SQL Error 1005: A Comprehensive Guide - April 9, 2023
- How to Fix SQL Server Error 207 – Invalid Column Name - April 9, 2023
- How to Fix SQL Error 1045: Resolving Access Denied Issues - April 8, 2023
Summary
Article Name
Fix: SQL Network Interfaces Error 28 – Server doesn’t support requested protocol
DescriptionA network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 – Server doesn’t support requested
Author Manvendra Deo Singh
Publisher Name
www.techyaz.com
Great!!!
My problem has been solved.
Thank you!!!