'localhost' no longer supported - SQL2012
Posted: 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.
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.