Enabling ODBC data source single sign-on (Windows only)If you work with database files hosted by FileMaker Pro or FileMaker Server that access ODBC data from Microsoft SQL Server, you can configure the host computer to enable single sign-on (SSO). ODBC data source single sign-on permits a client to use one Windows-authenticated login to access ODBC data in shared files.Important Before you can enable ODBC data source single sign-on, your Windows domain administrator must:
• configure the Account is trusted for delegation security setting for your Windows user account on the client.
• configure the Trust this user for delegation and Use Kerberos only security settings for your Windows user account on the host computer.
• enable the Impersonate a client after authentication privilege for your Windows user account on the host computer.
•
• configure Microsoft SQL Server to use Windows authentication.
1.
3. For Authentication, select Use Windows Authentication (Single Sign-on), enter the SPN (Service Principal Name), and click OK.Note Your Windows domain administrator must provide the SPN, which is generally in this format: MSSQLSvc/<fully qualified domain name>:<port>For example: MSSQLSvc/sql2005.filemaker.com:1433
• In order to open a hosted database, the administrator must configure the FileMaker Server service to log in as the privileged user account. For more information, see FileMaker Server Getting Started Guide.