Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

No successful connection to microsoft sql after upgrade to 10.2

hakiru's profile image hakiru posted 5 months ago in Creating a connection Permalink

When I use 10.1 everything works correctly.

Of course I use the same credentials, it's TCP/IP connection. On 10.2 receive the error: SQL Error (17): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

I noticed that in 10.2 I have new option "Library" and I can't change it when I use MSQL connection - libmariadb.dll is chosen and select box is disabled.

ansgar's profile image ansgar posted 5 months ago Permalink

The library dropdown is just for MySQL connections. On MSSQL it does nothing.

Perhaps you need the updated OLE DB driver?

buttm2's profile image buttm2 posted 4 months ago Permalink

The library dropdown is just for MySQL connections. On MSSQL it does nothing.

Perhaps you need the updated

Hi, i am having the same issue. I have MSOLEDBSQL selected in the Library dropdown. The connection fails and i get the following error: SQL Error (0): TCP Provider: No connection could be made because the target machine actively refused it Login timeout expired. Thanks

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 4 months ago Permalink

https://blogs.msdn.microsoft.com/sql_protocols/2007/07/19/tcp-provider-no-connection-could-be-made-because-the-target-machine-actively-refused-it/

buttm2's profile image buttm2 posted 3 months ago Permalink

Thanks ansgar, I think this problem exists in the nightly builds. I am using ver. 10.2 and the connections work fine in it but as soon as i update to the nightly build, the same connection stops working. Hope this helps.

ansgar's profile image ansgar posted 3 months ago Permalink

Does it then work with SQLOLEDB library?

buttm2's profile image buttm2 posted 3 months ago Permalink

Does it then work with SQLOLEDB library?

No. It does not work with both SQLOLEDB and MSOLEDBSQL.

Please login to leave a reply, or register at first.