Difference between revisions of "mssql notes"
From thelinuxwiki
(Created page with "==command examples== login vi CLI sqlcmd -S 192.168.1.1 -U sa -P change sa password ALTER LOGIN [sa] WITH PASSWORD=N'abc123' category:database category:mssql") |
|||
| Line 4: | Line 4: | ||
change sa password | change sa password | ||
ALTER LOGIN [sa] WITH PASSWORD=N'abc123' | 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 | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
[[category:database]] | [[category:database]] | ||
[[category:mssql]] | [[category:mssql]] | ||
Revision as of 04:51, 17 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
