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:

• Did the backup and restore process fill the SQL Server database correctly?
• Is FME Server connecting to the SQL Server database?
• Did you shut down the Postgres database?

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.

Hello,

I encountered a similar problem, we’ve set up database in SQL server following steps here:

https://docs.safe.com/fme/html/FME-Flow/AdminGuide/Configure-FME-Flow-Database-on-Separate_Server-Fault-Tolerance.htm

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!

@crstnaiw 
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.

@steveatsafe Thanks for your response! I tried that too and now able to get in but I did have to reset the Admin password first. 

Hi everyone, this might not be applicable to every scenario but thought I’d share results of my scenario:

• What worked for us is to change the database to sql during a fresh installation.
• It looks like the steps in documentation for changing database did not work for us since our FME server had a lot of custom data already.

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:

1. Took a backup from existing FME Server instance from the Web Interface (Admin > Backup & Restore > Backup)

   

    

2. Did a fresh install of FME Server in a new server
3. Recreated the fmeserver db and user following the scripts from FMEServer\Server\database\sqlserver
4. Changed the DB connection in config file and restarted FME (only changed the server name and password)
   1. 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

   2. 

5. Launch the FME Server Web Interface and login as admin with default password. You will be prompted to change the password 

   

    

6. Restored the backup from existing FME Server instance from the Web Interface (Admin > Backup & Restore > Restore) - Remember to tick the ‘Overwrite Existing Items’

   

   

    

7. 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)