Page tree
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:

Options
Descriptions
-InstanceName

SQL server instance name.

To specifiy 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

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

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).