topic Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494 in Data Management Questions

Unable to start sde service: init_DB DB_instance_open_as_dba: -494

RajeshAyyalasomayajula — Fri, 15 Jul 2011 14:35:26 GMT

Hi,

I installed ArcSDE 10.0. I restored a SQL server database from a back up. And ran the post install steps. I see the Windows service but when I try to start it, it woldnt start. Windows gives me a general error message which states something like "This service was started but shutdown. Some services shutdown if they dont have any work to do" . I know it seems funny but something along that lines.
In the sde.log file, i see the following message:
init_DB DB_instance_open_as_dba: -494

I searched through the forums and did all the re-synch of the sde user and login. I ran all the stored procedures to fix the sde user and login issue. Still the same error.
Has anyone encountered this issue? If so , could you please post the resolution?

Thanks

Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494

RajeshAyyalasomayajula — Sat, 16 Jul 2011 19:57:40 GMT

Anyone please?

Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494

RajeshAyyalasomayajula — Mon, 18 Jul 2011 13:03:00 GMT

Anyone please?

Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494

ShannonShields — Tue, 19 Jul 2011 20:23:48 GMT

The return code -494 means unsupported database version. What version of SQL Server are you using? What about the version of the database that you've restored?

-Shannon

Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494

RajeshAyyalasomayajula — Tue, 19 Jul 2011 20:27:10 GMT

Thanks for the reply.

I am using a SQL 2000 database and ArcSDE 10.0. Are these not compatible?

Actually this SDE database was working on a different machine. I did a backup and then restored onto the machine that has the newer ArcSDE/ArcInfo software installed( 10.0 ). Now I am not able to create an SDE service.

Any solutions\resolutions?

Much appreciated.

THanks

Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494

ShannonShields — Tue, 19 Jul 2011 22:20:23 GMT

No, SQL Server 2000 is not supported with ArcGIS 10.
The system requirements for SQL Server & ArcGIS 10 are here: http://resources.arcgis.com/content/arcsde/10.0/sql-server-system-requirements

Information on upgrading a SQL Server geodatabase can be found here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q000000m6000000.htm

You can restore a database from an older version of SQL Server onto a newer instance (2005 or 2008), but you must change the database compatibility level after you do so. In Management Studio, after restoring the database, right-click the database & choose Properties. Select the Options page and for Compatibility Level select the one that matches the version of SQL Server you are using (90 for 2005 or 100 for 2008).

Once SQL Server has been upgraded, the database restored & the compatibility level changed you can proceed with the rest of your upgrade.

-Shannon

Re: Unable to start sde service: init_DB DB_instance_open_as_dba: -494

RajeshAyyalasomayajula — Thu, 21 Jul 2011 17:46:30 GMT

I installed a SQLServer 2008 R2 and restored my old SQLServer2000 sde database, changed the compatibility level to 100 and when I tried to create the sde service, it still fails to start.

I have the following error message sde_esri_sde log file:

Connected to instance . . .
Run the Upgrade Geodatabase tool to upgrade this instance.
Refer ArcSDE installation guide for instructions.

So I did some search and tried to upgrade the databse using a direct connection from ArcCatalog on a different machine. I think I did give all correct parameters, but it still fails with the follwoing message:
Failed to connect to the specified server
DBMS table not found..

Any ideas?

THanks