Take the 2-minute tour ×
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.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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