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.
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.