Avatar of ezkhan
ezkhanFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Deploying SSRS Reports from one Domain to An Other Domain when Target Domain's SQL Server is configured in Sharepoint 2010 Integrated Mode

Hi,

I have a situation where my development and test servers are on one domain and production server is on a different domain.

I need to deploy ssrs reports from one domain (domain1 where these are developed) to different domain (i.e., Production server domain)  on sharepoint site.

Using  Business Intelligence Development Studio's Report Designer it's not possible to deploy reports on an other domain.

I am thinking to copy my .rdl files (reports), .rds file(shared data source) and .rsd files( shared data sets) from domain1 to domain2 and then try to upload them in document library on sharepoint.

Can you please suggest what are the steps to upload these files to sharepoint site?

And please also suggest if there are any other ways to achieve the same results.

Any comments, suggestions and/or web links are appreciated.

Thanks.
Microsoft SharePointSSRSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Justin Smith
Avatar of Justin Smith
Justin Smith
Flag of United States of America image

Avatar of ezkhan
ezkhan
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks for taking time and reply to my question ACH1LLES. But, unfortunatly in my environment it's not possible to use any tool to move reports accross.

It'll be great if you could guide me through the setps to upload .rdl,.rsd and .rds files on sharepoint site.

Looking forward for your reply.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Justin Smith
Justin Smith
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo