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
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)
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.
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?
Yes you can do that.
We have recently upgraded the SQL version to 2008 from 2005
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,302 Most Valuable Professional
nmaenpaa 101,156