Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Dynamics SL Database Maintenance Error

(0) ShareShare
ReportReport
Posted on by 115

I'm using Dynamics SL 2011 and I recently migrated my database to a SQL 2012 server from a 2008 server.  When I connect to the database in the Database Maintenance utility, it gives me the error

"Error -3: Alter failed for Server 'SERVER\NAME'." 

Any help on this would be appreciated.  Thank you. 

*This post is locked for comments

  • Carolyn Kolpien Profile Picture
    on at
    Re: Dynamics SL Database Maintenance Error

    Also, please make sure you install the prerequisites first before installing the hot-fix.  Otherwise, it won't fix the issue.

  • Carolyn Kolpien Profile Picture
    on at
    Re: Dynamics SL Database Maintenance Error

    Hi Nathan,

    If you are using SL 2011 SP1, you need to apply the hot-fix for bug 23705 to make SL compatible with SQL Server 2012.  You can find the hot-fix in KB article 2697847.  Here is the link:  mbs.microsoft.com/.../KBDisplay.aspx

  • Nathan Benedicto Profile Picture
    115 on at
    Re: Dynamics SL Database Maintenance Error

    Thanks for your reply Rodi.  I used a different server.

  • rodi Profile Picture
    3,205 on at
    Re: Dynamics SL Database Maintenance Error

    when you upgrade, do you same server, or different server (physically)?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February 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... 293,027 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans