linux上的sqlserver服务总断,对 Linux 上的 SQL Server 进行故障排除

对 Linux 上的 SQL Server 进行故障排除Troubleshoot SQL Server on Linux

05/01/2018

本文内容

适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) - Linux适用于：Applies to: SQL ServerSQL Server(所有支持的版本)SQL ServerSQL Server (all supported versions) - Linux

本文档介绍如何对 Linux 上或 Docker 容器中运行的 Microsoft SQL Server 进行故障排除。This document describes how to troubleshoot Microsoft SQL Server running on Linux or in a Docker container. 在对 Linux 上的 SQL Server 进行故障排除时，请记得查看 Linux 上的 SQL Server 发行说明中的支持功能和已知限制。When troubleshooting SQL Server on Linux, remember to review the supported features and known limitations in the SQL Server on Linux Release Notes.

提示

For answers to frequently asked questions, see the SQL Server on Linux FAQ.

解决连接失败问题Troubleshoot connection failures

如果在连接到 Linux SQL Server 时存在问题，可以检查以下几点。If you are having difficulty connecting to your Linux SQL Server, there are a few things to check.

如果无法使用 localhost 进行本地连接，请尝试改用 IP 地址 127.0.0.1。If you are unable to connect locally using localhost, try using the IP address 127.0.0.1 instead. Localhost 可能未正确映射到此地址。It is possible that localhost is not properly mapped to this address.

验证是否可从客户端计算机访问服务器名称或 IP 地址。Verify that the server name or IP address is reachable from your client machine.

提示

若要查找 Ubuntu 计算机的 IP 地址，可运行 ifconfig 命令，如以下示例所示：To find the IP address of your Ubuntu machine, you can run the ifconfig command as in the following example:

sudo ifconfig eth0 | grep 'inet addr'

对于 Red Hat，可使用 ip addr，如以下示例所示：For Red Hat, you can use the ip addr as in the following example:

sudo ip addr show eth0 | grep "inet"

但如果是 Azure VM，则此方法不适用。One exception to this technique relates to Azure VMs.

如果适用，请检查是否已在防火墙上打开了 SQL Server 端口(默认为 1433)。If applicable, check that y