Tell me more ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.
up vote 3 down vote favorite
1

My company develops software with two sides: client and server. I've installed Microsoft SQL Server on Windows and am running the client side on Ubuntu with some configuration.

But I'm wondering: is there a way to run Ubuntu as the server instead and install SQL Server on it?

share|improve this question

1 Answer

up vote 2 down vote accepted

You can certainly try the approach I will outline below but I don't know if anyone has tried it successfully.

  1. Install virtualization software on your Ubuntu machine (VMWare, Xen, VirtualBox).
  2. Install Microsoft Windows Server in the virtual machine.
  3. Install MS SQL Server on the newly installed Windows Server.

I don't know if any other way would work but people can correct me the MS SQL Server from what I can remember actually relies on Licensing for Microsoft Windows Server. On top of this SQLServer is a pretty bad resource hog so normally organizations try to segregate it from running with any other applications on it's own cluster or server.

One thing that I would question is why not try Sybase as the backend? The connectivity from Linux to SQLServer and Sybase can go through FreeTDS, which would look identical to your client software.

share|improve this answer
1  
Well this answer my question, thanks. I do not manage the database here we have a whole bunch of programmers, i'm working on the client side and we install both server AND client. I'm currently virtuallizing an ubuntu on my windows machine to run a bunch of test to see if ubuntu would work. With client yes. On server....not so well, since SQL would never work on Linux. Thanks for your answer – Jester Dec 27 '11 at 20:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.