Specifically for SQL Server 2012 Express LocalDB

learn more… | top users | synonyms

0
votes
0answers
195 views

LocalDB in Management studio, login failed for Windows Administrator account

When I try to log in to (localdb)\v11.0 from Sql Management Studio (2012).. I get this error TITLE: Connect to Server Cannot connect to (localdb)\v11.0. ADDITIONAL INFORMATION: ...
3
votes
1answer
1k views

How to move folder of SQL Server LocalDB instances from the default location?

I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
0
votes
0answers
64 views

How to let another use a LocalDb Instance and MDF combination previously used by LocalSystem or another user

I have a software installation that includes a Topshelf service and an MVC4 web application. Both need to access the same LocalDb MDF. The development version runs as our users. The installed version ...
2
votes
5answers
7k views

Cannot start SqlLocalDB instance with my Windows account

I'm the administrator and simply run the command: sqllocaldb start v11.0 Result: Start of LocalDB instance "v11.0" failed because of the following error: Error occurred during LocalDB instance ...
-1
votes
1answer
136 views

Change server name for SQLLocalDB instance

Is there any way to change the instance name of LocalDB of SQL Server 2012 from (LocalDB)\xxxx to just xxxx? I need it for an application that needs SQL Server DB instance name to be MSSQLDEFAULT.
1
vote
0answers
506 views

Should xp_logevent and RAISERROR … WITH LOG work on LocalDB?

I need to run a script to configure a LocalDB (v11.0.3000) instance and database (from a .NET 4.5 program) and I want to record results at various stages. Someone suggested xp_logevent but it doesn't ...
6
votes
1answer
611 views

What is the migration/deployment path from a LocalDB solution to Enterprise instance?

Given the extant definition for SQL Server 2012's LocalDB as SqlLocalDB is a local, low-overhead database engine of SQL Server 2012 (and future versions) that allows developers to focus on ...