topic ArcSDE and Sql Server 2008- SDElayer register in Data Management Questions

ArcSDE and Sql Server 2008- SDElayer register

SabitaTripathi — Wed, 07 Sep 2011 00:09:41 GMT

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

Re: ArcSDE and Sql Server 2008- SDElayer register

VinceAngelo — Wed, 07 Sep 2011 00:29:59 GMT

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

Re: ArcSDE and Sql Server 2008- SDElayer register

SabitaTripathi — Wed, 07 Sep 2011 16:29:04 GMT

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

Re: ArcSDE and Sql Server 2008- SDElayer register

VinceAngelo — Wed, 07 Sep 2011 18:39:45 GMT

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