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 |
|
seethem
Starting Member
46 Posts |
 Posted - 2007-11-07 : 08:24:01
|
| Hi there,I am running MS SQL Server 2005 Reporting Services on an instance. We applied SP2 and checked the box to include the Reporting Services.Now for completion, is there a way to prove that SP2 was indeed applied to the Reporting Services for that instance.seethem |
|
|
Scott.Thornburg
Starting Member
10 Posts |
Posted - 2007-11-07 : 22:03:32
|
| Go to the report server website (not report manager)http://<server>/reportserver (by default)At the bottom there should be a version string.My SP2 site version is: Version 9.00.3054.00 Scott |
 |
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-11-09 : 17:24:46
|
| Hi Scott, Thanks for the response, the plot thickens...My own shows that it is at "Microsoft SQL Server Reporting Services Version 9.00.3042.00"More History:===============* This instance that has reporting services is one of 6 instances over a 2-node cluster * 3 instances per node* Two of the instances on this particular node has reporting services apart of it. Question:=============Can you advise how I can go to both of their "http://<server>/reportserver (by default)" pages please? |
|
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-11-09 : 17:50:25
|
| Further to which, I am gathering, from MS SQL Server 2005 Management Studio, that there is only one reporting server per node.Is this the case? or am I doing something wrong?Please advise. |
|
|
|
Scott.Thornburg
Starting Member
10 Posts |
Posted - 2007-11-09 : 19:59:00
|
| seethem,I've not run SSRS in a cluster to date, but this may help:1. Reporting Services Configuration Tool can show you the available SSRS instances. The tool is off your Program Files / MIcrosoft SQL Server 2005 / Configuration Tools menu. For machine name, I would image you would use the SQL virtual instance name(s), the same as your DB virtual instance names: <VirtualServer>/<Instance>. This will tell you the available SQL instances for that name. For example, I have several instances (not clustered) on a machine, and I reference them as: http://<server>/reportserverDEV, http://<server>/reportserverQAand so on.Note: I think my terminology here is old: Virtual Server used to be what we called the clustered SQL instance... I think MS is calling it something different now.2. Version 3042 was the base SP2, if I remember. There is a good up-to-date SQL build list at [url]www.sqlservercentral.com/articles/Administration/2960[/url] (registration required, I think). Sorry, I coundn't find a similar list at sqlteam.com.Hope this helps, Scott |
|
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-11-10 : 13:32:59
|
| Hi Scott,Thank you very much once more for your continued help.I believe we still refer to them as <VirutalServer>. I have found the necessary Reporting Service using the Reporting Services Configuration Tool.More Background Info=======================Node 1: Hostname = tt-app52Node 2: (this is the node where I am having some issues)Hostname = tt-app53The following database instances have been installed on Node 2 in the <VirtualServer>\<InstanceName> order:* sqlcluster00\LZONE* sqlcluster02\SAREA* sqlcluster04\CRECONThe following reporting services instances have been installed on Node 2:* tt-app53\lzone* tt-app53\sareaIf I go to Reporting Services Configuration Tool and I try to FIND - "tt-app53\sarea", it is not present. Interestingly, it is found on NODE 1 --> I.e. I can FIND - "tt-app52\sarea" when using Reporting Services Configuration Tool off of Node1.Now, when I connect to Reporting Services Configuration Tool and connect to "tt-app53\lzone"The following have been CONFIGURED (green) --> Server Status, Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity, Web Service Identity, Database Setup, Initialization.The following are OPTIONAL CONFIGURATION (blue) --> Sharepoint Integration, Encryption KeysThe following are RECOMMENDED CONFIGURATION (yellow) --> Email Settings, Execution accountISSUE @ HAND===============* Whenever I go to the Internet Explorer and I execute "http://tt-app53/reportserver" I get through and see the version mentioned above. * My concern is, what report server I am accessing? I want it to be the LZONE. How can I be certain?* Every permutation of that "http://tt-app53/LZONE/reportserver" or "http://tt-app53/reportserver$LZONE" do not work!* I think that somethings messed up because when ever I launch the site, "http://tt-app53/reportserver" , I am not able to UPLOAD any files.This last matter is the subject of another issue, currently active in this forum.Many thanks for your time and consideration,Regards,seethem |
|
|
|
seethem
Starting Member
46 Posts |
Posted - 2007-11-20 : 05:32:07
|
| Any advice? |
|
|
|
|
|
|
|
|
Reporting Services & SP2