Database Reference
In-Depth Information
▪ Turn on
Specify username and password (applies to all users)
if you want FileMaker
to automatically log in to the SQL database on everyone's behalf. When you do, you can
enter a calculation to determine either value, so you can hard-code a text value, automat-
ically use the current user's FileMaker account name (with the
Get(AccountName)
func-
tion) or any other mechanism you need.
▪ If you're using Microsoft Windows and Microsoft SQL Server, you can turn on
Use
Windows Authentication (Single Sign-on)
. This option lets FileMaker automatically
connect to the SQL database by using the Windows user name and password. Your data-
base administrator has to configure the Windows accounts properly for this setup to work
(you can find details in the FileMaker help by searching for “ODBC Single Sign-on”).
Also, you have to get the service principal name (SPN) from your database administrator.
NOTE
You may be wondering why you have to enter a user name and password here at all, since you
already typed them in when you created the ODBC data source. It turns out the ODBC system just
really wants that information so it can test your data source and ease configuration. It doesn't actu-
ally
use
that login info when you open the database.
In this case, turn on “Specify user name and password (applies to all users),” and type the
user name and password for your SQL database. Click OK to tell FileMaker you're done.
Click OK again in the Manage External Data Sources window to get back to your main data-
base window.
