# Get-AnalyticsDBConnection
Gets the database string for the specified data store used by the Analytics Service.
Syntax
Get-AnalyticsDBConnection [-AdminAddress <String>] [<CommonParameters>]
Detailed Description
Returns the database connection string from the currently selected Analytics Service instance.
If the returned string is blank, no valid connection string has been specified. In this case the service is running, but is idle and awaiting specification of a valid connection string.
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 |
|---|---|---|---|---|
| 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
System.String
The database connection string configured for the current Analytics Service instance.## Notes
If the command fails, the following errors can be returned.
Error Codes
-----------
NoDBConnections
The database connection string for the Analytics Service has not been specified.
PermissionDenied
You do not have permission to execute this command.
AuthorizationError
There was a problem communicating with the Citrix Delegated Administration Service.
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>Get-AnalyticsDBConnection Server=serverName\SQLEXPRESS;Initial Catalog = databaseName; Integrated Security = True
Description
-----------
Get the database connection string for the Analytics Service.