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?
 
zephyr_hex (Megan)Connect With a Mentor 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
 
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
All Courses

From novice to tech pro — start learning today.