One of my clients use a software product that is "upgrading" and will shortly utilize micro$oft SQL server 2005. Currently the clients are XP on older machines with the database residing on a Samba / CentOS server and this works very well. Question: Does anyone run SQL server from XP in a virtualbox on CentOS? Any other configuration that works on a linux server? I do not want to have to buy another server grade machine just for this application. Thanks for your insight. Rob -------------- next part -------------- A non-text attachment was scrubbed... Name: rkampen.vcf Type: text/x-vcard Size: 121 bytes Desc: not available URL: <http://lists.centos.org/pipermail/centos/attachments/20090908/8439bd04/attachment.vcf>
> -----Original Message----- > From: centos-bounces at centos.org > [mailto:centos-bounces at centos.org] On Behalf Of Rob Kampen > Sent: Tuesday, September 08, 2009 11:56 > To: CentOS mailing list > Subject: [CentOS] SQL Server 2005 and CentOS? > > One of my clients use a software product that is "upgrading" > and will shortly utilize micro$oft SQL server 2005. > Currently the clients are XP on older machines with the > database residing on a Samba / CentOS server and this works very well. > Question: Does anyone run SQL server from XP in a virtualbox > on CentOS?We have vmware server (1.x & 2.x) running Centos 4.x. Several of those are running windows services, including SQL Server and their desktop engine too. Ram ranges from 64MB (w2k/msde) to 2048MB (w2k3/sqlserver v?)> Any other configuration that works on a linux server? > I do not want to have to buy another server grade machine > just for this application. > Thanks for your insight. > Rob >-- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Principal Consultant 10 West 24th Street #100 - - +1 (443) 269-1555 x333 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is copyright PD Inc, subject to license 20080407P00.
>Question: Does anyone run SQL server from XP in a virtualbox on CentOS? >Any other configuration that works on a linux server? >I do not want to have to buy another server grade machine just for this >application.XP has a tcp connection limit, so unless you have <10 users that won't work. I sure hope your DB is not IO intensive, that doesn't sound like a rock solid setup really... You need to also pay *SERIOUS* attention to vb's bluff on writeback to the underlying OS or if anything goes wrong, you *will* be left with a corrupt block device. You can tune this parameter. Personally I would use vmware server if had to do this, but that's just me... jlc
On Tue, Sep 8, 2009 at 11:56 AM, Rob Kampen<rkampen at kampensonline.com> wrote:> One of my clients use a software product that is "upgrading" and will > shortly utilize micro$oft SQL server 2005. > Currently the clients are XP on older machines with the database residing on > a Samba / CentOS server and this works very well. > Question: Does anyone run SQL server from XP in a virtualbox on CentOS? > Any other configuration that works on a linux server? > I do not want to have to buy another server grade machine just for this > application.What about Xen or Vmware virtual server running on the CentOS box? Do they need the full SQL 2005 or will the Desktop/Developer or free edition do? What about converting the CentOS box to VMware ESXi 4 with a CentOS VM and a SQL 2005 VM? If the CentOS box is a good server grade machine with plenty of CPU and RAM it would perform well with ESXi, then you can do parallel upgrades of the VMs without additional hardware or downtime. -Ross
Rob Kampen wrote:> One of my clients use a software product that is "upgrading" and will > shortly utilize micro$oft SQL server 2005. > Currently the clients are XP on older machines with the database > residing on a Samba / CentOS server and this works very well. > Question: Does anyone run SQL server from XP in a virtualbox on CentOS? > Any other configuration that works on a linux server? > I do not want to have to buy another server grade machine just for > this application.SQL Server only runs on Windows SERVER OS's. on a desktop OS like XP, youc an only run the 'lite' version aka MSDE or SQL Express depending on which version, and this only allows a very few database connections, and is mostly suited for standalone single user applications and software development. SQL Server has fairly expensive licensing per user too. I would NOT virtualize a SQL database server, they have intensive disk IO I/O requirements. also don't run a database on a network mounted file system (samba, NAS, etc) for the same reason.