You should use Shared Instances feature of LocalDB. These two posts on Using LocalDB with Full IIS should give you more information. Especially the second part seems relevant, but the first one contains some context as well. (note: the original links are no longer available, using archive.org instead) Part 1: User Profile Part 2: Instance … Read more
Any chance it is because you forgot to double-escape the backslash? Did you try this: “Data Source=(LocalDB)\\v11.0;Integrated Security=true” Or even better, you could just use the @ mark to disable character escaping for the entire connection string: @”Data Source=(LocalDB)\v11.0;Integrated Security=true”
LocalDB was introduced in SQL Server 2012 CTP3. It’s basically a new version of SQL Express, with same functionality, dedicated to developers. So you don’t need to install any SQL server. If you have installed SQL 2012 or Visual Studio 11 then you already have it, and it runs over .Net 4 or higher. If … Read more
I am totally unable to connect to localdb with any tool including MSSMA, sqlcmd, etc. You would think Microsoft would document this, but I find nothing on MSDN. I have v12 and tried (localdb)\v12.0 and that didn’t work. Issuing the command sqllocaldb i MSSQLLocalDB shows that the local instance is running, but there is no … Read more
The timeout is configurable via T-SQL with ‘user instance timeout’ option: sp_configure ‘show advanced options’, 1; RECONFIGURE; GO sp_configure ‘user instance timeout’, 5; GO The timeout is expressed in minutes and has a maximum value of 65535. I’m pretty sure you need to restart the instance after setting it. And don’t try setting it to … Read more
Maybe you have to execute the following in the Visual Studio Tools command prompt: aspnet_regiis -i You can read more about the ASP.NET IIS Registration Tool (Aspnet_regiis.exe) here.
From MSDN The primary method of installing LocalDB is by using the SqlLocalDB.msi program. LocalDB is an option when installing any SKU of SQL Server 2012 Express. Select LocalDB on the Feature Selection page during installation of SQL Server Express. There can be only one installation of the LocalDB binary files for each major SQL … Read more
I was also suffering from same problem, but there is a solution for it. Go to the IIS server, and then to the application pool from which your application is running. In the advanced settings of the application pool there is a “Process Model” option, under which there is an “Identity” option. This is by … Read more
The (localdb)\ProjectsV12 and (localdb)\ProjectsV13 instances are created by SQL Server Data Tools (SSDT) and should not be used by applications (localdb)\MSSQLLocalDB is the SQL Server Express 2014/2016 LocalDB default instance name and an “automatic instance”. You can use the sqllocaldb.exe command line tool to manage which version (2014 or 2016) owns the MSSqlLocaldb instance And … Read more
Yes, it is possible. The connection string for a LocalDB instance using jTDS looks like this: jdbc:jtds:sqlserver://./DatabaseName;instance=LOCALDB#88893A09;namedPipe=true This works as of jTDS 1.3.2. You can download a release here: https://github.com/milesibastos/jTDS/releases/download/v1.3.2/jtds-1.3.2-dist.zip To find the named pipe for your desired LocalDB, run SqlLocalDb info NameOfTheLocalDBInstance which will give you something like np:\\.\pipe\LOCALDB#88893A09\tsql\query It’s probably best to connect … Read more