Skip to main content
Archived

FME Server 2016.1: MSSQL Server Repository with Windows authentication

Related products:FME Flow
  • April 28, 2016
  • 2 replies
  • 62 views
tino
Supporter
Forum|alt.badge.img+29

If you want to access your FME Server repository on a MSSQL database via windows (integrated authentication) follow these steps:

  1. Follow the normal installation process for FME Server in combination with a MSSQL database
  2. Check if everything is working fine
  3. Give the designated Windows domain user db_owner privileges to the database "fmeserver"
  4. Stop FME Server
  5. Change FME Server Core service properties to run under the windows user
  6. Change the config in Server fmeServerConfig.txt" (the user and pw entry are meaningless) 
  7. 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

  8. Copy "<FMEServerHome>Serverfmesqljdbc_auth.dll" to "<FMEServerHome>Serverlibfmeutilsqljdbc_auth.dll"

  9. Restart FME Server Services

  10. (Optional) Delete the default "fmeserver" database user

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

steveatsafe
Safer
Forum|alt.badge.img+15

Thanks for sharing this Tino! I'm wondering if a code adjustment could avoid step 8...

SteveatSafe
H
Forum|alt.badge.img+2

Update

In FME 2020+ there is a second configuration file that stores the database credentials, \\Server\\ fmeServerWebApplicationConfig.txt.

You will also need to update the DB_JDBC_URL in this file to include 'integratedSecurity=true' and change the FME Server Application Service to run under the Windows user, or else you will encounter the issues recorded in this article.

Community Stats

32,750
Posts
124,202
Replies
41,252
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.