Difference between revisions of "mssql notes"
From thelinuxwiki
Line 31: | Line 31: | ||
users | users | ||
− | + | ==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-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] | ||
[[category:database]] | [[category:database]] | ||
[[category:mssql]] | [[category:mssql]] |
Revision as of 12:35, 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