MSSQL on Linux?

spider99 · 05-17-2010, 06:05 PM

I need to be using MSSQL in Linux but if i used virtualization so i could use the MSSQL on a Windows system would the sources and programs of the Linux system be able to connect through to the MSSQL on the Windows system and vice versa without any problems?

kbp · 05-17-2010, 07:17 PM

The short answer would be yes assuming you're encapsulating the whole OS in a virtual machine.

cheers

spider99 · 05-17-2010, 11:29 PM

One will be the server(linux) and the other (MSSQL) will be on a vm on the server(linux), so again there should be no issues with the server being able to access the sql sources on the vm and vice versa?

linuxlover.chaitanya · 05-18-2010, 07:01 AM

You would need to install Windows as guest under VM to install MS SQL. And if you do not want windows, My SQL or PostgreSQL could do your job.
But if you must, then you will need to have complete OS as guest under VM before you can install MS SQL.

HasC · 05-18-2010, 07:43 AM

Just in case, let's clarify some concepts:

MSSQL *will not* run on Linux. It only runs on Windows (and maybe another propietary OS, AFAIK)
Said that, you could use virtualization, and run *Windows inside of Linux* - A virtual machine with Windows and MS SQL installed

Quote:

Originally Posted by spider99

One will be the server(linux) and the other (MSSQL) will be on a vm on the server(linux), so again there should be no issues with the server being able to access the sql sources on the vm and vice versa?

¿Can you "access the sql sources" if you have a "real" (physical) network with one physical Windows machine and one physical Linux machine? Well, make the net and the Win machine virtual, and it will be the same thing (if you've configured your virtual network properly, of course)

kbp · 05-18-2010, 09:23 AM

No issues, as far as they're concerned, they're 2 distinct machines that can communicate over a network