Murty M
asked on
SQL error: : A connection was successfully established with the server, but then an error occurred during the login process.
SQL error: : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error:0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
We have one SQL 2012 Std server.
We build another new Windows 2012 R2 DataCenter Server to install SQL management Studio.
When we are trying to connect SQL DB server from new SQL management Studio, we are getting above error.
Please suggest.
Source: SQL DB Server OS: Windows 2012 R2 Data Centre
Source: SQL DB Server version: SQL 2012 Standard Edition
Destination Server: SQL Studio Installed on Server OS: Windows 2012 R2 Data Centre
Destination Server: SQL management Studio Version Build number: 15.0.18142.0
We have one SQL 2012 Std server.
We build another new Windows 2012 R2 DataCenter Server to install SQL management Studio.
When we are trying to connect SQL DB server from new SQL management Studio, we are getting above error.
Please suggest.
Source: SQL DB Server OS: Windows 2012 R2 Data Centre
Source: SQL DB Server version: SQL 2012 Standard Edition
Destination Server: SQL Studio Installed on Server OS: Windows 2012 R2 Data Centre
Destination Server: SQL management Studio Version Build number: 15.0.18142.0
ASKER
Could you please let me know, where can I check this TLS protocols?
Path?
Path?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Earlier we haven't installed SQL Configuration manager, now we installed and set the TCP/IP enabled.
Also followed above articles.
Still, no luck.
Any suggestions?
Also followed above articles.
Still, no luck.
Any suggestions?
ASKER
DB Server details: OS Windows server 2012 R2 Datacenter, DB: Microsoft SQL Server 2012 SP
Application Server details :OS Windows server 2012 R2 Datacenter
Beacon Server Details:OS Windows server 2012 R2 Datacenter
Here SQL Management studio we are able to connect from Application server to SCCM DB Server.
While connecting from Beacon server to SCCM DB Server getting below error.
SQL error: : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error:0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
servers.jpg
Please suggest the next steps.
Application Server details :OS Windows server 2012 R2 Datacenter
Beacon Server Details:OS Windows server 2012 R2 Datacenter
Here SQL Management studio we are able to connect from Application server to SCCM DB Server.
While connecting from Beacon server to SCCM DB Server getting below error.
SQL error: : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error:0 – An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
servers.jpg
- All Application servers have the same VLAN.
- All App servers are same OU.
- SCCM DB server is on separate VLAN, able to connect Application server but not Beacon server.
- TLS registry enable 1.2 in Beacon Server
- Installed SQL Native client in Beacon server
- Installed ODBC Driver in Beacon server
- Installed OLEDB Driver in Beacon server
- All relevant patches are updated in Beacon server.
- We take separate server and Installed respective software’s, even we get the same error on this server.
Please suggest the next steps.
ASKER
Any suggestions?
Ensure your client side connection matches server side TLS protocols supported.