If you setup the SQL Express edition and need to move it for production. This is how.
Open PowerShell as and Administrator:
Add-PSSnapin Citrix*
Get-LogDataStore
Get-MonitorDataStore
They BOTH output something like this:
ConnectionString : Server=XDC-PROD01\SQLEXPRESS;Initial Catalog=CTX-XD7-PROD;Integrated Security=True
DataStore : Site
DatabaseType : SqlServer
Provider : MSSQL
SchemaName : Monitor
Status : OK
ConnectionString : Server=XDC-PROD01\SQLEXPRESS;Initial Catalog=CTX-XD7-PROD;Integrated Security=True
DataStore : Monitor
DatabaseType : SqlServer
Provider : MSSQL
SchemaName : MonitorData
Status : OK
Copy the contents of the BOLD above to a string and change the server name and instance details with server= in the prefix.
$CS = “server=REMOTE-PROD01\SQL02;Initial Catalog=CTX-XD7-PROD;Integrated Security=True”
- Set-LogSite -State Disabled
- Set-LogDBConnection -DataStore Logging -DBConnection $null
- Set-MonitorDBConnection -DataStore Monitor -DBConnection $null
- Set-MonitorDBConnection -DBConnection $null
- Set-AcctDBConnection -DBConnection $null
- Set-ProvDBConnection -DBConnection $null
- Set-BrokerDBConnection -DBConnection $null
- Set-EnvTestDBConnection -DBConnection $null
- Set-SfDBConnection -DBConnection $null
- Set-HypDBConnection -DBConnection $null
- Set-ConfigDBConnection -DBConnection $null –force
- Set-LogDBConnection -DBConnection $null –force
- Set-AdminDBConnection -DBConnection $null –force
Move the database between the servers.
On the SQL server create the account(s)
sqlcmd -S env3-sql2\AON -q "create login [domainName\ddcName$] from windows"
set-ConfigDBconnection -dbconnection $cs
set-AdminDBconnection -dbconnection $cs
set-LogDBconnection -dbconnection $cs
set-AcctDBconnection -dbconnection $cs
set-BrokerDBconnection -dbconnection $cs
set-EnvTestDBconnection -dbconnection $cs
set-HypDBconnection -dbconnection $cs
set-MonitorDBconnection -dbconnection $cs
set-ProvDBconnection -dbconnection $cs
set-SfDBconnection -dbconnection $cs
set-LogDbConnection -DataStore logging -DbConnection $cs
set-MonitorDbConnection -DataStore monitor -DbConnection $cs
set-LogSite -State Enabled