When integrating SSRS reports into web apps, report view redistributables have to be installed against the web server. Otherwise, users can not view any SSRS reports.
Monday, July 26, 2010
Friday, July 16, 2010
Access is denied when connecting to SSIS via SSMS 2008
I was trying to connect to a SSIS 2005 installation via SSMS 2008.
The first error I had is the classical access is denied. I googled around and realized that I need to get right access privileges.
Luckily, MS posted this article ( http://msdn.microsoft.com/en-us/library/aa337083.aspx) which is pretty helpful. However, our DBA followed the every single steps but I still can’t connect to. Finally, it turns out that we have to do the save steps on the higher level which is the My Computer. Basically,have to right click My Computer under computer service/computers. This step was missing on that article.
Secondly, when I try to connect to SSIS 2005, it pops up another error which is class is not registered. This is actually a known issue by MS but there is no solution at this moment (https://connect.microsoft.com/SQLServer/feedback/details/363922/connect-to-ssis-service-on-machine-servername-failed-class-not-registered?wa=wsignin1.0) . So for now, for SSIS 2005, we have to use SSMS 2005 to connect. However, SSMS2008 can be used to connect to DB 2005/2000, analysis service 2005. Odd…
Thursday, July 15, 2010
Foreach Loop Container Variable Mappings
There are two articles which did a nice job explaining this task
http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
Subscribe to:
Posts (Atom)