AnsweredAssumed Answered

FM Pro 10 ODBC Connection to MS SQL Single Sign On via Active Directory

Question asked by T on Mar 24, 2010
Latest reply on Apr 2, 2010 by TSGal

Summary

FM Pro 10 ODBC Connection to MS SQL Single Sign On via Active Directory

Description of the issue

There has been no response to my message with the same subject posted on the forum (quoted below).  Does this mean that the feature doesn't work, or that it's so obvious no one wants to comment? - TomSituation:(1) FileMakerPro 10 (not server)(2) Active Directory(3) MS SQL Server(4) Trying to configure a datasource in FM using ODBC to connect to MS SQL Server.(5) Works fine when I specify a username and password(6) Does not work when I try to use Use Windows Authentication (Single Sign-0n)(7) In particular, SPN: MSSQLSvc/123.456.789.123:1433 does not work. (8) MS SQL is running under the built-in Network login, which is supposed to register an SPN automatically with Active Directory.(9) MS SQL has TCP connections enabled(10) I can't ask the Network Manager, because that's me.

Outcomes