Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

Can I run POS 2.0 on SQL 2008 instead of SQL 2005?

Posted on by 135

Can I run POS 2.0 on SQL 2008 instead of SQL 2005?    I'd like to install POS 2.0 on a SQL 2008 (SBS 2011) server, can I do that, uninstall SQL 2005 and reattach POS to the 2008 databases?

 

*This post is locked for comments

  • Suggested answer
    Andy Miller Profile Picture
    Andy Miller 870 on at
    RE: Can I run POS 2.0 on SQL 2008 instead of SQL 2005?

    We have been using the SQL Server 2008 R2 with Tools installation. It has worked great for us.

    Some considerations to take note of, when manually installing SQL 2008 R2, it does not install using the correct settings by default, you will have to enable TCP/IP and Named Pipes for this new instance. Also be sure to allow SQL Server through the windows firewall if you plan to use it on multiple registers. SQL Browser does need to be enabled and running. When installing, you must install using Mixed Mode, and create a new password for the 'sa' user.

    If you install SQL Server 2008 R2, and you also choose to skip the SQL 2005 installation during the RMS installer, you will not be able to run SQL scripts from the RMS Administrator screen because it requires the SQL 2005 Client tools. You can continue to skip the SQL 2005 installer, you will just want to install the SQL 2005 Backwards Compatibility which you can find on this link... (SQLServer2005_BC)

    www.microsoft.com/.../details.aspx

  • RE: Can I run POS 2.0 on SQL 2008 instead of SQL 2005?

    When you install 2008 I recommend doing it as a NEW instance (not an upgrade).  Give it its own instance name (Local\SQLexpress) and reference that in SO admin config.

  • gweigold Profile Picture
    gweigold 135 on at
    Re: Can I run POS 2.0 on SQL 2008 instead of SQL 2005?

    OK, how do I do that, since the install puts 2005 on the box.  Can 2005 and 2008 co-exist temporarily?

    Do I just detach the database from 2005 and attach it to 2008?

    Is there a FAQ or white paper on this?

  • Zakeer Hussain Profile Picture
    Zakeer Hussain 345 on at
    Re: Can I run POS 2.0 on SQL 2008 instead of SQL 2005?

    Yes you can do that.

    We have recently upgraded the SQL version to 2008 from 2005

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 Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

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,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,302 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans