SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SQL 2005 express on different OSs
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wpflum
Starting Member

USA
4 Posts

Posted - 08/07/2013 :  19:01:20  Show Profile  Reply with Quote
Can anyone tell me if there if a difference between running an SQL express server on a windows 2000 pro sp4 system and on an Xp pro system? I know it's kinda strange but it's a licensing issue where the current "server" is an XP Pro pc running 2005 SQL express for a couple of networked programs that I need to move to a virtual platform but the license is oem and won't let me virtualize it. I do have a win2k license that I can use and have a test system installed with the SQL server and is working but I'm concerned that I might run into problems later on going from XP to W2k even though the server software is the same.

Thoughts??

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 08/08/2013 :  08:09:14  Show Profile  Visit robvolk's Homepage  Reply with Quote
No problems, SQL Express will work the same regardless of operating system. Other editions of SQL Server would be affected however.
Go to Top of Page

wpflum
Starting Member

USA
4 Posts

Posted - 08/08/2013 :  09:43:41  Show Profile  Reply with Quote
Thanks, I kinda thought so but was worried that something might be subtly different, like number of connections allowed or the way a sort might work between different OS’s. We originally had to have the XP pro system mainly due to having to run the software associated with the databases on it also but I've discovered since then that we actually do not need to have the software on the sql server and that was just something the original installer did to make it easy for him to set up the database connections.

quote:
Originally posted by robvolk

No problems, SQL Express will work the same regardless of operating system. Other editions of SQL Server would be affected however.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000