Move Citrix PS 4.5 DB from SQL 2000 server to SQL 2005 server
Posted on 2009-02-23
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!