472,122 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,122 software developers and data experts.

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, 3885 views)
Oct 31 '10 #1
4 6435
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.