If you want others (such as a service) to be able to access your LocalDB instance, you need to share it using the sqllocaldb.exe command line utility.Īlso #1: (localhost)\MSSQLLocalDB is not a valid syntax. Is Navicat installed on the same computer as LocalDB? LocalDB doesn't allow for remote connections.Īssuming that Navicat is installed on the same computer: is Navicat a service or desktop application? LocalDB runs, by default, as a private user process that only your Login can see (no problem for a desktop application that you are running). I am sure that the instance name is correct as you can see in the image:
I am using SQL Server 2016, which does not need a native client.Īfter trying out some more I was able to land on a new error as shown in the second image file below. I believe the download links are for SQL Server 2012.
I am using the recent SQL Server 2016 LocalDB. There is no SQL Server 2016 Native Client. Microsoft SQL Server Native Client 11.0 is installed when you install SQL Server 2016. Installing SQL Server Native Client says: Is it not a SQL Server native client? I don't want to install both LocalDB server and MS SQL Server Express Edition as I have no need of SQL Server Express Edition. I've searched the internet but couldn't find the exact solution for my problem in Navicat premium software.
I noticed by default LocalDB server always creates an instance named MSSQLLocalDB when started. I am unable to get the correct Host Name/IP Address for the LocalDB server. I am trying to create a connection to the LocalDB server in Navicat Premium.
0 kommentar(er)
