Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005). I know that our application (FileNet Image Services) is sensitive to what we refer to as an "orphaned" database. Our app stops working if a database is simply detached/attached to another server because it loses that link between the users in the database and the users in SQL Security. Once that happens, that users cannot simply be recreated in Security-Logins. Because of internal IDs the users no longer match and our app stops working.
Any ideas to get around this?
Software/Hardware used: SQL2000 to SQL2005 migration/upgrade need to preserve user security
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!