Perfect. That did the job (so to speak). If the job executes sp code that performs data operations on tables in a specific database it appears that the job's permissions...

PowerPivot is a free add in for Excel 2010. For those doing data analysis out of SQL databases or SSAS it's a game changer. The ability to handle datasets with...

I do this in dozens of spreadsheets for users all over the resort in both Excel 2003 and Excel 2007. Use MSQuery. Cancel for tables but tell it you want...

A few points:

Some of you guys need to climb down off your high horses and remember that many of us use SQL Server in environments where getting Reporting Services and...

OK, I understand the RS needs IIS, and the RS has to be on the same box as SQL Server for licensing reasons. I just don't understand why IIS has...

If I'm running another IIS server for other purposes do I need to also run it on the database server in order to support Reporting Services?

What I seem to be...