ArcGIS 9.3.1 to ArcSDE 10 Connection Error

Asked By 80 points N/A Posted on -
qa-featured

Hello

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

Regards

SHARE
Answered By 0 points N/A #193259

ArcGIS 9.3.1 to ArcSDE 10 Connection Error

qa-featured

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';
GO
RECONFIGURE;
GO
— Disable Lightweight Pooling
exec sp_configure 'lightweight pooling', 0;
GO
RECONFIGURE;
GO
— Enable CLR
EXEC sp_configure 'clr enabled' , '1'
GO
RECONFIGURE;
GO

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.

Thanks.

Login/Register to Answer

Related Questions