Can create a feature class but not a feature dataset in SQL Svr 2008R2 database

[JamesFox1]

This is a new issue but spawned from the same environment of the "Issues creating a geodatabase with ArcGIS Desktop v10.1 / SDE v10.0 on SQL Svr 2008R2" thread I posted  earlier. 

(http://forums.arcgis.com/threads/91662-Issues-creating-a-geodatabase-with-ArcGIS-Desktop-v10.1-SDE-v...)

I can connect to this database via reseting the default schema mapped to the connected user. And I create/import a feature class.

However that is it. I cannot create or import a feature dataset into this database. Right click on "New" and only feature class or table appear. No feature datasets, no ratsers nor any toolboxes. And I cannot find information on this either. It appears however that the geodatabase is "enabled" but functionality is not present. All the system tools seem to be present, however no feature dataset tools are present and "quick import/export" under the Data Management Toolbox is disabled.

Is SDE really just "minimally" functional until the Post Install is run then? Funny, I don't see the SDE user or schema either.

But one would think I should NOT BE ABLE TO CONNECT AT ALL TO SQL SERVER if SDE is not really enabled or functioning, right? 


-Jim

[VinceAngelo]

There is, as you've previously indicated, something seriously wrong with the integrity of this
geodatabase. There are scores of possible causes, and the most likely way to discover the
issue(s) is to work with Tech Support.  It is quite likely that you will need to start over from
scratch in a new database, and salvage what you can from the broken one.

- V