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

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

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

1 Answer

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.