N/APosted on - 10/22/2012
Today I successfully installed ArcSDE 10 on my system, but unfortunately when I tried to connect it with the ArcGIS catalogue 9.3.1, it failed. It failed to connect to the server.
I have attached the screenshot of the error below:
The message states:
Failed to connect to database.
This release of the GeoDatabase is either invalid or out of date.
DBMS table not found [sde.sde.GDB_Release]
If anyone can please shed some light on how to solve this issue, I'll be really thankful.
I have tried hard but now I am at my wits end.
Waiting for your helpful suggestions
ArcGIS 9.3.1 to ArcSDE 10 Connection Error
Hi Hall Allen,
Thanks for sharing your problem with us, this error is encountered when the Common Language Runtime (CLR) is disabled in the SQL server. XML cannot be successfully queried . To solve this problem just follow the following steps:
1. On the SQL server instance run the following script
EXEC sp_configure 'show advanced options' , '1';
— Disable Lightweight Pooling
exec sp_configure 'lightweight pooling', 0;
— Enable CLR
EXEC sp_configure 'clr enabled' , '1'
2. After entering the above script restart the SQL server instance.
3. Now connect to the geodatabase using ArcGIS.
I hope this will solve your problem.