Search the Community
Showing results for tags 'sql server'.
Found 4 results
Hello, I'm planning to use MirrorSync to sync my FM Webdirect database to a SQL Server, one-way sync. Basically, this is for reporting purposes. But in all of the 360 Works help docs, I don't see even one guide/screenshot/anything on how to setup the SQL Server. What information is required, how does MirrorSync authenticate to SQL Server, what specific permissions does it need, etc... nothing at all. Has anyone done this who can provide some information? I work for a large organization and need to know how to setup this SQL Server before jumping into configuration. (Primarily authentication, we prefer windows authentication so will MirrorSync connect to SQL Server as the windows service account that is running the FM Server? Or does it need a SQL account? And what permissions are required?) Thank you! And 360 Works, please add this to your help docs!! Andrew
We have one Microsoft SQL Server with two different databases (Test and Production) on it. We connect to these databases with FileMaker Pro 14 with an external data source (ODBC). We have copied the Production FileMaker database to the Test database and changed the DSN settings (which has different credentials for Production and the Test environment!). The new Test environment is still pointing to the SQL Server Production database. How can we achieve that the FileMaker Test database points to the SQL Server Test database and the FileMaker Production database to the SQL Server Production database? The FileMaker Test and Production databases are installed on the same server.
I'm looking for some sort of instruction on setting up a sync between Microsoft SQL Server and a FM Go solution on iPad. I spoke with someone from 360works last summer. What I remember from that conversation was that it was fairly simple. First setup the sync on Filemaker Server, then somehow port it over to SQL Server. But after going through the Filemaker Server setup, it just doesn't seem apparent to me how to follow through with the next steps. Also related to this, I remember tinkering with this last summer and ran into a roadblock. We are running a fairly old version of Microsoft SQL Server and apparently some driver was missing from MirrorSync that would allow it to communicate with my older SQL Server. (we are running MS SqlServer 2000 - 8.00.2039) Does this ring a bell with anyone? Because of other applications running on this server, we cannot update it at this time.
I'm a relative newcomer to FM, so please excuse me if this question has been addressed before (and point me to it :-) ) Our setup is a SQL server backend server housing our main application data, which we'd like to sync with FM running on iPads. From going through the MirrorSync documentation, I'm still unclear as to whether the you can sync directly from a FM Go (iPad) instance directly to SQL server using Mirror Sync, or whether you always need FM Server to be in the setup? If it's a case that FM Server is always needed, does that mean that you need for e.g. 40users : 40 FMGo -> FM Server licenses, and 1 FM server <-> SQL Server license? Thanks Tom