Post reply

Does a report developed with SSRS 2005 only see dbo?

  • April 2, 2012 at 11:19 am

    #1467756

    Lynn Pettis (4/2/2012)

    Rod at work (4/2/2012)

    tom.wauters (4/2/2012)

    I would suggest to migrate to SQL Server 2008 R2.

    First of all, your databases will be in the newer environment, which has lots of improvements compared to SQL Server 2005.

    Second, and for this I rely on my colleagues here, since I couldn't test it, your problem would disappear with SSRS 2008 R2.

    Is there any specific reason why your production environment is still on SQL Server 2005 ?

    The reason we've not migrated is money. We're a non-profit organization. We don't have the latest and greatest, we don't go to conferences, seminars, etc. A training budget is non-existant, and pay is low enough that we cannot afford our own. Even our backup tapes are highly vulnerable, because they sit on a book shelf in the server room. I've finally won a major victory in convincing my management that we at least need a fireproof safe to put them into. This organization has been around for 16 years, and I've only now won that. Upgrade to SQL 2008 R2 or SQL 2012? HA! HA! HA! Not going to happen.

    Just curious, as I did interview with a couple of non-profits recently, does your organization pay full price for its software? The non-profits I talked to seemed to get deep discounts when purchasing software like MS SQL Server.

    That's a good question, Lynn, I am not entirely sure. My boss recently left for other employment, sort of leaving me holding the bag, so to speak. (Not exactly, as I don't have signature authority on anything, whereas he did. But I do review and recommend.) I have strongly recommended renewing our MSDN Subscription, which expires this month, and I know we get a very good discount on that. However, I wasn't involved in the purchase of SQL 2005, some 7 or 8 years ago when we purchased it. I am going to try and see if we can upgrade to SQL 2012 Standard Edition (I know I can't get anything more), and I'll probably start sometime either this month or next to lobby for that. I truly don't expect it to happen, until maybe FY 2014 at the earliest.

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply