Такая ситуация. Установлен и настроен Citrix PS 4.0. Его ставили до меня. Под каким логином он лезет в MSSQL-сервер можно на самом SQL глянуть. А как базу цитрикса перенести на другой SQL-сервер и задать ему другого пользователя под которым он будет туда лазить?

Кому интересно, нашел тут на Citrix форуме:

See "Advanced Conceptes - Metaframe XP Farm Maintenance"

DATABASE RESTORE/RELOCATION METHOD

1. Copy the backup database or the original database to the server that is to become the new host server (eg, into c:\Program Files\Citrix\Independent Management Architecture)

2. On the new host server, create a new "File DSN" that points to the new local database from Step 1. The existing file that is backed up into \\erajabfile01\d$\CitrixDatabase can be utilised as is or modified to suit the purpose.

3. On all servers in the farm, execute dsmaint failover to point to the new host server. NOTE: The IMA service must be running on these servers for the command to execute properly. You must do this before executing dsmaint config on the new host server as specified in the next step; otherwise the other servers in the farm will not be able to write to the database.

4. On the new host server, execute dsmaint config to point the IMA service to the newly created DSN file from Step 2. If no security was set on the Access database, use the default user account and password information (citrix/citrix).

dsmaint config /user:citrix /pwd:citrix /dsn:"c:\program files\citrix\independent management architecture\MF20.dsn

5. If you are moving the database to another server and the original host (database) server is still intact, change the original host server to its new role as an indirect server (it will now access the data store indirectly through the new host server) by running the Registry Editor (Regedt32.exe) and changing the value of the following registry key from Imaaccess.dll to Imaodbc.dll: HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\IMA\DatabaseDri­ver

6. Stop and restart the IMA service on all farm servers.

7. When the IMA service on the new host server is running, stop and restart the IMA service on all of the other servers in the farm. IMPORTANT: Restarting the IMA service instead of rebooting might cause the SNMP service to Dr. Watson if SNMP is enabled. This error is benign.

http://www.citrix.ru/forum/read.php?TID=112