DSN Connection to MS SQL

Discussion created by msawyer on Feb 23, 2014
Latest reply on Feb 25, 2014 by LSNOVER



Can either the ExecuteSQL function or Execute SQL script step be used to pass a user name and password to a DSN connection with MS SQL.


I cannot get the ESS connection to stop prompting for a user name and password. It has been set up correctly in the FM file and the DSN is connecting and tested.


Server is 2008 R2 64 bit, FMS 12.05 and FMS13 clients.


If possible would appreciate some guidance