469,097 Members | 1,608 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

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

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.
Attached Images
File Type: jpg Sql server 2008 r2 problem.jpg (55.9 KB, 3801 views)
Oct 31 '10 #1
4 6243
344 100+
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.

Nov 1 '10 #2
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.

Nov 1 '10 #3
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
Nov 3 '10 #4
2,878 Expert 2GB
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
Nov 3 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by dotNetDave | last post: by
reply views Thread by CAIBird | last post: by
13 posts views Thread by AAaron123 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.