Solved

SQL Server Managent Studio not connecting to local machine

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

Accepted Solution

by:
Dave Baldwin earned 250 total points
Comment Utility
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 24

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 250 total points
Comment Utility
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
Comment Utility
Thanks very much
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

771 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

13 Experts available now in Live!

Get 1:1 Help Now