Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error: While Connecting SQL Server

Dear Experts,

While i am connecting SQL Server 2005 on client Machine, Following error is occurring :

Connection Failed:

SQL State: '8001'

SQL Server Error:1326

[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [1326].

Connection Failed:

SQL Server Error:0

[Microsoft][SQL Native Client]Login timeout expiered

Connection failed:

SQL State:'08001'

SQL Server Error:1326

Please suggest solutions.

Best Regards

Ashutosh

Former Member
replied

Hi There

There's a few things to check..

Ensure that you have both Named Pipes and tcp/ip configured as transport for your SQL server.

The SQL Native client is also a common cause for remote timeouts (ie it isn't installed on the client PC). Lastly you ned to check that there is no firewall or anti virus scanner preventing your connection from the client to the server

These are the usual gotchas.

Please let us know if you still have issues (and maybe let us know what the specifics are ie versions and what you have already done)

Good Luck

Pete

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question