Menu
I have an instance of SQL Server 2012 and when I try to connect with it from other PC through SQL Server Management Studio it's not even visible. I can see all other instances which are placed on other PCs.
I tried everything to fix it:
And still I can't see my instance. Does somebody have any other ideas how to fix it?
Here are some screenshots of SQL Server Configuration Manager:
934
An existing connection was forcibly closed by the remote host' error SOLUTION: The fix is to update the Microsoft SQL 2012 Native client to a higher version on the AOS.
Security & ConnectionsRight-click on your server name and click 'Properties'. Go to the Security page for Server Authentication, and select 'SQL Server and Windows Authentication' mode. Then, go to the Connections page and ensure that "Allow remote connections to this server" is checked, and click OK.
This error is generally encountered when either: the SQL Server Native Client driver (aka "provider") is not installed or. the driver installed on the computer is not fully compatible with the version of SQL Server that is being accessed.
What server name you are using ?
You have to open port for it. After opening port your server name looks like follow.
server name : IP\SqlExpress, 5012
Where 5012 is random port.
97
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
