SQL Server Linux(Ubuntu) Connection Options
0
votes
1
answer
1938
views
In general SQL Server Connection Protocols allows three different connection protocols:
> 1. TCP/IP
> 2. Named Pipes
> 3. Shared Memory
in linux by default installation we can connect to the SQL Server using TCP/IP, the question is **is there any options for named pipes or shared memory or UNIX sockets?**
Also, it seems there is no option to enable or disable such features in Linux.
TCP/IP:
sqlcmd –S tcp:ServerName –U sa –P
Named Pipes:
sqlcmd –S np:\\ServerName\pipe\sql\query –U sa –P
Shared Memory:
sqlcmd –S lpc:ServerName –U sa –P
Asked by Ata Tiba
(3 rep)
May 1, 2020, 11:16 AM
Last activity: May 1, 2020, 11:42 AM
Last activity: May 1, 2020, 11:42 AM