SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Setting up Reporting Services for VS2010
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

StacyOW
Yak Posting Veteran

USA
93 Posts

Posted - 12/06/2012 :  11:02:01  Show Profile  Reply with Quote
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.

Edited by - StacyOW on 12/06/2012 11:55:53

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 12/07/2012 :  08:23:20  Show Profile  Reply with Quote
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

USA
93 Posts

Posted - 12/07/2012 :  11:13:20  Show Profile  Reply with Quote
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/




Edited by - StacyOW on 12/07/2012 11:13:52
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 12/07/2012 :  11:43:29  Show Profile  Reply with Quote
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

USA
93 Posts

Posted - 12/07/2012 :  12:23:20  Show Profile  Reply with Quote
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

USA
93 Posts

Posted - 12/07/2012 :  14:26:14  Show Profile  Reply with Quote
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

Zambia
4 Posts

Posted - 01/01/2013 :  12:34:00  Show Profile  Reply with Quote
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

India
52323 Posts

Posted - 01/01/2013 :  23:51:43  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000