ArcSDE and Sql Server 2008- SDElayer register

[SabitaTripathi]

Hi,

I am using the command below to register a table in Sql server 2008 with the geometry column as Arcsde layer.

sdelayer -o register -l SpatialTable,GeomCol1 -e p -t geometry -R 0 -C id,SDE -i NSESRIDBP01VM -u ArcGIS -p XXXXXXX -D XXXXXX


But it always returns the error:
- Entry for SDE instance not found in service file <-102>.
- Cannot get configuration information


I'm using ArcSDE 10.0 with SQL Server 2008 R2. Any idea why I am getting that error.
Thanks,
Sabita

[VinceAngelo]

If there isn't an entry in the ...\etc\services file which corresponds to "NSESRIDBP01VM", then
the error means exactly what it says.

Given the the "instance" ends in VM, I suspect you crossed the "server" and "port" flags.

Thanks to the single database model, the database ("-D") parameter isn't really used in
application server connects anymore.

If you review the meanings of the "-s", "-i", and "-D" flags I expect you'll be able to find the
right parameter combination.

- V

[SabitaTripathi]

Thanks for the reply!

I got the layer to register successfully but now the problem is ArcMap/ArcCatalog crashes when I add the layer.

Any idea what may be causing this?

Sabita

[VinceAngelo]

After checking the System Requirements to be sure you're running a supported service
pack of  SQL-Server, and validating that ArcSDE is properly interpreting the columns with
'sdetable -o describe', you'll probably want to validate the topology in your geometry
columns.  From there the next step is Tech Support.

- V