Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Error 55555
Microsoft Dynamics RMS (Archived)

Error 55555

(0) ShareShare
ReportReport
Posted on by Don Tuleja 260

The question was posted here: http://community.dynamics.com/product/rms/f/106/p/62266/156181.aspx#156181

But that was a year ago with no solution.

I have a 2k8r2 server clean install with SQL Express 2012 and RMS 2.0. These are all clean installs.

The database was imported from an Express 2008 server that is ready to be retired.

When I test the database connection from SOA Configuration, it's fine. But when I try to connect to it, I get the error:

"Error 55555, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage."

The event log just shows the same message.

Since this is a clean machine not yet in production I can wipe and re-install as needed, but I'm VERY curious as to what the cause is. What is that error code signifying?

*This post is locked for comments

  • Jon Stalnaker Profile Picture
    Jon Stalnaker 220 on at
    RE: Error 55555

    Thanks, I was looking in the wrong place.  The 64bit version of that feature pack also worked for me, even though I don't have SQL 2005 installed.

    Thanks again!

  • Community Member Profile Picture
    Community Member on at
    RE: Error 55555

    Here is the download link:

    download.microsoft.com/.../SQLServer2005_BC.msi

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Error 55555

    You might try getting it out of the SQL Server 2005 SP4 Feature Pack components at www.microsoft.com/.../details.aspx.

  • Jon Stalnaker Profile Picture
    Jon Stalnaker 220 on at
    RE: Error 55555

    I installed everything I could with 2012 but I haven't found a specific SQL Server 2005 Backward Compatibility download anywhere.  Is it included in the 2012 install or is it a separate download?

  • Community Member Profile Picture
    Community Member on at
    RE: Error 55555

    Did you install the SQL Server 2005 Backward Compatibility?

  • Jon Stalnaker Profile Picture
    Jon Stalnaker 220 on at
    RE: Error 55555

    I'm having this problem today.  Trying to connect RMS 2.0.1000 to

    Microsoft SQL Server Management Studio 11.0.3128.0

    Microsoft Analysis Services Client Tools 11.0.3128.0

    Microsoft Data Access Components (MDAC) 6.2.9200.16384

    Microsoft MSXML 3.0 6.0

    Microsoft Internet Explorer 9.10.9200.16384

    Microsoft .NET Framework 4.0.30319.17929

    Operating System 6.2.9200

    on Windows Server 2012 Standard Build 9200

    What am I missing?  I've installed all features of SQL Server and walked through sp 1-4 and fp 1-2 of RMS.

  • Community Member Profile Picture
    Community Member on at
    RE: Error 55555

    Excellent answer, Even with the SQL 2012 compatibility that comes with 2.0.1000 you still need to install the Backwards Compatibility Patch for SQL.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    Re: Error 55555

    In my case, I had forgotten to install the Microsoft SQL Server 2005 Backward Compatibility.  Once I installed it, the "Error 55555..." went away and I was finally able to connect to the DB to upgrade it within RMS Administrator.

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at
    Re: Error 55555

    You cannot use SQL2k12 with any version of RMS less than 2.0.1000 (FP2)

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,930 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans