Solved

SQL Server Managent Studio not connecting to local machine

Posted on 2014-10-12
3
150 Views
Last Modified: 2014-10-12
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
Comment
Question by:murbro
3 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 250 total points
ID: 40375896
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
 
LVL 25

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 250 total points
ID: 40376174
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
 

Author Closing Comment

by:murbro
ID: 40376359
Thanks very much
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question