Starting an SQL Server

Databases
1

I am trying to connect to a local database in SSMS (management studio)… as per the instructions here…

but it is telling me no local servers were found, when I look in Visual Studio it looks like there are two… What am I missing!?

884×388 23.9 KB

…you can see I’ve even tried running both programs as an administrator…

2

Try doing this:

  1. Down below in the Object Explorer, click Connect button or blue icon next to it.
  2. You’ll get a dialog box prompting you to put your server details.
  3. Choose Database Engine and type your server instance name, in your case (localDb)\MSSQLLocalDB or (localDb)\ProjectsV13.
  4. Select Windows Authentication
  5. Press Enter

You should be able to log in now. Then, follow the previous thread’s advice to set and activate your sa password.

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.