The driver is working however as I can connect to a different server with no instance name: sqlcmd -S SERVERNAME -U User -P pwd -d DatabaseName -Q "SELECT TOP 5 Id FROM dbo.MyTable " Sqlcmd -S SERVERNAME\\INSTANCENAME -U User -P pwd -d DatabaseName -Q "SELECT TOP 5 Id FROM dbo.MyTable " sqlcmd -S "SERVERNAME\\INSTANCENAME" -U User -P pwd -d DatabaseName -Q "SELECT TOP 5 Id FROM dbo.MyTable " I have also tried escaping the backslash with the same error (and with single and double quotes). For more information see SQL Server Books Online. Check if instance name is correct and if SQL Server is configured to allow remote connections. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : MAX_PROVS: Error Locating Server/Instance Specified. The error implies the server cannot be found: Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired. However none of them work on Linux - they all return the error message below. Sqlcmd -S SERVERNAME\INSTANCENAME -U User -P pwd -d DatabaseName -Q "SELECT TOP 5 Id FROM dbo.MyTable " The following both work fine from a Windows machine: sqlcmd -S "SERVERNAME\INSTANCENAME" -U User -P pwd -d DatabaseName -Q "SELECT TOP 5 Id FROM dbo.MyTable " I am now trying to test a database connection, that includes both the server name and an instance name.
I have set up the Microsoft ODBC Driver 13 for SQL Server on an Ubuntu 16.04 machine.
0 kommentar(er)
