Topic: MS Sql on SME Server.

[tropicalview]

Hi everyone.

Is it possible to get a program using an MS sql server running on the SME server?
is there any MS SQL simulator avaiable on Linux?


Kind regards,

Hendrik

[tropicalview]

Does anybody know an english version of this:
http://forums.contribs.org/index.php?topic=34829.0
it seems they have the solution...

[cactus]

Hi everyone.

Is it possible to get a program using an MS sql server running on the SME server?
is there any MS SQL simulator avaiable on Linux?

It is possible to run any MS program on a linux machine as the architecture and associated function libraries differ day and night. Perhaps you can run it in a windows emulator like WINE, but you do not want to install this on a SME Server as this will probably give lots of security and configuration woes.

[cactus]

Does anybody know an english version of this:
http://forums.contribs.org/index.php?topic=34829.0
it seems they have the solution...

Nope, I do not speak Italian but the FreeTDS library is a library which makes it possible from linux machines to communicate with a MS SQL database server, it does not make it possible to run one on SME Server.

[p-jones]

tropicalview

When you refer to MS SQL are you refering to the full product or MSDE/SQLExpress ?

I have an application requiring MSDE. I have built a test box V7.2), installed VMWare as per the wiki then put XP Pro and MSDE and the application database on it.

Currently testing with two users and results are looking REAL good for both the SQL and the SME functions on the same box. The box is nothing too flash, 2.4GHz P4 , 2Gb RAM and  an 80Gb HDD. I know MS licences are involved but not another server box.

If this continues to stacks up as it has, I will almost certainly port it to a better box with heaps more RAM

I did a mountain of searching and reading and came to the conclusion this was really the only safe way of approaching the situation. I guess it is intentional that MS have a lot of proprietary features incorporated into their SQL systems, making licences inevitable.

[Stefano]

Hi everyone.

Is it possible to get a program using an MS sql server running on the SME server?
is there any MS SQL simulator avaiable on Linux?


Kind regards,

Hendrik

try to explain your problem, not the solution

I mean: why do you wish to install ms sql server on sme? do you really need ms sql?

Ciao

Stefano

[tropicalview]

Hi nenonano,

Indeed I would like to run the MS SQL service on the SME box.

Why? In our organization we have 2 networks, one for students and one for the administration.

The student network changed from ms windows server to SME Server. and the result is just great.
so we would like to put the other one also on SME.

The problem is that they have a program running with a MS Sql database.
I'm not sure if that one can change to the mysql, but if not i have to search an other way to get MS windows out....

[Stefano]

The problem is that they have a program running with a MS Sql database.
I'm not sure if that one can change to the mysql, but if not i have to search an other way to get MS windows out....

try to ask the developer if it can be migrated to mysql/postgres..

if not, there's no solution..

my 2c

ciao
Stefano

[cactus]

The problem is that they have a program running with a MS Sql database.
I'm not sure if that one can change to the mysql, but if not i have to search an other way to get MS windows out....

What is the problem with a separate MS SQL server in the network apart from license fees?