Developer technologies | ASP.NET Core | Other
A set of technologies in .NET for building web applications and web services. Miscellaneous topics that do not fit into specific categories.
.NET 6 SQL server 2014 connection problem
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 72%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gev Gev
1
Reputation point
In the .net 6 project, we are using Dapper for data access and we facing a problem when trying to connect to SQL server 2014. But the same code works fine for SQL Server 2019. We are using SqlConnection from System.Data.SqlClient namespace.
Is there way outcome this problem without upgrading SQL Server ?
-----------------------------------------------------------------------------
Error :
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Developer technologies | ASP.NET Core | Other
-
AgaveJoe 31,361 Reputation points2022-12-05T16:32:25.3+00:00 Perhaps you need to update the SQL server 2014 to TLS version to 1.2.
-
Sign in to comment
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more