Loading
search-img

gert.leunen asked a question.

December 20, 2012 at 6:01 PM
Can't connect localdb
Despite having installed SQL Server 2012 Express SP1 LocalDB (64 bit) + SQL Server 2012 Native Client on my fully updated Windows 8 64 bit system, having server name set to (localdb)\v11.0 and having modified AdoDriverName field (in ISSQLDBMetaData table) to sqlncli11, it seems my InstallShield SQL scripts (when running a 32 bit installer) still can't connect to the database engine with the following error (although I verified 32 bit sqlcmd can connect to that instance while the error is being shown):

 

1: Attempting to establish the SQL connection... Server: (localdb)\v11.0, Database: master

 

1: ADO Error: Number: -2147467259 Description: SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Source: Microsoft SQL Server Native Client 11.0 SQL State: 08001 Native Error: -1

 

1: ADO Error: Number: -2147467259 Description: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. Source: Microsoft SQL Server Native Client 11.0 SQL State: 08001 Native Error: -1

 

1: ADO Error: Number: -2147467259 Description: Login timeout expired Source: Microsoft SQL Server Native Client 11.0 SQL State: HYT00 Native Error: 0

 

Error 27502.Could not connect to Microsoft SQL Server '(localdb)\v11.0'. Login timeout expired (0)

 

MSI (s) (10!B8) [18:37:12:672]: Product: Martin M-Series -- Error 27502.Could not connect to Microsoft SQL Server '(localdb)\v11.0'. Login timeout expired (0)

 

Please help? Tnx
  • 5 answers
  • 88 views

  • gert.leunen

    Found it, InstallShield at some point also created a property called IS_SQLSERVER_NETLIB_MS which was set to "Network Library=DBMSSOCN". This property is referenced from the AdoCxnNetLibrary field in the ISSQLDBMetaData table and instructs the client to use a TCP/IP socket to connect to the database engine. LocalDB, however, only supports named pipes connections. Clearing the AdoCxnNetLibrary field in the ISSQLDBMetaData table, for example, fixes the problem.
    Expand Post

  • 0_H Yamanishi (Flexera Software)

    Make sure that the LocalInstanceNames column of the ISSQLDBMetaData table specifies "(localdb)" as follows:

     

    " (local);(localdb);. "

     

    InstallShield handles the names listed in this setting as a local instance and omitts the Network Library= parameter from the connection string.
    Expand Post

  • christoph.storm

    Hi,

     

    I tried both your suggestions but still having the same problem that my installation returns Error 27502 when I click next on the "Database Server" dialog.

     

    I get Error 27502.Could not connect to Microsoft SQL Server '(local)'.

     

    I use IS2012 Spring

     

    SQL2012, SP1 x64

     

    I am very happy to hear from you. Cheers,

     

    christoph
    Expand Post

  • 0_H Yamanishi (Flexera Software)

    If you are trying to connect a LocalDB, you need to use "(localdb)" for the target server name. To connect the default instance, specify "(localdb)\v11.0".

Create a case with Support
0/255
Upload Attachment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to cancel the case creation?

Are you sure you want to close this case

Get Hotline support
Products Region Phone Numbers
FlexNet Operations
FlexNet Embedded
FlexNet Publisher
FlexNet Connect
FlexNet Code Insight
InstallAnywhere
InstallShield 		North America  * +1 630-332-2513 (toll)
+1 877-279-2853 (toll-free in North America)
Europe  * +44 1925 944367 (toll)
+44 800 047 8642 (toll-free in Europe)
Japan  * +81 3-4540-5335 (select option 2)
Australia  * +61 3 9895 2177
+61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics)
Compliance Intelligence 		Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.
Book an Appointment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)
+1.800.374.4353
CONTACT US REVENERA.COM FLEXERA.com
© 2026 Flexera Software. All Rights Reserved.
Privacy policy Terms and conditions Flexera Community Contact Us
Loading
Can't connect localdb