Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhimenvora
Starting Member
5 Posts |
 Posted - 2011-10-05 : 07:34:15
|
| I need to use sequal server for the reporting service.I have 2 server machine 1. sql server machine2. web server machinein the web server I do have visual studio and client of sql server with reporting service.Here is the issue I want to deploy the reports on the web server instead of sql server machine using SSRS.I do have sql server 2008 and visual studio 2008can any one help me that how I can do this. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 07:43:36
|
| are both the machines in same domain?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
dhimenvora
Starting Member
5 Posts |
Posted - 2011-10-05 : 08:16:38
|
| Yes this both machine in the same domainAnd is this possible that if both the machine is server machine and not in the same domain? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 08:25:29
|
| if they're not in same domain its difficult as you've enable remote connections etcif they're in same domain give access to users in server machine and map them to predefined role in Report manager (like My reports) and it allow them to deploy reports to folder created by them.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
dhimenvora
Starting Member
5 Posts |
Posted - 2011-10-05 : 08:45:59
|
| Hi Visakh, Thanks for your reply. But let me tell you my exact issue with the steps1. I do have two machines with the IP 192.168.1.75 and 192.168.1.33, sql server is in 192.168.1.75 so I have start there reporting service on that machine,2. I have start to create a reporting service in the 192.168.1.33 and have tried to change the database from the 192.168.1.33 to 192.168.1.75.When I try to configure report server configuration with giving sql details of other machine it prompt with error "The feature: Remote access to report data sources and/or the report server database is not supported in this edition of Reporting Services."I have sql server 2008. and while configuring I am giving sql detail of other pc to run on my local pcMay I missing something or permission related issues? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 08:51:03
|
| thats no possible. you need to setup report server in 192.168.1.33 itself. you can still deploy reports from other machine to this if they're in same domain------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
dhimenvora
Starting Member
5 Posts |
Posted - 2011-10-05 : 08:55:34
|
| Hi Visakh,So why it says error related to version/edition supported issue with SSRS.I do have SQL server with SSRS installed on my local machine but still I want to use SSRS from remote to local (with local virtual directory).Please suggest. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 11:08:12
|
quote:
Originally posted by dhimenvora
Hi Visakh,So why it says error related to version/edition supported issue with SSRS.I do have SQL server with SSRS installed on my local machine but still I want to use SSRS from remote to local (with local virtual directory).Please suggest.
is your SSRS version different from SQL installed on other machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sequal server for the reporting service