Difference between revisions of "mssql notes"

From thelinuxwiki
Jump to: navigation, search
(links)
Line 33: Line 33:
 
==links==
 
==links==
 
[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-troubleshooting-guide?view=sql-server-ver15 Troubleshoot SQL Server on Linux]
 
[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-troubleshooting-guide?view=sql-server-ver15 Troubleshoot SQL Server on Linux]
 +
 
[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent?view=sql-server-ver15 Install SQL Server Agent on Linux] - agent runs scheduled jobs
 
[https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-sql-agent?view=sql-server-ver15 Install SQL Server Agent on Linux] - agent runs scheduled jobs
 +
 
[https://support.microsoft.com/en-us/help/965049/how-to-set-up-a-microsoft-sql-server-odbc-data-source How To Set up a Microsoft SQL Server ODBC Data Source]
 
[https://support.microsoft.com/en-us/help/965049/how-to-set-up-a-microsoft-sql-server-odbc-data-source How To Set up a Microsoft SQL Server ODBC Data Source]
  

Revision as of 12:49, 22 August 2020

command examples

login vi CLI

sqlcmd -S 192.168.1.1 -U sa -P

change sa password

ALTER LOGIN [sa] WITH PASSWORD=N'abc123'

logs

/var/opt/mssql/log/

config file

/var/opt/mssql/mssql.conf

config utility

/opt/mssql/bin/mssql-conf --help
usage: mssql-conf [-h] [-n]  ...
positional arguments:
 
   setup             Initialize and setup Microsoft SQL Server
   set               Set the value of a setting
   unset             Unset the value of a setting
   list              List the supported settings
   get               Gets the value of all settings in a section or of an
                     individual setting
   traceflag         Enable/disable one or more traceflags
   set-sa-password   Set the system administrator (SA) password
   set-collation     Set the collation of system databases
   validate          Validate the configuration file
   set-edition       Set the edition of the SQL Server instance
   validate-ad-config
                     Validate configuration for Active Directory
                     Authentication
   setup-ad-keytab   Create a keytab for SQL Server to use to authenticate AD
                     users

links

Troubleshoot SQL Server on Linux

Install SQL Server Agent on Linux - agent runs scheduled jobs

How To Set up a Microsoft SQL Server ODBC Data Source