Move Citrix PS 4.5 DB from SQL 2000 server to SQL 2005 server

Posted on 2009-02-23
Medium Priority
Last Modified: 2012-05-06
i have 2 citrix ps4.5 servers patched on 10/26/07 with pse450w2k3r01 patches. I have an old SQL 2000 server that is end of life and would like to move the metaframe db that resides in the SQL 2000 server to a new server with SQL 2005. I also have to change the password because the 2000 server had a user of sa and no password and now the sa user has a password in the 2005 environment. Both SQL servers are Windows 2003.  I realize i need to change server name in dsn, etc and have seen lots of varying descriptions on how to do this, has anyone done this and have specific steps they know have worked? or at least exact steps on how this should be done in my scenario, I am not a SQL guru by any streach of the word and just need steps to complete that are concise as possible.  thanks for your time!
Question by:korymolo

Accepted Solution

60MXG earned 1500 total points
ID: 23716915
The SQL 2005 server does not allow for empty password so you have to set a password.

Here are some steps I used to migrated my SQL DB from SQL 2000 to SQL 2005.

1)  Create a back up for old DB
2)  Move the back up DB file from SQL 2000 server to SQL 2005 and restore it
3)  Run these scripts in your query analyser (SQL 2005) to find any orphan left by the migration
     exec sp_change_users_login 'report'   --- This will display a list of the orphan

     exec sp_change_users_login 'auto_fix', 'sa',null,'password' -- sa is the user account and password must meet the requirement of new SQL 2005 so it will be something like this (exec sp_change_users_login 'auto_fix', 'sa',null,'IMig@#Sql2000ToSql2005')

4) Change the username and password in your Citrix configuration file.

hopefully you can get this to work!

Author Closing Comment

ID: 31550358
still not getting it but seems like my citrix stuff is in the master db on the original box, think i am going to have to get some pro help...

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question