DEV Community

Discussion on: Microsoft SQL Server Client 2017 on Debian 9

View post
Collapse
 
zeshable profile image
zeshable •

Hello when I run sudo apt install mssql-tools after doing all the steps, I get this:
Reading package lists... Done

Building dependency tree

Reading state information... Done

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:

mssql-tools : Depends: msodbcsql17 (>= 17.3.0.0) but it is not going to be installed

E: Unable to correct problems, you have held broken packages.

Thanks.

Collapse
 
zeshable profile image
zeshable •

Nevermind I got it but now ran into a new problem when running /opt/mssql-tools/bin/sqlcmd, I get the following error:
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..

Collapse
 
nabbisen profile image
nabbisen •

Hi, zeshable. Sorry for my late reply.

Hmm... I have never met the 0x2479 error.

Server is not found or not accessible.
Check if instance name is correct and if SQL Server is configured to allow remote connections.

Your server seems missing from client.
Although I don't know why.., it might be because of network or firewall?