Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

can't find server

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
mekofun
Asked:
mekofun
1 Solution
 
WizillingCommented:
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
 
mekofunAuthor Commented:


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
 
EvilPostItCommented:
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
 
subhashpuniaCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now