Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / New Installation for S...
Microsoft Dynamics RMS (Archived)

New Installation for SQL server. Which OS should I choose?

(0) ShareShare
ReportReport
Posted on by SambaNoodles 5

Hi everyone.

My server computer which was running SQL server express 2005, finally died (Imotherboard failure).  It was running XP SP3.

Now I am planning to purchase a new computer to act as a server.  Reading through the forum threads, it appears as if Windows 10 is not a good idea.  Is windows 7 the best option, or should I attempt to run XP on top of new hardware?   I am tempted to continue to use XP since it worked so flawlessly for  all these years. 

If Windows 7 is the way to go?  And does it really matter if I am using Home Basic, Home Premium or Professional edition?

Should I use Sql Server Express 2008 R2 or will Sql Server Express 2005 work just fine on Windows 7?

FYI, I am running RMS Ver 2.0.0116

Any advice will be greatly appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: New Installation for SQL server. Which OS should I choose?

    in fact i faced this slow connection issue but when i was doing the work sheet 401 it take ages and it did't finished , so i do Re index and every thing going smooth after , i am sure about you issue may be it is because of client XP connection , or even the server that running windows 7

  • SambaNoodles Profile Picture
    SambaNoodles 5 on at
    RE: New Installation for SQL server. Which OS should I choose?

    Thanks for the response Osama.

    I ended up going with Windows 7 PRO SP1 on the server, running SQL 2008 R2 SP3.

    On the client side, I am *still* running XP PRO SP3, with SQL 2005 backward compatibility DMO objects installed.

    So far so good, everything seems work o.k., but connection to the database seems somewhat slower.   Do I need to reindex?

    Rgds,

    Samba

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: New Installation for SQL server. Which OS should I choose?

    Hi Samba

    in fact i am running a environment here in my company i can telling you about it may be it can help you , i have 2 servers running HQ server and Store operation , each of them installed on windows server 2012 R2 with SQL 2008 R2 SP2 , i have my POS machines running windows 7 Pro , for my laptop i am running window 10 pro and i have HQ manager and SO manager running without any problem , the version we are running here is 2.0.2019

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans