Skip to main content

Notifications

Microsoft Dynamics RMS forum

sql server 2012 error 'sp_dboption'

Posted on by 345

Install sql 2012 and service pack 1, sql 2005 backward compatible with RMS 2.0 and all service packs 1,2,3, 4 plus the feature 1 and 2. When I restore the database, it pop up the error message (could not find stored procedure 'sp_dboption'. Any suggestion to fix this issue? thx
Hai Lam

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: sql server 2012 error 'sp_dboption'

    you are receiving this message because SP_DBOPTION is retired and was taken out of SQL 2012.  

    Suggest you either update to CU5 or don't use 2012.  All my RMS customers are currently on 2008R2 with no plans to update.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: sql server 2012 error 'sp_dboption'

    That error message you got, you did not install SP or FP properly or didn't get installed on your PC. I have tested without installing SP or FP and I got that error message. After I install all SP and FP, it works!

    My version is 2.0.2002 (SP4, FP1,2 and CU5+CU5 Hotfix)

  • HaiLam Profile Picture
    HaiLam 345 on at
    RE: sql server 2012 error 'sp_dboption'

    Jeff,  thank you for your response.  That is the way I expect to work with.  This is a test of sql 2012 with Rms 2.0.  MS advice me to buy sql 2012 then downgrade to sql 2008r2 if not compatible, and I did that.

    Thanks again for suggestion,

    Hai Lam

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    RE: sql server 2012 error 'sp_dboption'

    At this time, we are not recommending installing SQL2012 for RMS.  Go back to 2008 R2.

    Also, there is no need to install all of the SP and FP.  FWIW, we install SQL2k8R2 and the latest BC and set it up.

    Then install the base RMS SO/HQ package, then 2.0.0155 FP1, 2.0.0155 SP4. 2.0.100 FP2 and the latest hotfix 2.0.1006

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans