ASP.NET MVC How to open Database in SQL Server Management Studio (can't connect server)?
Pretty much the title. I have tried to go to the connection string to get the the server name and insert into the Connect to Server dialog in Management Studio, but it says not found. It may not be irrelevant but the Server Name in my connection string that I tried to connect to is "(localdb)\mssqllocaldb". Help?
3 Replies
Make sure the LocalDB is running.
1. using Windows + R
2. then type services.mcs
3. then find sql server which was off.
4. I've run it using right-click. Then connection was back
Which one of the service should I be looking for specifically?
Thanks for responding btw 🙂
Sorry, there is no service for mssqlLocaldb. My mistake
You have to start the instance via CMD, the command for this is as follows.
sqllocaldb start mssqllocaldb