| 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!StacyP.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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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,Stacyquote:
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 MVPhttp://visakhm.blogspot.com/
|
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
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!Stacyquote:
Originally posted by visakh16
Ok...Configure report server post installation and try deploying reports to it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
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!Stacyquote:
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!Stacyquote:
Originally posted by visakh16
Ok...Configure report server post installation and try deploying reports to it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
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. |
|
|
|
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!Stacyquote:
Originally posted by visakh16
Ok...Configure report server post installation and try deploying reports to it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
reporting services wont come with express unless you install express with advanced serviceshttp://msdn.microsoft.com/en-us/library/ms365166(v=sql.105).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Setting up Reporting Services for VS2010