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
