If you want to access your FME Server repository on a MSSQL database via windows (integrated authentication) follow these steps:
- Follow the normal installation process for FME Server in combination with a MSSQL database
- Check if everything is working fine
- Give the designated Windows domain user db_owner privileges to the database "fmeserver"
- Stop FME Server
- Change FME Server Core service properties to run under the windows user
- Change the config in Server fmeServerConfig.txt" (the user and pw entry are meaningless)
DB_TYPE=sqlserver DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver DB_JDBC_URL=jdbc:sqlserver://localhost:1433;databaseName=fmeserver;integratedSecurity=true DB_USERNAME=fmeserver DB_PASSWORD=$FME$1ser$ver DB_CONNECT_EXPIRY=60 DB_SQLSTMTS_PATH=C:/bin/FMEServer/Server/database
-
Copy "<FMEServerHome>Serverfmesqljdbc_auth.dll" to "<FMEServerHome>Serverlibfmeutilsqljdbc_auth.dll"
-
Restart FME Server Services
-
(Optional) Delete the default "fmeserver" database user
