I installed VS 2013. It installed SQL Server 2012 Express with LocalDB. That's great, except that I need full-text search, and it didn't install "Advanced Services" (and I didn't see an option during install).
I've downloaded SQL Server 2012 Express w/Advanced Services to add this, but it seems to want to install it on a new instance. Does this sound familiar to you? How did you add SQL Server Advanced Services to your LocalDB installation?
I had the same issue last VS version, and resorted to reinstalling SQL Server then. I apologize for coming to the community with a mundane question, but it vexes me. :)
Here's what I did:
To add a new feature to an existing instance of SQL Server, select Installation in the left-hand navigation area, and then select New SQL Server stand-alone installation or add features to an existing installation. The System Configuration Checker will run a discovery operation on your computer.
Alternatively, you can install LocalDB through the Visual Studio Installer, as part of the Data Storage and Processing workload, the ASP.NET and web development workload, or as an individual component.
\SQLEXPRESS you are looking for a named instance of SQL Server called "SQLEXPRESS" that is on your local machine and connected to via a shared memory interface (that's what the dot is). Local DB is a deployment option for SQL Express that runs as an attached process to another application, instead of as a service.
Looks like this cannot be done, unfortunately.
LocalDB is cool, but apparently not all-powerful.
Check out this existing post (among others):
Can't create an index catalog in localdb v\11.0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With