Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
SQL Safe provides you with CLI commands to help you manually install SQL Server extended stored procedures (XSP) for SQLsafe.


To perform the installation use the following command:
  •   SQLsafeCmd InstallXsp [options]

Common Options

The following options help you perform the installation:

The remote server that hosts the SQL Server instance(s) where the extended stored procedures should be installed (or uninstalled)
Options
Descriptions
-InstanceName

SQL server Server instance name.

To specifiy specify all instances, use an asterisk (*) for the instance name.

Note: it is not required if the instance is set as a default on the target server.

-Server

.

Security Options

Secure your installation with the following options:

Options
Description
-NoPrompt  Never prompt for credentials even if necessary.
-SecurityModel <model>

The security model used to log into SQL Server.

<model> - {Integrated, SQL}.

Note: Integrated (Windows authentication) is the default.

-SqlUsername <username><username> - the SQL Server username. (SQL SecurityModel).
-SqlPassword <pwd><pwd> - the SQL Server password. (SQL SecurityModel).
-EncryptedSqlPassword <pwd><pwd> - the encrypted SQL Server password generated by EncryptSqlPassword action. (SQLSecurityModel).
-WindowsUsername

The Windows user that will be used during the installation process.

-WindowsPassword <pwd><pwd> - the password for the Windows user.
-EncryptedWindowsPassword <pwd><pwd> - the encrypted password for the Windows user generated by EncryptWindowsPassword action. 

Advanced Options

The following advanced options help you perform your installation:

Options
Description
-ArgsFile <filename>

The path to a file containing command-line arguments.

<filename> - specifies the file that contains the command line arguments.

-Remove

Remove all SQLsafe extended stored procedures from the specified instance(s).

For detailed descriptions and available options, see the CLI Help (SQLsafeCmd help InstallXsp).

...