-
-
-
Set-AnalyticsDBConnection
-
-
-
-
-
-
-
-
-
-
-
-
-
This content has been machine translated dynamically.
Dieser Inhalt ist eine maschinelle Übersetzung, die dynamisch erstellt wurde. (Haftungsausschluss)
Cet article a été traduit automatiquement de manière dynamique. (Clause de non responsabilité)
Este artículo lo ha traducido una máquina de forma dinámica. (Aviso legal)
此内容已经过机器动态翻译。 放弃
このコンテンツは動的に機械翻訳されています。免責事項
이 콘텐츠는 동적으로 기계 번역되었습니다. 책임 부인
Este texto foi traduzido automaticamente. (Aviso legal)
Questo contenuto è stato tradotto dinamicamente con traduzione automatica.(Esclusione di responsabilità))
This article has been machine translated.
Dieser Artikel wurde maschinell übersetzt. (Haftungsausschluss)
Ce article a été traduit automatiquement. (Clause de non responsabilité)
Este artículo ha sido traducido automáticamente. (Aviso legal)
この記事は機械翻訳されています.免責事項
이 기사는 기계 번역되었습니다.책임 부인
Este artigo foi traduzido automaticamente.(Aviso legal)
这篇文章已经过机器翻译.放弃
Questo articolo è stato tradotto automaticamente.(Esclusione di responsabilità))
Translation failed!
Set-Analyticsdbconnection
Configures a database connection for the Analytics Service.
Syntax
Set-AnalyticsDBConnection [-DBConnection] <String> [-Force] [-LoggingId <Guid>] [-BearerToken <String>] [-TraceParent <String>] [-TraceState <String>] [-VirtualSiteId <String>] [-AdminAddress <String>] [<CommonParameters>]
Detailed Description
Specifies the database connection string for use by the currently selected Citrix Analytics Service instance.
The service records the connection string and attempts to contact the specified database. If the database cannot initially be contacted the service retries the connection at intervals until contact with the database is successfully established.
Is is not possible to set a new database connection string for the service if one is already recorded. The connection string must first be set to $null. This action causes the service to reset and return to its idle state, at which point a new connection string can be set.
When a database connection string is successfully set for the service, a status of OK is returned by the cmdlet. If the database connection string is set to $null, a DBUnconfigured status is returned.
A syntactically invalid connection string is not recorded.
Only use of Windows authentication within the connection string is supported; a connection string containing SQL authentication credentials is always rejected as invalid.
The current service instance is that on the local machine, or that explicitly specified by the last usage of the -AdminAddress parameter to a Analytics SDK cmdlet.
Related Commands
Parameters
Name | Description | Required? | Pipeline Input | Default Value |
---|---|---|---|---|
DBConnection | Specifies the database connection string to be used by the Analytics Service. Passing in $null will clear any existing database connection configured. | true | false | |
Force | If present, allows the local administrator to set the connection string to null when there are problems contacting the database or other services. | false | false | false |
LoggingId | Specifies the identifier of the high-level operation this cmdlet call forms a part of. Citrix Studio and Director typically create high-level operations. PowerShell scripts can also wrap a series of cmdlet calls in a high-level operation by way of the Start-LogHighLevelOperation and Stop-LogHighLevelOperation cmdlets. | false | false | |
BearerToken | Specifies the bearer token assigned to the calling user | false | false | |
TraceParent | Specifies the trace parent assigned for internal diagnostic tracing use | false | false | |
TraceState | Specifies the trace state assigned for internal diagnostic tracing use | false | false | |
VirtualSiteId | Specifies the virtual site the PowerShell snap-in will connect to. | false | false | |
AdminAddress | Specifies the address of a XenDesktop controller the PowerShell snap-in will connect to. You can provide this as a host name or an IP address. | false | false | Localhost. Once a value is provided by any cmdlet, this value becomes the default. |
Input Type
None
You cannot pipe input into this cmdlet.
Return Values
Citrix.Fma.Sdk.Utilities.Service.Servicestatusinfo
The Set-AnalyticsDBConnection cmdlet returns an object describing the status of the Analytics Service together with extra diagnostics information. Possible values are:
– OK:
The Analytics Service instance is configured with a valid database and service schema. The service is operational.
– DBUnconfigured:
No database connection string is set for the Analytics Service instance.
– DBRejectedConnection:
The database rejected the logon attempt from the Analytics Service. This may be because the service attempted to log on with invalid credentials or because a database has not been installed in the specified location.
– InvalidDBConfigured:
The specified database does not exist, is not visible to the Analytics Service instance, or the service’s schema within the database is invalid.
– DBNotFound:
The specified database could not be located with the configured connection string.
– DBNewerVersionThanService:
The version of the Analytics Service currently in use is newer than, and incompatible with, the version of the Analytics Service schema on the database. Upgrade the Analytics Service to a more recent version.
– DBOlderVersionThanService:
The version of the Analytics Service schema on the database is newer than, and incompatible with, the version of the Analytics Service currently in use. Upgrade the database schema to a more recent version.
– DBVersionChangeInProgress:
A database schema upgrade is in progress.
– PendingFailure:
Connectivity between the Analytics Service instance and the database has been lost. This may be a transitory network error, but may indicate a loss of connectivity that requires administrator intervention.
– Failed:
Connectivity between the Analytics Service instance and the database has been lost for an extended period of time, or has failed due to a configuration problem. The service instance cannot operate while its connection to the database is unavailable.
– Unknown:
The status of the Analytics Service cannot be determined.
Notes
If the command fails, the following errors can be returned.
Error Codes
———–
InvalidDBConnectionString
The database connection string has an invalid format.
DatabaseConnectionDetailsAlreadyConfigured
There was already a database connection configured. After a configuration is set, it can only be set to $null.
PermissionDenied
You do not have permission to execute this command.
AuthorizationError
There was a problem communicating with the Citrix Delegated Administration Service.
ConfigurationLoggingError
The operation could not be performed because of a configuration logging error.
CommunicationError
There was a problem communicating with the remote service.
ExceptionThrown
An unexpected error occurred. For more details, see the Windows event logs on the controller or the XenDesktop logs.
Examples
Example 1
C:\PS>Set-AnalyticsDBConnection "Server=dbserver\SQLEXPRESS;Database=XDDB;Trusted_Connection=True"
Description
Configures the service instance to use a database called XDDB on an SQL Server Express database running on the machine called dbserver. Integrated Windows authentication is required.
Example 2
C:\PS>Set-AnalyticsDBConnection -DBConnection $null
Description
Resets the service instance’s database connection string. The service instance resets and returns to an idle state until a valid new database connection string is specified.
Example 3
c:\PS>Set-AnalyticsDBConnection -DBConnection "Server=serverName\SQLEXPRESS;Initial Catalog = databaseName; Integrated Security = True"
OK
Description
Configures a database connection string for the Analytics Service.
Example 4
c:\PS>Set-AnalyticsDBConnection -DBConnection "Invalid Connection String"
Invalid database connection string format.
Description
Configures an invalid database connection string for the Analytics Service.
In this article
This Preview product documentation is Citrix Confidential.
You agree to hold this documentation confidential pursuant to the terms of your Citrix Beta/Tech Preview Agreement.
The development, release and timing of any features or functionality described in the Preview documentation remains at our sole discretion and are subject to change without notice or consultation.
The documentation is for informational purposes only and is not a commitment, promise or legal obligation to deliver any material, code or functionality and should not be relied upon in making Citrix product purchase decisions.
If you do not agree, select I DO NOT AGREE to exit.