ArcGIS 9.3.1 to ArcSDE 10 Connection Error

Asked By Hall Allen 80 points N/A Posted on - 10/22/2012

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

• Status: Open
• Question Views: 2318
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By Linknya Jean 0 points N/A #193259

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';
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.

About Linknya Jean

Questions
2

Answers
107

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: Software Others