Accessing sql server from lan is very slow.

Question

Hello All,

running my app. from lan is very slow and hitting error 'unable to complete login process due to delay in opening server connection.' and opens login window.

Regards.

Tariq Iftikhar

Answer 1

Whats the bandwidth of your lan?

Are you able to login locally without an issue?

Also try to get in touch with  network team, for the lan issue.

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

I would start by doing some diagnostics on the connection you have to the backend.

1. Have you tryed connecting locally to the database

2. Have you tried conecting to the database from remote using another application

Answer 3

Hello,

Bandwidth of my wireless lan is 150 mbps. copying files from lan does not take much time. copies normally 1GB or 2GB files.

only takes much time to access sql server. locally my app. starts normally.

Regards.

Tariq Iftikhar

Answer 4

Try a connection using a default ODBC Conection, and use the test connection button. If that connects fine, then there is something with the application that is delaying the connection.

Answer 5

Hi Glenn,

As you said i tested. i ran a batch file to create view using sqlcmd.exe but could not create view and hitting error:

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

this is happening only on a particular computer. my app. is running on other lan computers normally.

Regards.

Tariq Iftikhar