From http://www.gdal.org/drv_mssqlspatial.html and the linked page about ODBC driver connection string (http://msdn.microsoft.com/en-us/library/ms130822.aspx) it seems you need to use "UID" and "PWD" instead of "username" and "password"
HTH > -----Ursprüngliche Nachricht----- > Von: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] Im > Auftrag von Vogt, Robert (RCIS) > Gesendet: Dienstag, 1. November 2016 14:36 > An: mapserver-users@lists.osgeo.org > Betreff: [mapserver-users] msOGRFileOpen > > Good morning, > > I have successfully tested my connection string with "ogrinfo", now > however when I try to use that connection string in my MapFile > I receive this error... > > msDrawMap(): Image handling error. Failed to draw layer named 'myLayer'. > msOGRFileOpen(): OGR error. Open failed for OGR connection in layer > `myLayer'. Unable to initialize connection to the server for > MSSQL:Database=mydatabase;Server=myServer;user=myUser;password=XXXXXXXXXXX > XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX SQL Server Driver][SQL > Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' > > Any help is greatly appreciated!! > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users