Moving Business Objects 11

I am wanting to get BO off some old Windows 2000 Pro Machine to an XP virtual machine. The reason behind this is a ODBC connection from that machine to the cisco sql server wont connect and two we need to get it off that machine at some point. The original person who set that up is no longer with the company and not a single person knows how to move that thing. I have already setup XP and installed BO 11 and there were no issues.

Now to try and mirror the settings from the old machine to the new is giving me a headache :) Looking over ODBC connections and SQL setups is the problem I am having. I would like to think that copying over SQL information from the old to the new things might work but I have to tell the new configuration where this stuff is I guess.

Could anyone assist with a move?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
I'm a little confused.  You're having issues with ODBC connecting from the old machine to the Cisco database.  Have you identified the cause of the error?

In general, moving to a new server isn't all that difficult:

1)  Install BusinessObjects Enterprise XI on the new machine
2)  Create the same printer and database connections that existed on the previous machine
3)  Configure any other settings you need, such as AD administration, IIS, Tomcat, etc...
4)  Use the import wizard to import data from the old machine to the new machine
5)  Test reports, permissions, scheduled jobs, etc...
6)  Once testing has been successfully completed and any final tweaks have been made, turn off the old machine and disseminate the new URL to your users

In your case, it sounds like the primary issue is figuring out your SQL connectivity issues. Are you getting any specific error messages?  Can you successfully login from elsewhere?

stlhostAuthor Commented:
It turned out the user accessing the database needed admin rights on the cisco server. At the time I was frustrating and looking to just move the entire thing because it is running on an old computer anyways but it turned out to be something simple anyways. I had forgot about this post.

Thank you for your time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.