Unable to complete login process due to delay in opening server connection

[Former Member]

Hi Experts !!!

In my client machine , when ever i start SAP application , i need to choose the server and enter UID and PWd.

but it is not getting connected to server , and throws error as

• "connection failed :

SQL State : 08001

SQL Server Error : 0

[Microsoft][Sql Native Client]Unable to complete login process due to delay in opening server connection ." *

Any suggestions woould be appreciable

Regards

Krishna Vamsi

[Former Member]

Hello Experts

Any suggestions would be appreciable

regards

Krishna vamsi

[Former Member]

Hi Krishna vamsi,

Check your network connection. The first error message relate to the network itself.

Thanks,

Gordon

[former_member186095]

Hi,

you must set TCP/IP to be enable in the sql server network configuration protocols for server and client. After set it to be enable, you restart the sql server service in the SQL server config manager. After restart, you can login again.

you may also check this thread:

In the thread, there was similar problem with you.

JimM

[Former Member]

Hello Jimmy Michael

I have tried your solution , even i have been to through the link which was provided by you.

I have tried every thing , configuring in SQL Server of Named pipes,tcp/ip and also stopped and started services through

surface area configuration , but still the problem persists.

Regards

Krishna Vamsi

[Former Member]

Hi, I had similar connections problems at a clients site recently, the following helped me resolve the issue:

SAP provided the following solution as a workaround:

SAP Business One client (not installed on the same machine as the

license service) might take several minutes to log you on successfully due to a delay in establishing a connection with the license server.

After logon, SAP Business One functions as expected.

This is due to the fact that the server or PC on which the license server is installed has more than one network card, or there is a dial-up & VPN interface-configured server.

Note: This can happen when you install the license service on a machine with more than one network card ALREADY installed.

Installing additional network cards on a single network card machine with a license service already installed might not produce this issue.

Other terms

SAP Business One, slow, login, log-in, delay, license, server, NIC, VPN, connection.

Reason and Prerequisites

Application error.

Solution

This issue is a candidate to be resolved in a future release.

Until then, you can use one of the following workarounds:

1.Disable additional network cards in the Network Connections. Also make sure there is no dialup interface or VPN interface set up, and restart the server. Note that you can re-enable the additional network card after the restart. This will resolve the issue until the next restart.

2.Install the license server on a machine with a single network card.

3.Disable all network cards, restart the license server and then enable the network cards again.

Disabling one of the network cards sorted it. This may or may not be the same problem you are facing though.

Regards,

Adrian

[Former Member]

Hello Adrian Johnson

Thanks for your prompt reply \

Actually it was showing the error as "Unable to complete login process due to delay in opening server connection"

This was when i try to change server in SAP login window.

WHat i did is , Unistalled the SAP client application fron client system,also unistalled WIndows installer 3.1,sql native client a.

Restarted the client , installed the windows installer 3.1 , sql native client and then installed SAP Client application.

Then i thought it would have worked. But this time i throwned new message as

" named pipes error. " cannot connect to remote connections.

Then i went through the Configuration manager in SQL , in that all the services are running properly also the TCP/IP , Named Pipes have been enabled.

Also I stopped and started the Database engine in Surface area configuration .

Also have checked the in remote connections that " Use both TCP/IP and Named Pipes " is checked.

Again restarted the server and client , still the problem persists. I am unable to track what the problem is

Thanks & Regards

Krishna Vamsi