Solved

Can't connect to local instance of MS SQL 2008 R2

Posted on 2014-12-20
3
161 Views
Last Modified: 2014-12-20
I just installed MS SQL 2008 R2 in my development computer, first the Enterprise Manager then the Engine.

Installation went fine and both programs run ... but when I try to connect to my local server I click browse and nothing comes up, I tried entering (local) no luck. I named the instance:  MSSQLSERVER

I enter that name, nothing either.

Any ideas ?
0
Comment
Question by:amucinobluedot
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 500 total points
Comment Utility
Try PC-NAME\MSSQLSERVER, (local)\MSSQLSERVER or .\MSSQLSERVER
0
 

Author Comment

by:amucinobluedot
Comment Utility
Tried all of them with no luck :(
0
 

Author Comment

by:amucinobluedot
Comment Utility
I entered the name of the server only and it worked .. go figure ! thx
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

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 …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

772 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

12 Experts available now in Live!

Get 1:1 Help Now