'localhost' no longer supported - SQL2012

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Sun 25 Mar 2012 22:37

'localhost' no longer supported - SQL2012

Post by PhocasDev » Sun 25 Mar 2012 23:29

The default local instance of a SQL Server; 'localhost' is no longer supported by the TMSConnection component when using SQL2012.

You can test this yourself by using the 'Edit Connection' from the context menu in the IDE. Switch to Windows Auth, enter 'localhost' and dropdown the database combo - and wait 20 seconds for 'SQL Server does not exist or access denied'. Doing exactly the same thing on a machine running SQL2008R2 works fine. 'localhost' still works when using the standard TADOConnection component.

Using the machine name instead also works fine, but we use 'localhost' widely for deployments on sqlexpress.

XE2 update 4 with SDAC 6.1.5
64 bit Windows 7
SQL Server 2012 Developer.


Post by AndreyZ » Mon 26 Mar 2012 15:19


For the time being SDAC doesn't support SQL Native Client 11 that is supplied with SQL Server 2012. SDAC uses OLEDB provider where there is no SQL Native Client provider 2005 or 2008, and OLEDB provider doesn't allow connecting to SQL Server using "localhost" as a server. To avoid the problem, you should use the computer name instead of "localhost". We will add support of SQL Native Client 11 in one of the nearest SDAC builds.

Post Reply