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.
'localhost' no longer supported - SQL2012
-
AndreyZ
Hello,
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.
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.