SQL Report Viewer Web Part and SSRS Configuration

I have a Report Server that contains a number of default CRM reports and the Report server was configured in native mode, NOT sharepoint integrated mode. I would like to use the report viewer web part, but in order to install it I must go to Integrated mode.  The wizard tells me that I must create a new database in order to go to integrated mode.  Won't that make my CRM reports inaccessible?
chaffee007Asked:
Who is Participating?
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.

zephyr_hex (Megan)DeveloperCommented:
when you change SQL Report Server to integrated mode, you will lose connectivity to your default sql report server website.
the database, however, remains intact and you can still access it... just not from the default web interface.
0
chaffee007Author Commented:
What would be te URL?  I should just be able to move the reports to the new database right?

My problem is I don't know all the URL pointers I would have to change if I keep them in the original location.
0
zephyr_hex (Megan)DeveloperCommented:
i would export the reports first (before you do your sharepoint integration) and then import them to the sharepoint integrated database.
otherwise, you are going to have to query the old report database directly (using sql)
0

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
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
Enterprise Software

From novice to tech pro — start learning today.