Accessing sql server from lan is very slow. RRS feed

  • 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.


    Tariq Iftikhar

    Monday, January 14, 2013 7:11 PM


  • If the same process is running on other machines fine and without problems... dosn't that hint that it is something to do with the machine in question and not the application or database.
    • Marked as answer by Tariq Iftikhar Thursday, January 17, 2013 12:18 PM
    Wednesday, January 16, 2013 9:44 PM

All replies

  • 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.

    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.

    Monday, January 14, 2013 8:28 PM
  • 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

    Monday, January 14, 2013 9:24 PM
  • 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.


    Tariq Iftikhar

    Tuesday, January 15, 2013 9:15 PM
  • 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.
    Tuesday, January 15, 2013 9:51 PM
  • 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.


    Tariq Iftikhar

    Wednesday, January 16, 2013 9:42 PM