I have and it also works in mapserver but only while using Apache as the server.
-----Original Message----- From: mapserver-users [mailto:[email protected]] On Behalf Of Stephen Woodbridge Sent: Thursday, October 13, 2016 10:31 AM To: [email protected] Subject: Re: [mapserver-users] MapServer IIS7 Have you tried to connect to the sql server outside of mapserver using the same credentials? ie: make sure the the mapserver user is a valid user to do the connection with. -Steve W On 10/13/2016 10:18 AM, Vogt, Robert (RCIS) wrote: > This is the full error... > 502 - Web server received an invalid response while acting as a gateway or > proxy server. > There is a problem with the page you are looking for, and it cannot be > displayed. When the Web server (while acting as a gateway or proxy) contacted > the upstream content server, it received an invalid response from the content > server. > > -----Original Message----- > From: mapserver-users [mailto:[email protected]] > On Behalf Of Vogt, Robert (RCIS) > Sent: Thursday, October 13, 2016 10:12 AM > To: [email protected] > Subject: [mapserver-users] MapServer IIS7 > > Good morning, > > I originally set up MapServer with WS4W and Apache server...I now have a > requirement to put this on the same domain as our application which runs in > IIS7. > > I have created the site and pointed my application at it and the results are > mixed... > > Map files that are pointed at lizardtech for their source are working but map > files that are pointed at SQL for their source are giving a 502(bad gateway) > error. > > All map files worked when served through Apache, has anyone run into this or > know what I should look at to fix it? > > Your help is greatly appreciated!! > > ******************************************* > ******** Map File *************************** > > MAP > IMAGETYPE PNG24 > CONFIG "PROJ_LIB" "E:/RCIS/Web/MapServerDlls/projlib" > SIZE 256 256 > FONTSET "E:/RCIS/Web/MapServerDlls/content/fontset.txt" > IMAGECOLOR 255 255 255 > TRANSPARENT ON > PROJECTION > "init=epsg:4326" > END > WEB > METADATA > "wms_title" "sections" > "wms_enable_request" "*" > END > END > LAYER > NAME "States" > TYPE POLYGON > STATUS ON > LABELCACHE ON > PROCESSING 'LABEL_NO_CLIP=1' > CONNECTIONTYPE PLUGIN > PLUGIN "msplugin_mssql2008.dll" > CONNECTION "OurConnectionString" > DATA "shape(geography),ST_NAME_MC from NATIONALDB.sde.STATES > USING INDEX STATES_SIDX USING UNIQUE STATES_ID USING SRID=4269" > LABELITEM "ST_NAME_MC" > PROCESSING "CLOSE_CONNECTION=DEFER" > CLASS > STYLE > OUTLINECOLOR 000 153 000 > WIDTH 3 > END > LABEL > COLOR 000 153 000 > TYPE TRUETYPE > FONT Arial > SIZE 12 > ANTIALIAS FALSE > POSITION AUTO > PARTIALS FALSE > > END > END > PROJECTION > "init=epsg:4326" > END > END > END > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
