When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server ...

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

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

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Reply

Alert Moderator

Found interesting? Add this to:

| More

Responses

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

Level: Starter | Status: [Member] | Reply

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.

Sagarp, please login to Mark As Answer, if this helps | Alert Moderator

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

Level: NotApplicable | Status: [Member] [Administrator] | Reply

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

Sagarp, please login to Mark As Answer, if this helps | Alert Moderator

Latest Posts

Bookmark page in asp.net (0) New
Is it Possible to Use Same RPT CrystalReport File in different Report generating aspx page in DOTNET (0) New
How to ceate database architecture from the user module i am provided.What should be the approach!! (2) New
javascript not working (3) New
Please suggest Open source software for Hospital Information system (0) New
How to Colour gridView field (1) New
SQl server Connection of VB in Windows 98 OS (1) New
basic datetime picker date difference or subtract (5) New

More ...

Sql Server Forum

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

Responses

Latest Posts