asked on

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

Wizilling

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

mekofun

ASKER

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

ASKER CERTIFIED SOLUTION

EvilPostIt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

subhashpunia

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/