error plz help

when i run my application using web parts on sql 2000 an error displayed (

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) can any one tell me why that error

)

Hi,

Please try this article on support.microsoft.com.

Article ID is 926929.

OR.

Make sure that the SQL Browser Service is started and make sure the password is correct, Because in my case customer had changed his passwords and we made sure that he changes his passwords from SSCM rather than
Services and then he was able to connect with no problems.

If you have any further issues please let me know on my e-mail ID.

Subject sould be Error code.

Thanks and Best Regards.

Farhat Nishat.

|||

i am sure that the SQL Browser Service is started and the password is correct i think that there steps done before running the web parts

because i think that web parts runs only on sql 2005 so do you know what to do to run web parts on sql2000 ?plz reply

|||

Can you check this blog? http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

If you still have problem, please copy/paste your connection string here?

Error on (local)

An error occurred in the system, and last operation may not have completed:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

The above error I get when I like to connect to a db for a wiki. It's on localhost and everything I found on the internet I tried. Remote connections are not relevant because it's local. Have I something forgotten?? SQL Server 2005, Asp.net 2.0

RoelAlblas:

Remote connections are not relevant because it's local. Have I something forgotten?? SQL Server 2005, Asp.net 2.0

Even on local, sometimes your website will use still use remote connection to connect to local SQL Server (for example websites deployed under IIS), so please do make sure you have enabled remote connection for the SQL instance.

Error occurred while establishing a connection to the server

hai friends..........

please give a solution to this error............

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "

thanks in advance to all.......

Can u post your connection string ? Are you using express edition?

|||

hai...

No i am not using express edition..............

The connection string is --> "Data Source=p3swhsql-v11.shr.phx3.secureserver.net; Initial Catalog=Magichuts; User ID=Magichuts; Password=Google001"

|||

Chek this link

http://support.microsoft.com/kb/914277

|||

this link will help you

http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/

|||thanks abdul.m..................

Error occured while establishing connection with sql server

I am new learner of ASP.NET and SQL server.So there might be any mistake in writing code.

When I tried to run my project I got following error.I am uisng SQL 2005 server.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

connection string used is

<addname ="ConnectionString"connectionString="Data Source=BLUESTAR\\SQLEXPRESS;Initial Catalog=KnowledgeAssetManagement;Integrated Security=True"/>

I have also tried by setting local & remote connection options from the SQL server surface Area Configuration and connections option from server properties of sql server management studio.

Please help me ,my work get stucked due this problem.

Hi Bluestar123

In your connection string you do not need to have to forward slashes after bluestar see connection string below

<add name ="ConnectionString" connectionString="Data Source=BLUESTAR\SQLEXPRESS;Initial Catalog=KnowledgeAssetManagement;Integrated Security=True"/>

Hope this helps

Regards

ScottyB

|||

Hi ScottyB,

Actually I have given only one slash after bluestar in connection string but it gives me error 'Unrecognized Escape Sequence' so after searching on google I have given that double slashes which removes that error.

Thanks for your reply ,

can you suggest any other solution?