Skip to main content
Question

Unable to create a Database Connection in FME Server using Windows Authentication (for SQL Server)

  • August 16, 2019
  • 3 replies
  • 152 views

agelfert
Contributor
Forum|alt.badge.img+8

Trying to make my life easier by setting up some Database connections in FME Server to help with updating workspaces, as I'm having to repoint them to a new SQL Server instance. So I'm trying to set up a named SQL Server connection using Windows Authentication. As expected, user and password fields are greyed out. But when I click on "OK", I'm prompted "PASSWORD is required". What am I doing wrong? Bug?

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.

3 replies

Forum|alt.badge.img+2

Hi @agelfert,

Thank you for reporting this issue. I would agree this is a bug, until fixed I think you will need to create your Database Connections in FME Desktop and then publish them up to FME Server (Option 2 here).

My apologies for any inconvenience this may cause. I have filed FMESERVER-13360 and will update this post when there is a resolution.


agelfert
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • August 19, 2019

Hi @agelfert,

Thank you for reporting this issue. I would agree this is a bug, until fixed I think you will need to create your Database Connections in FME Desktop and then publish them up to FME Server (Option 2 here).

My apologies for any inconvenience this may cause. I have filed FMESERVER-13360 and will update this post when there is a resolution.

Ok, Holly, thanks for the heads up. I'll have to do it via Desktop. Let me know when it's going to be fixed.


Forum|alt.badge.img+2

Ok, Holly, thanks for the heads up. I'll have to do it via Desktop. Let me know when it's going to be fixed.

Hi @agelfert,

Just to let you know this has been fixed for 2019.2.