CODEWITHSUNDEEP
sql-servervisual-studiovisual-studio-2013sql-server-2012localdb
shannon
shannon

Reputation: 8784

Add SQL Server Express "Advanced" features to LocalDB installed by Visual Studio

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:

Upvotes: 7

Views: 5385

Answers (2)

Guest User
Guest User

Reputation: 1

Check at Windows services, the Instance name (found within braces) for the SQL Server service.

Then,

  • start the SQL Server Express Advanced install
  • choose to modify an existing instance
  • check "full-text" under Instance Features / Database Engine Services
  • find that the installed instances list is empty at the "Instance Configuration" screen, and it wants to install a new instance...

At this point,

Manually type the instance name manually that you found at Windows services. (Instance name Case Sensitive though)

Upvotes: -1

Mike M
Mike M

Reputation: 1425

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

Upvotes: 8

Related Questions