I am trying to change the FME Server database from the default Postgres to SQL Server. I have followed the instructions in this link: http://docs.safe.com/fme/2018.1/html/FME_Server_Documentation/Content/AdminGuide/Changing_Database_Provider.htm
but after everything is done, I cannot login as admin anymore. I get the login page to come up, and I can confirm that connectivity is there to SQL Server, but it won't accept my password for admin anymore.
+26
The general FME Server Troubleshooting steps are here: https://knowledge.safe.com/articles/540/fme-server-troubleshooting-guide.html
Without having more information it's hard to say what's going on. Some initial things to check:
The backup and restore process did fill the SQL Server database correctly.
I have confirmed that FME server is connecting with the SQL Server database.
I did shutdown the Postgresql database and remove the dependency from the Core service. It really is as if the password is not recognized for the admin anymore. When i repoint back to the Postgresql database, it works fine again.
+1
Hello,
I encountered a similar problem, we’ve set up database in SQL server following steps here:
Next we are trying to change our FME Server to use the SQL server instead of default postgres. We’ve copied over data from postgres to sql server and performed steps here:
https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Changing_Database_Provider.htm
https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Encrypt-FME-Flow-Database-Password.htm
fmeDatabaseConfig.txt
DB_TYPE=sqlserver
DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
DB_JDBC_URL=jdbc:sqlserver://<SQLSERVERNAME>;databaseName=fmeserver
DB_USERNAME=fmeserver
DB_PASSWORD=fme_enc:p@$$word
DB_CONNECT_EXPIRY=60
DB_SQLSTMTS_PATH=E:/FMEServer/Server/database
After restarting services, removing dependency and stopping FME Database service, when launching the application, it doesn’t let me login as “Admin” and if I try to login as a different user, I get an error but if I try not filling in the password it lets me through but I don’t see anything.
I am investigating logs and maybe if I missed any step but hoping for any help or insight on this?
Thank you!
+11
For the DB_PASSWORD - put in the plan text password (not fme_enc:), just the password characters and restart FME Flow. Test it with this and if that works, you can then encrypt the plain text password after the fact using the instructions found here.
If you are still having issues after this perhaps file a support case.
+1
+1
Hi everyone, this might not be applicable to every scenario but thought I’d share results of my scenario:
Creating the SQL database and user: https://docs.safe.com/fme/2021.2/html/FME_Server_Documentation/AdminGuide/Configure-FME-Server-Database-on-Separate_Server-2-Tier.htm
Changing the FME Server database: https://docs.safe.com/fme/2021.2/html/FME_Server_Documentation/AdminGuide/Changing_Database_Provider.htm
FME Version: FME Server 2021.2.2
Solution that worked for us: We setup a new server and a fresh SQL server database instance and followed the FME documentation.
Quick summary:
DB_TYPE=sqlserver DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver DB_JDBC_URL=jdbc:sqlserver://sqlservername;port=1433;databaseName=fmeserver DB_USERNAME=fmeserver DB_PASSWORD=password DB_CONNECT_EXPIRY=60 DB_SQLSTMTS_PATH=C:/FMEServer/Server/database
Navigate and check that all contents are loaded correctly (for us, the Licensing & Engines part were the only ones not transferred from backup and we may have to set it up separately)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.