Set-QLRSqlSrvAgent
From PowerGUI Wiki
Installs, Uninstalls or Repairs server components.
Contents |
Syntax
Set-QLRSqlSrvAgent [-Install] [-ServerName] <String> [[-LoginMode] [<AuthMode>]] [[-Login] [<String>]] [[-Password] [<String>]] [-Credential [<PSCredential>]] [-ConfigFile [<String>]] [<CommonParameters>]
Set-QLRSqlSrvAgent [-Uninstall] [-ServerName] <String> [[-LoginMode] [<AuthMode>]] [[-Login] [<String>]] [[-Password] [<String>]] [-Credential [<PSCredential>]] [-ConfigFile [<String>]] [<CommonParameters>]
Set-QLRSqlSrvAgent [-Repair] [-ServerName] <String> [[-LoginMode] [<AuthMode>]] [[-Login] [<String>]] [[-Password] [<String>]] [-Credential [<PSCredential>]] [-ConfigFile [<String>]] [<CommonParameters>]
Detailed Description
The Set-QLRSqlSrvAgent cmdlet installs, uninstalls or repairs Log Reader server components on a remote SQL Server instance.
Related Commands
Parameters
| Name | Description | Required? | Pipeline Input | Default Value |
|---|---|---|---|---|
| Install | Set this parameter to install server components. | true | false | |
| ServerName | The SQL Server instance name. | true | false | |
| LoginMode | Connection mode. It should be one of:
Windows - will be used windows authentification mode SQLServer - will be used sql server authentification mode Predefined - connection mode should be read from configuration file | false | false | |
| Login | The login name to connect to the SQL Server. If LoginMode is set to "Windows" or "Predefined", this parameter is ignored. | false | false | |
| Password | The password to connect to the SQL Server. If LoginMode is set to "Windows" or "Predefined", this parameter is ignored. | false | false | |
| Credential | The operating system credentials that will be used on the remote machine to run the installation process. If this parameter not set, the installation will run under the SQL Server service startup account. | false | true (ByValue) | |
| ConfigFile | The configuration file name. The default configuration file is located at <%LocalAppData%>\Quest Software\Log Reader for SQL Server\QuestLogReader.config. You can use another configuration file.
If LoginMode is set to "Windows" or "SQLServer", this parameter is ignored. | false | false | |
| Uninstall | Set this parameter to uninstall server components. | true | false | |
| Repair | Set this parameter to upgrade or repair server components. | true | false |
Return Values
Quest.LogReader.SqlServer.Wrappers.AgentWrapper
Examples
EXAMPLE 1
Set-QLRSqlSrvAgent -Install . Windows
This command installs server components on the local SQL Server instance.
EXAMPLE 2
Get-Credential | Set-QLRSqlSrvAgent -Install . Windows
This command installs server components on the local SQL Server using the specified credentials.
