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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Setting up Reporting Services for VS2010

Author  Topic 

StacyOW
Yak Posting Veteran

93 Posts

Posted - 2012-12-06 : 11:02:01
I have installed sql server 2008 r2 and I have a winforms application. I have sql installed on one of my network computers and another computer on the network accesses my database through the network. I know this is not the ideal installation but IT didn't want to install sql on the server since only two of our computers will be accessing that database. Anyway, I have built some reports in vs2010 and I can execute them as a local reports just great, either with a reportviewer or printing directly to the printer.

My problem is when I install the VS program on the other computer and try to print those "Local" reports I get an error. At first I thought I would just be able to copy the directory with my rdlc reports over to that computer and it could run them as local reports, but it still doesn't work. I have never used the sql reporting services and I am wondering if that is going to be the only way to solve this problem. How exactly does that work. I've read online to try to figure it out but it was getting really complicated having me turn on IIS management tools on in the control panel.

Thanks for any help!
Stacy
P.S. Not sure if I should be asking VS people or Sql people about this problem.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-07 : 08:23:20
do you've report server setup in machine where you installed sql. If not, you need to first setup report server (it doesnt require IIS from 2008 onwards). Once you do that and configure virtual directory you can access report server over domain using domain account. Then deploy your reports to server and then you should be good to access them from other machine so far as they're both in same domain

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

StacyOW
Yak Posting Veteran

93 Posts

Posted - 2012-12-07 : 11:13:20
Thank you very much Visakh16 for your reply. I had Sql Server 2008 express R2 loaded on a windows 7 machine and apparently that version doesn't come with the reporting functions? Anyway I uninstalled sql and am in the process of reinstalling just plain old sql server 2008 express SP3 which says it has the reporting included. The R2 loaded the Report Server Configuration Manager though so not exactly sure why reporting isn't included in that version. Hopefully this will solve the problem!

Thanks,
Stacy



quote:
Originally posted by visakh16

do you've report server setup in machine where you installed sql. If not, you need to first setup report server (it doesnt require IIS from 2008 onwards). Once you do that and configure virtual directory you can access report server over domain using domain account. Then deploy your reports to server and then you should be good to access them from other machine so far as they're both in same domain

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-07 : 11:43:29
Ok...Configure report server post installation and try deploying reports to it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

StacyOW
Yak Posting Veteran

93 Posts

Posted - 2012-12-07 : 12:23:20
Well I got it reinstalled and no report server configuration manager is installed. I have sql server 2008 express installed at home on a vista x64 computer and it works great and so does the report server, lets me log right in and loads right up. I tried installing the same version as I have at home on this windows 7 computer and I get an error during installation that this version is not compatible with this version of windows - so if you install you will need to install a service pack to fix the bugs. So I just went right to sql server 2008 express SP3 and no reporting stuff is installed.

Do you have any idea what version I can install that will have the reporting included?
Thanks for all your help!
Stacy



quote:
Originally posted by visakh16

Ok...Configure report server post installation and try deploying reports to it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/



Go to Top of Page

StacyOW
Yak Posting Veteran

93 Posts

Posted - 2012-12-07 : 14:26:14
Trying Sql server 2008 express R2 RTM - hopefully this is the last time I have to install!

Stacy


quote:
Originally posted by StacyOW

Well I got it reinstalled and no report server configuration manager is installed. I have sql server 2008 express installed at home on a vista x64 computer and it works great and so does the report server, lets me log right in and loads right up. I tried installing the same version as I have at home on this windows 7 computer and I get an error during installation that this version is not compatible with this version of windows - so if you install you will need to install a service pack to fix the bugs. So I just went right to sql server 2008 express SP3 and no reporting stuff is installed.

Do you have any idea what version I can install that will have the reporting included?
Thanks for all your help!
Stacy



quote:
Originally posted by visakh16

Ok...Configure report server post installation and try deploying reports to it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





Go to Top of Page

Matengele
Starting Member

4 Posts

Posted - 2013-01-01 : 12:34:00
Hi , as far as i know sql server 2008 or 2008R2 with advanced features both have SSRS, also where are you expecting to find the report server? it will not be an item on your menu that you can launch? try http://localhost/reports after installing sql on a machine and see if you get the home page of your report server.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-01 : 23:51:43
quote:
Originally posted by StacyOW

Well I got it reinstalled and no report server configuration manager is installed. I have sql server 2008 express installed at home on a vista x64 computer and it works great and so does the report server, lets me log right in and loads right up. I tried installing the same version as I have at home on this windows 7 computer and I get an error during installation that this version is not compatible with this version of windows - so if you install you will need to install a service pack to fix the bugs. So I just went right to sql server 2008 express SP3 and no reporting stuff is installed.

Do you have any idea what version I can install that will have the reporting included?
Thanks for all your help!
Stacy



quote:
Originally posted by visakh16

Ok...Configure report server post installation and try deploying reports to it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/






reporting services wont come with express unless you install express with advanced services

http://msdn.microsoft.com/en-us/library/ms365166(v=sql.105).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -