Solved

can't find server

Posted on 2010-11-16
4
395 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Table where row act as column 11 68
query output (script) from a stored procedure 4 36
sql update 2 36
Data encryption options between SQL DBs 3 22
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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

735 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