Solved

SQL Server Managent Studio not connecting to local machine

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSIS with VPN COnnection 2 74
Return 0 on SQL count 24 29
When will SQL Server MIgratoin Assistant support for IBM AS/400 iSeries DB2 4 32
Sql Query 6 65
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 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