L
L
Larry_Flint2020-09-22 15:58:06
Windows
Larry_Flint, 2020-09-22 15:58:06

Strange Windows 10 behavior?

There is a Perl script, which, after being processed by perl2exe, is placed on a network drive. The task of the script is to take the text file that lies next to it and send the results of its processing to the SQL server. Until recently, everything worked great in this form, but after I installed SQLServer2014SP3-KB4022619-x64-RUS on SQL 2014, errors began. On Windows 10, the script works normally only if it is located on the computer itself. When I run it from a network drive, I get an error:

X:\v>extraction_v2_x64.exe
DBI connect('Driver={SQL Server};Server=keeper;Database=Dbase;UID=rw_user;PWD=Passw0rd','',...) failed: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server не существует, или доступ запрещен. (SQL-08001) [state was 08001 now 01000]                                                                                                                                         [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000) at X:\v\extraction_v2_x64.exe line 34.
                                                                                                                                                                                                                                                                                                                                                                                                                          CONNECT ERROR: 
                                                                                                                                                                                                                                                                                                        [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server не существует, или доступ запрещен. (SQL-08001) [state was 08001 now 01000]                                                       
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). (SQL-01000) at X:\v\extraction_v2_x64.exe line 34.

this error is related to security (tls 1.0 was banned), but then it is not clear why it works locally. the situation is repeated on other computers with Windows 10, but on Winows 7 and servers this does not happen.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Artem @Jump, 2020-09-22
curated by the

when I run it from a network drive I get an error
Logically.
Launching an application from a network resource is not safe, either run it locally, or add the resource to trusted ones, or sign it.

K
Konstantin Tsvetkov, 2020-09-22
@tsklab

state+was+08001+now+01000

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question