Solved

SQL Server Managent Studio not connecting to local machine

Posted on 2014-10-12
3
141 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now