问题[mssql](ubuntu)

当我按照以下链接中的步骤在 ubuntu 上安装 ms-SQL-serve 时遇到问题：

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15

我在步骤 2 中遇到以下错误：

Traceback (most recent call last):
  File "/usr/bin/add-apt-repository", line 330, in <module>
    addaptrepo = AddAptRepository()
  File "/usr/bin/add-apt-repository", line 35, in __init__
    self.distro.get_sources(self.sourceslist)
  File "/usr/lib/python3/dist-packages/aptsources/distro.py", line 91, in get_sources
    raise NoDistroTemplateException(
aptsources.distro.NoDistroTemplateException: Error: could not find a distribution template for Ubuntu/groovy

任何解决方案

我有一个 16.04 版本的 Ubuntu。我最近在系统中安装了 MSSQL 服务器。版本是 SQL express 2019。安装过程中一切正常。我按照此链接中的说明进行操作： https ://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver15

我在 opt 文件夹中有 4gb 内存和高清空间（12gb）我看到了 MSSQL 文件夹和 MSSQL-TOOLS 文件夹，其中我有工具 mssql-scmd

当我检查状态似乎没问题：

 mssql-server.service - Microsoft SQL Server Database Engine
   Loaded: loaded (/lib/systemd/system/mssql-server.service; enabled; vendor pre
   Active: active (running) since Sun 2020-10-11 20:23:32 BST; 1h 39min ago
     Docs: https://docs.microsoft.com/en-us/sql/linux
 Main PID: 998 (sqlservr)
   CGroup: /system.slice/mssql-server.service
           ├─ 998 /opt/mssql/bin/sqlservr
           └─2485 /opt/mssql/bin/sqlservr

我尝试使用此命令行按照说明进行访问

sqlcmd -S localhost -U SA -P '<YourPassword>'

（我设置了我的密码并点击返回）

不幸的是，我得到了：

Sqlcmd：错误：Microsoft ODBC Driver 17 for SQL Server：用户“SA”登录失败..

如果这是问题任何想法如何解决它？不确定我是否可以轻松找到该驱动程序？

提前感谢保罗

在执行时遵循本教程

sudo apt-get install -y mssql-server

我在输出中得到下一个错误：

The following packages have unmet dependencies:
 mssql-server : Depends: libjemalloc1 but it is not installable
                Depends: libssl1.0.0 but it is not installable

我应该怎么办？

我根据Microsoft 文档安装了 sqlserver 。以下命令正确执行。

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

sudo apt-get update
sudo apt-get install -y mssql-server

sudo /opt/mssql/bin/mssql-conf setup

systemctl status mssql-server

但是当我尝试安装 SQL Server 命令行工具时，出现以下错误。

sudo apt-get install mssql-tools unixodbc-dev


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
           Depends: msodbcsql17 (< 17.4.0.0) but it is not going to be 
  installed
 E: Unable to correct problems, you have held broken packages.

我的操作系统是 Linux Ubuntu 18.04.1 LTS

我已经在我的 ubuntu 机器上安装了 Microsoft SQL-Server。现在它工作正常，但每次我关闭机器时，关机都会停止

A stop job is running for microsoft sql server database engine ( x/30min )

现在，如果您等待 30 分钟，它就会关闭，所以从技术上讲，这不是错误。但是，当我必须关闭笔记本电脑时，我没有时间等待 30 分钟……而且，我有时必须重新启动机器，并且不想等待 30 分钟才能重新启动它……

有什么方法可以阻止或禁用此停止作业？停止作业在哪里配置？

我刚刚在我的 Ubuntu 18.10 机器上安装了适用于 linux 的 MSSQL 2017 和适用于 linux 的 Visual Studio 代码。两个安装都成功了，但我无法从 Visual Studio 连接到数据库。

我有以下正在运行的驱动程序：

$ odbcinst -j

    unixODBC 2.3.7
    DRIVERS............: /etc/odbcinst.ini
    SYSTEM DATA SOURCES: /etc/odbc.ini
    FILE DATA SOURCES..: /etc/ODBCDataSources
    USER DATA SOURCES..: /home/neo4j/.odbc.ini
    SQLULEN Size.......: 8
    SQLLEN Size........: 8
    SQLSETPOSIROW Size.: 8

但是，当我尝试安装

$ sudo apt-get install mssql-tools unixodbc-dev

我收到以下错误：

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
               Depends: msodbcsql17 (< 17.4.0.0) but it is not going to be installed
 unixodbc-dev : Depends: unixodbc (= 2.3.7)
E: Unable to correct problems, you have held broken packages.

经过大量谷歌搜索，我发现了很多建议，但它们没有运行，比如尝试删除 msodbcsql 和 unixodbc

$ sudo apt-get remove msodbcsql

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package 'msodbcsql' is not installed, so not removed
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.

在这一点上，我被锁定，无法继续。

有没有人正在运行的解决方案？

我正在尝试在 Ubuntu 18.10 上安装 SQL Server 2017 并遇到 libjemalloc1 不可用的错误。我看到另一个答案说 libjemalloc1 应该在 18.04 的宇宙中，但它看起来不像 ubuntu 宇宙中的 18.10 可用。有解决方案吗？有没有人做过任何事情来让它工作？

如何在 ubuntu 的 ui 上查看数据库 MSSQL 服务器数据库是他们可用的任何软件。我正在使用 ubuntu 16.04

我可以在 Ubuntu 16.04 上安装 SQL Server Management Studio 吗？

我无法运行sqlcmd命令
我的操作系统（18.04）是

$ uname -a Linux Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23 18:02:16 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

$ sqlcmd -S localhost -U SA -P 'password'
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..