Solved

can't find server

Posted on 2010-11-16
4
391 Views
Last Modified: 2012-05-10
Hi,

I have installed SQL Server 2008 R2 in my home laptop. It may be a stupid question but I am just a beginner.

When I try to connect to Server, enter the Server name . error message show "can't find the server"  I enter the server name same as what I entered during installation.

Do I need to set up the serve ? Or how can I find out whether have any server set up or not?

Thanks
0
Comment
Question by:mekofun
4 Comments
 
LVL 13

Expert Comment

by:Wizilling
ID: 34151729
try entering localhost

did u add urself as the sysadmin during install ?

is the sql server service started?

did you give a named instance.. then try localhost\instancename
0
 

Author Comment

by:mekofun
ID: 34152355


did u add urself as the sysadmin during install ?  
- I do add the serve name during install - MSSQLSERVE

is the sql server service started?
- Yes, I have checked it before

did you give a named instance.. then try localhost\instancename  
- I don't think I have done this
0
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34153126
As you have installed it on your laptop then you have either SQL Express or Developer.

If you have installed express then the instance would have been given a default instance name so try connecting with .\SQLEXPRESS (or HOSTNAME\SQLEXPRESS).

To find out what the instance name is look in services and you will see something like this.

SQL Server([INSTANCENAME])
0
 
LVL 6

Expert Comment

by:subhashpunia
ID: 34153702
On command prompt run the following cammoand to check the server name:

sqlcmd -L

Now connect to this server by using its name listed by above command.
For more information about some common issues please check:

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

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.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 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