L
L
lu1ssuarez2019-04-09 15:33:24
Visual Basic
lu1ssuarez, 2019-04-09 15:33:24

Why can it take a long time to create a connection to MS SQL server on a certain computer?

There is a working computer. On it I make connections to MS SQL Server via SSMS and/or VBA. In any case, the first connection time is ~10 seconds. For colleagues, when running the same code, it takes ~ 0.2 seconds to create a connection, and so on all machines. I see a problem in the system, but I'm not sure.
Who faced similar, tell me, please, how to speed up the time of the first connection?
Line of VBA code that runs for 10 seconds:
connDB.Open sConnString
upd.
The problem was solved by changing the ip-address to the domain name of the server.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2019-04-09
@tsklab

Authentication in SQL Server .

N
NewDevLab, 2019-04-09
@NewDevLab

Specifically, this computer resolves the Sql server for a long time. for different reasons.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question