Peter's Gekko

Sponsors

The Lounge

News

Advertisement

Images in this post missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at imagehelp@codebetter.com
Installing SQL reporting services on a machine without SQL server

SQl reporting services is bound to a SQL-server installation. You can set up reporting services on another machine, fi for development , but the setup has some flaws. It took me some blogreading and guesswork to get it done.

  • The setup needs to do some fiddling in the sql instance (create / alter a db). It needs the credentials of a sa-level user to get that done. In name one of the dialogs gives you the opportunity to enter them. This blog post tells you that that does not work. And describes how to pass the desired credentials in the command line. Which works fine as long as you pass the full path to the msi-file. Like  setup /i D:\ENGLISH\SQL2000\REPORTING_SERVICES\DEV\SETUP\rsrun.msi rssetupaccount=sa rssetuppassword= (bad sql instance,user sa has no password..)
  • A second hurdle is another page in the setup which starts about a webfarm and asks for a servername. Woolly language, it's not clear what they want. What will work is entering the name of the SQLserver followed by the path of the reporting services virtual home directory. Like Brochis\ReportServer. Still don't see what that has to do with a webfarm...

Now a succesfull setup is just one error away. Something vague, perhaps specific to my network. Clicked it away and reporting services were working.

Run the report services service pack 2 after this. Else existing apps (which don't use rs) will keep popping up annoying errormessages telling you rs is not properly initialized. My sp2 setup ran without a glitch, can't garantee yours will. With Crystal Reports in mind I keep my fingers crossed..:)

 


Posted Mon, May 2 2005 3:15 AM by pvanooijen
Filed under:

[Advertisement]

Comments

Lorenzo Barbieri @ UGIblogs! wrote I bookmark del giorno #3
on Mon, May 2 2005 7:49 AM
Peter's Gekko wrote ASP.net applications : a rich user experince for mort-al users
on Fri, Jul 29 2005 4:48 AM
I was struck by a post Make it as rich as possible by simplegeek Chris'An where he complains about the...

Add a Comment

(required)  
(optional)
(required)  
Remember Me?