How to connect to 2008 R2 using management studio? Getting network connection error

[nagmvs]

Hi i installed Sql Server 2008 R2 in my windows 7 system.When i open the sql server 2008 R2 Management studio and try to connect using the options like

Server Type : Database Engine
Server Name : (local)
Authentication : Windows Authentication

when i am click on connect button it shows an error like
Cannot connect to (local)
[A network related or instance specific error occured while establishing a connection to sql server ,etc.....]

i attached a image please see that

So please help me to resolve this issue.

[Bassem]

In Options -> Connection Properties. See the connection protocol. Is it default?
If you are using TCP/IP or Named Pipes, you will have to enable it from the configuration tools -> Sql Server Configuration Manager.

I'm not expert, but I'm trying to help.

Thanks.

[nagmvs]

Hi Basem thanks for ur reply.I checked the Configuration manager and TCP/IP and Named Pipes are defaultly Enable.Still same problem.Anyhow thanks for ur reply.

Nagesh.MVS

[Pete Berry]

You might try a couple of things.
(1) instead of connecting via local or "." use the DNS name for the machine
(2) Try running under elevated permissions -- if I recall this has something to do with UAC and the server logins

[ck9663]

If this is your first login, try using a SQL Server account to login. Even if the server is configured for Mixed Authentication, you have not added any domain user at this stage.

Login using sa account and add the domain accounts accordingly.


Good Luck!!!

~~ CK