• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

SQL Server Managent Studio not connecting to local machine

Hi
I set up a database on my local machine a few days ago. When I try to connect (as shown in the first image)
I get an error as shown in the second image

1
2
0
Murray Brown
Asked:
Murray Brown
2 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
Try clicking on the down arrow on the Server Name dropdown and select the actual server name and try again.  'local' may not be an adequate ID for it.
0
 
Mohammed KhawajaManager - Infrastructure: Information TechnologyCommented:
Also note that it is installed with an instance name then you need to enter the name in the form of servername\instancename.  Also check services to ensure the SQL server is running and if it is running as in instance the instance name will be in bracket or it could show sqlserver$instance name
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now