Solved

can't find server

Posted on 2010-11-16
4
396 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ms sql and asp dates 5 42
mssql 7 32
DMV Script to find how many times statistics are utilized 2 27
t-sql left join 2 31
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

732 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