• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Oct 152007
 

Installing SQL 2000 RS

When you run the installation you get a pop-up warning about not having Visual Studio 2003 installed, this only affects Report Designer, and we can live without that.  You do need to make sure that SQL 2000 SP 4 is installed, or you get most of the way through, and then can’t choose the default Credentials Type – or rather the default is Service Account, but you can’t opt for that (http://support.microsoft.com/?id=821334)

When asked about which account you want the ReportServer Windows service to run under, I left this at NT AuthorityNetwork Service, and I left the service at Auto-start.

For the Virtual Directory information I had the following defaults configured :

Report Server Virtual Directory: ReportServer

Report Manager Virtual Directory: Reports

Use SSL: This was ticked, but I unticked it, because I don’t have SSL configured.

Next you are asked about the Report Server Database :

SQL Server Instance: Evault1

Name: ReportServer

Credentials Type: Service Account

I left all those as-is.

There were 1 or 2 other items to fill in, but they are straight forward.  Installation then runs though.

EV 2007 Installing and Configuring Guide says :

Microsoft SQL Server 2000 Reporting Services with SP 2, or Microsoft SQL Server 2005 Reporting Services (SP1 recommended)

Configuration

Need to try and make sure the installation fails, so let’s try configuring “My Reports” first of all.

Go to http://evault1/Reports, and login.  This is the first screen :

image

I now want to turn on “My Reports”, so that I can get the EV Reports installation to fail, to do that click on Site Settings, to go to :

image

On that screen tick the box for enabling the reports, and click Apply.

Installing SQL 2000 Reporting Services SP 2

This is just a small (20 Mb) executable to run.  It is listed as a pre-req for EV Reports so rather than suffer any problems, or a failed installation because of that, I installed that.

Installing EV Reports

Looks like you need to run evdeployreports.exe, however, I can’t find that !  So, to get the first run through I did :

* Stopped all EV Services

* Stopped IIS Admin Service

Then re-run the setup.exe from the EV installation CD.  This then gives the option (as a tick box) so that you can install reports.

Running for the first time

After restarting the IIS services, and EV, you now have an extra menu item called “Enterprise Vault Reports Configuration”.  You also have an EVReports folder underneath the main Enterprise Vault folder on the file system.  Clicking on that option in the start menu, brings up this screen :

image

I used the Vault Service account on this screen, though I really suspect that I should use something else.  I can check that in the Installation Guide.

After a few minutes, and a bit of IIS service restart action, I got a failure message :

image

And the log file (which is in the EVReports folder says) :

W3SVC is currently stopped so starting it
W3SVC is currently waiting to start
W3SVC started successfully
Leaving UIHelper::StartService
Leaving UIHelper::StartChild
Entered UIHelper::StartChild
Entered UIHelper::StartChild
Starting service :W3SVC
Entered UIHelper::StartService
W3SVC started successfully
Leaving UIHelper::StartService
Leaving UIHelper::StartChild
Starting service :HTTPFilter
Entered UIHelper::StartService
HTTPFilter started successfully
Leaving UIHelper::StartService
Leaving UIHelper::StartChild
Starting service :IISADMIN
Entered UIHelper::StartService
IISADMIN started successfully
Leaving UIHelper::StartService
Leaving UIHelper::StartChild
Leaving UIHelper::RestartIIS
Restarting IIS successful
Entered Configuration::CreateRootFolder()
Entered RsHelper::ListReportServerItems()
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The value for parameter ‘Item’ is not specified. It is either missing from the function call, or it is set to null. —> Microsoft.ReportingServices.Diagnostics.Utilities.MissingParameterException: The value for parameter ‘Item’ is not specified. It is either missing from the function call, or it is set to null.
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
— End of inner exception stack trace —
at Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ReportingService.GetProperties(String Item, Property[] Properties)
at Symantec.EnterpriseVault.Reporting.RsHelper.ListReportServerItems(String folderPath, Boolean recursive)
at Symantec.EnterpriseVault.Reporting.Configuration.CreateRootFolder()
at Symantec.EnterpriseVault.Reporting.Configuration.Install()
Symantec.EnterpriseVault.Reporting.DeploymentException: Error code: SoapError
at Symantec.EnterpriseVault.Reporting.Configuration.Install()
at Symantec.EnterpriseVault.Reporting.AppClass.Install(Configuration cnfg)
at Symantec.EnterpriseVault.Reporting.AppClass.ConfigureReporting()
Entered ReportDeployForm::DeployReportsCallback
Entered Configuration::Configuration()
Entered RsHelper::RsHelper()
Leaving RsHelper::RsHelper()
Leaving Configuration::Configuration()
Entered RsHelper::ListReportServerItems()
Symantec.EnterpriseVault.Reporting.DeploymentException: Error code: SoapError

Server stack trace:
at Symantec.EnterpriseVault.Reporting.AppClass.ConfigureReporting()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at Symantec.EnterpriseVault.Reporting.ReportDeployForm.DeployReportsDelegate.EndInvoke(IAsyncResult result)
at Symantec.EnterpriseVault.Reporting.ReportDeployForm.DeployReportsCallback(IAsyncResult asyncResult)
Leaving ReportDeployForm::DeployReportsCallback

Fixing it Up

Go back to the SQL Reporting Site Settings page, and turn off My Reports.  Re-run the EVDeployReports.exe

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

  2 Responses to “SQL Reporting Services”

  1. I am trying to set this up right now, but i cant find the sql 2000 reporting service install any where. can you point me in the right direction?

  2. Check out :

    http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en

    That’s the eval version, I think. I got my normal/ordinary version from an MSDN subscription from what I remember.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)