Top Posts | Top Performers | Tutorials: ASP.NET | Silverlight | ASP.NET AJAX | jQuery Write for us (and win!): Article | Int. Question | Career Question | Job Profile | Code | Question | Joke | Link || Subscribe | Blog | Search | Register

Online : 169 | Welcome, Guest! Login

* Click Here! Cheap ASP.NET Hosting for Only $4.95/month *

Home > Forums > Sql Server > When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server Management Studio Express, I get the following error:

Winners & Prizes !

Winners & Prizes

Congratulations!
Cheques have been sent to the winners.

Interview Questions For

◘ .NET Framework (148)
◘ ADO.NET (65)
◘ AJAX (24)
◘ Aptitude Test (2)
◘ ASP.NET (339)
◘ BizTalk Server (10)
◘ C# (142)
◘ CSS (9)
◘ Design Pattern and Architecture (32)
◘ HR (1)
◘ HTML, DHTML (17)
◘ JavaScript (15)
◘ jQuery (2)
◘ LINQ (27)
◘ OOPS (34)
◘ Others (11)
◘ Project Management (49)
◘ Remoting, Web Services, XML, XSLT (33)
◘ SharePoint (50)
◘ Silverlight (43)
◘ SQL Server (216)
◘ VB.NET (1)
◘ WCF (64)
◘ WPF (17)
◘ WWF (10)

Sponsors

Articles For

◘ .NET Framework (19)
◘ ADO.NET (12)
◘ ASP.NET (205)
◘ ASP.NET AJAX (9)
◘ BizTalk Server (3)
◘ C# (50)
◘ CSS (2)
◘ F# (1)
◘ JavaScript (11)
◘ Management (10)
◘ OOPS (8)
◘ Others (11)
◘ Pattern and Practices (14)
◘ SEO (2)
◘ SharePoint (13)
◘ Silverlight (16)
◘ Sql Server (35)
◘ VB.NET (2)
◘ WCF (15)
◘ Web Analytics (1)
◘ Windows Forms (10)
◘ WPF (4)
◘ WWF (3)

Win at least 8 gifts every month now! >> Top Performers of this month.

.NET Mock Interview Videos Part 1, 2, 3. Watch these great videos free of cost !
This month, we are distributing prizes worth Rs. 18,750/- (estimated) including Rs. 3000/- cash. Write for us and win!.
Career advice on Which is best, either Technical or Management side for Career Growth in IT Field? Read here.

Notice: If page content has been copied from other sources without proper permission, kindly let us know with details from where it has been copied for further action.

Sql Server Forum

Ask a Question | Search Questions | Un Answered Questions |

Forums Categories

When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server Management Studio Express, I get the following error:

Reply

Hello sir

When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server
Management Studio Express, I get the following error:

Cannot connect to (SERVER NAME) which both are on the same machine,
Addtional inforation

A network -Related or instance -specific error ocuured while establising a connection to sql server ,the server was not found or not accessible verify that instance name is correcr and that sql server is configured to allow remaote connection.(provider :named pipes provide ,error40-could not open a coonection to sql server)(microsoft SQL sever,error:2)

this error ocure reply how to solve

thanks
sagar

Reply

Interesting?

Responses

Dbdon
Posted on: 11/14/2009 10:15:16 AM

Which version of sql 2005 are you using?

your error suggests that remote connections are not enabled on your server installed. you gotta enable remote connections. this should solve your problem.

Vuyiswamb
Posted on: 11/15/2009 11:28:33 PM

Good Day Sagarp

The this Error occurs only if you have used the wrong server name. i want you to do to the Following

When you try to Connect n the server Dropdown, click on the
"Browse for more" and it will give you a small dialog box. This dialog box has a tab "Local Servers" collapse the "Database Engine" and it will give you the Correct name of your Server. Double click on it and try to connect again.

Thank you for posting at dotnetfunda

Vuyiswa Maseko