Hi,

A client of mine has an Windows 2008 Server which runs an SQL Server.

Because he doesn't have another machine and (Due To some reason, my client do not wish to mess with current SQL database structure),

so I will like to ins tall FM 11 runtime onto the same machine,

 

The runtime solution is to schedule login to SQL server to perform importing / filtering  and exporting data report.

 

My question is :...

Has someone ever done this and can it be done?

Possible for FM to login onto same machine to access SQL DB ?

Thanks!

 

Can they physically be installed on the same machine?  Pretty sure they can.  Is it a good idea: heck no.  An FMP runtime is a user-class piece of software and requires someone to be physically logged into the OS of the machine before it can be run.  That is not what you want on a server OS for the obvious security reasons.   So at the very least make sure the client understands that and explicitly agrees to this knowing the risks.

 

26 minutes ago, James WHL said:

Possible for FM to login onto same machine to access SQL DB ?

 

 

This I don't fully understand.  FM never logs into a machine itself.

Are you using ESS?  How do you want to access the SQL data?

 

9 hours ago, Wim Decorte said:

  9 hours ago, James WHL said:

Possible for FM to login onto same machine to access SQL DB ?

 

Sorry, I mean FM runtime login to SQL DB  onto the same machine.

 

I just recall the idea of FM runtime is to take network access away and be single-user, no open remote function available.

So,the answer to my question is = "Not Possible "

 

Thanks for reply Wim.