topic Re: Entry for SDE instance not found in services file in Data Management Questions

Entry for SDE instance not found in services file

NormZastre — Tue, 07 Sep 2010 20:21:07 GMT

I have recently installed version 10, and would like to use the personal version of SDE. I have installed sqlexpress via the installation wizard which installed SDE. Now when I try to "Add Spatial Database connection" however I get the following error. "Entry for SDE instance not found in services file".

Windows 7 x64

Is another step required?

Please see the attached screen shot

Re: Entry for SDE instance not found in services file

VipulBhatia — Tue, 07 Sep 2010 20:34:29 GMT

Connecting to a geodatabase in SQL Server Express

http://help.arcgis.com/en/arcgisdesktop/10.0/help/00sn/00sn00000008000000.htm

Please refer the following help topic.

Re: Entry for SDE instance not found in services file

NormZastre — Tue, 07 Sep 2010 20:52:40 GMT

Thanks for the prompt response. I believe I am getting closer...

Now I am getting the following error..

Failed to connect to database.
This release of the GeoDatabase is either invalid or out of date.
DBMS table not found [aa.sde.GDB_Release]

Re: Entry for SDE instance not found in services file

KimPeter — Tue, 07 Sep 2010 21:59:44 GMT

Hi,

You stated that you installed SQL Server Express, but you didn't mention if you created a geodatabase. Did you connect to the database server node in ArcCatalog as a database server administrator and create a geodatabase already? If not, there isn't any geodatabase to connect to so creating a Spatial Database Connection won't work.

See this topic for an overview of getting started with ArcSDE geodatabases in SQL Server Express.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_setting_up_and_using_database_servers/003n00000099000000/

-Kim

Re: Entry for SDE instance not found in services file

NormZastre — Tue, 07 Sep 2010 22:12:06 GMT

I guess that is the root of the problem. I cannot create a "New Geodatabase.." I installed sqlexpress and SDE personal (wizard) as the Administrator.

see the attached

norm

Re: Entry for SDE instance not found in services file

CherylCleghorn — Wed, 08 Sep 2010 14:13:07 GMT

Did you add an administrative user when prompted during the installation process?

Re: Entry for SDE instance not found in services file

NormZastre — Wed, 08 Sep 2010 14:28:39 GMT

Yes, when prompted I entered my domain credentials, see attached.

thx

Re: Entry for SDE instance not found in services file

KimPeter — Wed, 08 Sep 2010 15:56:14 GMT

Are you using an ArcView license? You cannot create new ArcSDE geodatabases with an ArcView license. When I've seen the New Geodatabase option inactive before it was usually due to the Desktop license level.

Re: Entry for SDE instance not found in services file

NormZastre — Wed, 08 Sep 2010 16:07:54 GMT

Yes, we are using an Arcview License. So I guess the personal SDE is useless unless you have at least ArcEditor or access to another system that can create ArcSDE geodatabases.

Thanks for your help.

Re: Entry for SDE instance not found in services file

LefterisKoumis — Mon, 04 Oct 2010 14:50:52 GMT

Even though if you have ArcEditor, you will need ArcSDE Enterprise edition on the server to create a geodatabase from ArcEditor. You can edit an existing geodatabase with ArcSDE workgroup edition.

Re: Entry for SDE instance not found in services file

KimPeter — Wed, 13 Oct 2010 21:30:08 GMT

To clarify:

You don't need ArcSDE enterprise to create a geodatabase from the database server node in ArcGIS Desktop. In fact, you can't create an enterprise ArcSDE geodatabase from ArcGIS Desktop at all.

To create a geodatabase on a SQL Server Express instance through the database server node in Desktop, you need:

-A supported version of SQL Server Express
[INDENT]You can run the SQL Server Express installation wizard provided with ArcGIS Desktop or ArcGIS Server Workgroup to install this.[/INDENT]
-To run the portion of the installation wizard to enable the SQL Server Express instance to store geodatabases, which writes a key to the Windows registry
[INDENT]When you create a geodatabase on a database server, ArcGIS looks for this registry key. If if can't find it, you won't be able to create a geodatabase.[/INDENT]
-A connection to the database server from an ArcEditor or ArcInfo level ArcGIS Desktop client
[INDENT]If your ArcGIS Desktop license isn't set to ArcEditor or ArcInfo, the New Geodatabase command will be inactive.[/INDENT]
-To be logged in to the client computer as an administrator on that particular database server
[INDENT]A database server administrator is added at the time SQL Server Express is installed. That initial administrator can add other user logins to the database server administrator role if needed. Only database server administrators have the privileges in the SQL Server Express instance required to create a geodatabase.[/INDENT]