on 01-07-2010 2:40 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ashutosh T,
Check your system has SQL native client. If it is not installed in your machine, Please install SQL native client. Native client is Communication Bridge between SAP and server.
SQL State: '8001'
SQL Server Error:1326
MicrosoftSQL Native ClientNamed Pipes Provider: Could not open a connection to SQL Server 1326.
It means clent unable to establish connection to the server.
Check have you enabled both TCP/IP in your SQL Server and SQL Client?
If you are enabling TCP/IP service, you problem will solve.
To Enable TCP/IP settings in sql server 2005
http://support.microsoft.com/kb/914277
Increase your sql server connection login session period and check it now.
Regards,
Senthil Maruthappan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.