Jump to content
Welcome to our new Citrix community!
  • 0

XA6.5 Will it work to rename a SQL server name to a SQL instance name?


Jason Fortun

Question

I have a situation where we are having to change a clustered SQL instance to a standalone server. For some technical reason the SQL team will not be able to keep SQL server host name the same and will also break the instance.  The XA6.5 farm servers reference the SQL instance name in the DSN to access SQL.  What the SQL team wants to do is to rename the SQL server host name to the SQL instance name.  Hopefully the below helps explain things (actual names changes to protect the innocent):

 

Current SQL server host name:SQLSERVERNAME1

Current SQL instance name: SQLINSTANCENAME1

XA6.5 DSN currently using:SQLINSTANCENAME1

New proposed SQL server host name:SQLINSTANCENAME1

 

Here is an example mf20.dsn file from this environment:

 

[ODBC]
DRIVER=SQL Server
DATABASE=Citrix_db
APP=Citrix IMA
UID=sqlsvc01
SERVER=SQLINSTANCENAME1
Trusted_Connection=Yes

 

My gut tells me that so long as the name SQLINSTANCENAME1 is still attached the to SQL server (though now as a host name and not an SQL instance name) this should work fine with no changes required on the Citrix servers, but I want to validate that.

Link to comment

1 answer to this question

Recommended Posts

  • 0

After updating the DSN file on the XenApp servers, you stop the IMAservice and run the 'dsmaint config' command to configure the credentials used for the new database.

 

In the DSN file, the Server entry would be ServerName/DBName.  You might take one server and use the ODBC wizard to create a new DB connection and then copy the DSN file that is created over to the other servers.

 

Here is a snippet from the PowerShell script I created to do this (substitute  DOMAIN and user name as is appropriate for your environment) I pass the $DBUser and $DBPass variables into the command.   My complete script  queries the farm for a list of servers (You could use get-content to use a text file instead), copies the DSN from a file share, stops the IMA Service, executes the command below and then restarts the IMAservice.

$DsmaintResult = Invoke-Command {&"C:\Program Files (x86)\Citrix\system32\Citrix\Ima\dsmaint.exe" config /user:DOMAIN\ctx65db /pwd: /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn"} -Computername $Server -ArgumentList $DBUser, $DBPass

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...