Microsoft odbc driver 17 for sql server ошибка
Обновлено: 01.05.2024
Как только я пробую сделать подключение через ODBC Control Panel\Administrative tools\Data sources получаю следующую ошибку :
Подключение не выполнено:
SQLState: '01000'
Ошибка SQL-сервер: 2
[Microsoft][ODBC SQL Server Driver][Shared memory] ConnectionOpen (Connect()).
Подключение не выполнено
SQLState:'08001'
Ошибка SQL-сервер: 17
[Microsoft][ODBC SQL Server Driver][Shared memory] SQL-сервер не существует или отсутствует.
Пытаюсь подключиться к серверу из delphi через ADO тоже получаю ошибку о том что не может найти сервер.
Подключаться пытаюсь естественно к своей локальной машине на которой он стоит.
Протокол соединения TCP/IP стоит. если я правильно понимаю о чем вы спросили.
ODBC Driver 17.5, ос Centos 7
Периодически выскакивает ошибка:
MS Sql connect error: SQLSTATE: HYT00; code: 0; message: [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
SQLSTATE: 08001; code: 258; message: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x102
SQLSTATE: 08001; code: 258; message: [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2746.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired
I have installed SQL Server 2019 on Linux platform and had done all the necessary steps and I was able to login to SQL Server via sqlcmd some time ago but suddenly I have started seeing below error when connecting to SQL Server via sqlcmd. i have verified for port as well and its open. please help me to fix this issue.
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi Seeya,
Sorry for delayed response, i had already tried using 127.0.0.1 but it did not help. SQL Server is also up and running.
PFB snap and let me know if i need to check anything else.
]$ sqlcmd -S127.0.0.1 -Usa -PXXXXX
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2749.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Ответы
Avis de non-responsabilité:
Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.
Bien cordialement, Andrei .
MCP
- Помечено в качестве ответа Иван Проданов Microsoft contingent staff, Moderator 19 августа 2019 г. 8:52
Все ответы
Avis de non-responsabilité:
Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.
Bien cordialement, Andrei .
MCP
Есть совет поставить предыдущую версию:
libodbcinst.la
libodbcinst.so -> libodbcinst.so.2.0.0
libodbcinst.so.1 -> libodbcinst.so.2.0.0
libodbcinst.so.2 -> libodbcinst.so.2.0.0
libodbcinst.so.2.0.0
libodbc.la
libodbc.so -> libodbc.so.2.0.0
libodbc.so.1 -> libodbc.so.2
libodbc.so.2 -> libodbc.so.2.0.0
libodbc.so.2.0.0
[mssql]
Description=FreeTDS
Driver=FreeTDS
Servername=mssql
UID=sa
PWD=pppp
Port=1433
[MySQL]
Description=MySQL driver for Plesk
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc5w-plesk.so
Setup=
FileUsage=1
Driver64=
Setup64=
UsageCount=1
[FreeTDS]
Description=TDS driver (Sybase/MS SQL)
Driver=/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup=
CPTimeout=
CPReuse=
[ODBC Driver 13 for SQL Server]
Description=Microsoft ODBC Driver 13 for SQL Server
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2
UsageCount=1
[ODBC Driver 17 for SQL Server]
Server = tcp:81.169.186.154,1433
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.1.1
UsageCount=1
Читайте также: