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.
+25
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
