Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from stackoverflow.com Jun 10 '13 at 5:50

This question came from our site for professional and enthusiast programmers.

    
No @PreetSangha this is not dup, because after renaming the instance, LocalDB keeps (LocalDB) as a prefix to instance name. Thank you anyway. – AVEbrahimi Jun 10 '13 at 4:41
2  
Shouldn't your application be flexible? Changing a config file when moving between machines should be easy - if you are hard-coding the instance name inside the application code, that's bad news. – Aaron Bertrand Jun 10 '13 at 12:48

Have you looked into creating an alias via Native Client Configuration? You would need to do this on every client computer that connects to the server. If you have only a few computers that connect to the server (a few web servers, maybe a devops workstation), then this isn't a big deal. There is a ServerFault question covering this topic.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.