Entry for SDE instance not found in services file

[tmelhuish@…]

I’m getting the following error when trying to connect to SDE from mapserver:

Error in msSDELayerOpen():SE_connection_create(): Entry for SDE instance not
found in services file. (-102)

I have read the documentation and search the web to try to figure out the
problem. Here is my configuration.

SDE 91 is running with Microsoft SQL on XP (IP address 10.1.3.30)
Mapserver 4.10.0 is running on Redhhat 9.0 ( I’m able to read a DB table from
Postgis and display fine)

Services file on Microsoft server under c:\windows\system32\drivers\etc\services
( last entries)
directplaysrvr  		47624/udp            #Direct Play Server
esri_sde_johnston_vector	5151/tcp		#ArcSDE for SqlServer
esri_sde_johnston_raster	5152/tcp		#ArcSDE for SqlServer
esri_sde_test_db		5153/tcp		#ArcSDE for SqlServer

The database is called “test_db” and the table is “test_db_owner.CITY_LIMITS”
that I’m trying to read

Here is the layer in the mapfile:

LAYER
    NAME         citylimits
    TYPE         POLYGON
       STATUS ON
    CONNECTION "10.1.3.30,esri_sde_test_db,test_db,webusr,xxx"
    CONNECTIONTYPE SDE
    DATA "test_db.test_db_owner.CITY_LIMITS,SHAPE,SDE.DEFAULT"
    TEMPLATE "templateMS.html"
    CLASS
      NAME "City Limits"
      STYLE
         OUTLINECOLOR 225 90 180
      END
    END
END

Please let me know if you need any further information
Thanks for your help,
Tom

[hobu]

try connecting directly to the port
port:5153 instead of esri_sde_test_db

[tmelhuish@…]

Thanks, I got farther by putting in the port:5153 and changing the IP address to
the actual server name. The IP address doesn't work for some reason. Now I get
the following error:

Error in msSDELayerOpen():SE_connection_create(): Bad login user. (-9)

I can connect to Microsoft SQL with this user & password. Is their a place I
need to give this user & password permission to connect to SDE? I can ask the
SDE admin in the morning since I'm not familiar with SDE.

Tom

[tmelhuish@…]

I resolved the user id and it's now working. Thanks for your help.