web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SQL 2005 SP1 is required
Microsoft Dynamics SL (Archived)

SQL 2005 SP1 is required

(0) ShareShare
ReportReport
Posted on by Stuart Nottingham 1,226
My client is still using SL7.0 FP1 with SQL Server 2008 R2. Last March we got the above error when trying create a new application database in Database Maintenance. We applied the available hotfix  (HF970678) and  were able to create the database.
Now eleven months later, we're getting the same message when we try to create yet another application database. I've verified that the hotfix is still there and (just to be sure) reapplied it to no avail.
We are planning an upgrade in the near future, but does anyone have any suggestions for the meantime? At this point, I'm considering applying SP4.but would like some assurance that the time would be well spent.
Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SQL 2005 SP1 is required

    Hello Stuart,

    Environment team member did reply to my question regarding your issue

    I’d say either set up a supported configuration and create them there and move them over, or upgrade.  I’ve run into that issue before and have not been able to work around it.

    Since v7.0 is no longer supported, I would go for an upgrade. I honestly see no reason for them to stay on that version. I imagine you know that you can't get a hotfix anymore for any version 7 --most of the old KB's regarding 7 have been removed (unless the same issue exists in later versions)

    Best Regards,

    Jana MacDonald

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SQL 2005 SP1 is required

    Hello,

    I will inquire with a environment specialist.

    You may just have to upgrade your client to a supported version unfortunately

    Best Regards,

    Jana MacDonald

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: SQL 2005 SP1 is required

    I was able to obtain the 7.0 SP3 HF 20440 which includes the build 7.03.40224.00 for the 9829000.exe file (thanks Brian), but it still does not resolve the issue.  I know it is resolved for SL 2011, but the client does not have access to that version.  What else can I do to create new 7.0 SP3 DB's?

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: SQL 2005 SP1 is required

    This site has not been touched (by me) in years.  After years of no contact, they recently asked me to add some new DBs.

    They are on 7.0 SP3, and the 9829000.exe file version is 7.04.40409.00 dated 4/9/2010. Dynamics SL also crashes when opening, so I don't know if anything else there is causing a problem.

  • Suggested answer
    CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SQL 2005 SP1 is required

    You might check the files changed and ensure that you have ran the sql scripts , if you are using the same version of SL on your new db then Id assume you are accessing the correct executables

    Microsoft Dynamics SL 7.0 Service Pack 1 (SP1)

    Changed Files Date File Version

    70ProcedureUpdate.sql 24-Sep 2008

    70sProcedureUpdate.sql 24-Sep 2008

    70ViewUpdate.sql 24-Sep 2008

    9829000.exe 24-Sep 2008 7.01.30611.01

    Bug17048SY.sql 24-Sep 2008

    Bug17677SY.sql 24-Sep 2008

    Signon.exe 24-Sep 2008 7.01.30611.01

    Soldb.dll 24-Sep 2008 7.01.30611.01

    Microsoft Dynamics SL 7.0 Service Pack 2 (SP2)

    Changed Files Date File Version

    9829000.exe 15-Jun 2009 7.02.30615.00

    Microsoft Dynamics SL 7.0 Feature Pack 1 (FP1)

    Changed Files Date File Version

    9829000.exe 20-Mar 2009 7.03.30320.00

    The issue is fixed in SL 2011 (8)

    Best Regards,

    Jana MacDonald

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: SQL 2005 SP1 is required

    Dear Stuart,

    I'd need to research it, but Microsoft  Support Information ---A fix is scheduled to be included with Microsoft Dynamics SL 8.0.

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: SQL 2005 SP1 is required

    Does not appear I can send you a PM from your profile, so I sent you a friend request with a message.  Thanks.

  • Brian_IL Profile Picture
    Brian_IL 719 on at
    RE: SQL 2005 SP1 is required

    Send me a private message with an email address, or any method you prefer to get a copy of that hotfix to you.

    I used to be surprised running across client setups on SL7, but I recently worked with one client running SL5.5 on a WIN2003 server. (Yes, they are moving off of that platform).

  • Mark E Profile Picture
    Mark E 6,451 on at
    RE: SQL 2005 SP1 is required

    Brian,

    Running into this similar issue at a site running SL 7.0SP3.  The link to the HF on PartnerSource is broken, can you send me the downloaded HF package?  Thanks.

  • Brian_IL Profile Picture
    Brian_IL 719 on at
    RE: SQL 2005 SP1 is required

    I agree with your analysis, the problem is likely the SQL installation. To create a new SL7 database you could spin up a new temporary VM with a lower SQL build number, create a new empty DB from the current SL installation, and follow steps to move it and merge with the existing SQL installation. SQL will handle updating the new DB internally when you attach or restore it, and this approach avoids troubleshooting the initial DB creation problem. Additional work for only one database, so the client should evaluate whether extra time spent now was better than waiting until after their SL version upgrade.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans