||Using SQL Server 2005 SP2:
I'm moving from SDE 9.2 to 9.3, so I installed a new instance as a test. The particular server that I will be upgrading has an SDE database installed such that the objects are owned by the SDE user (so it's meant for a single SDE install on the server). However, rasters are stored in various, separate databases. This works on 9.2 without a problem. On 9.3 when I try to create a raster catalog within a separate database, I received the message "DBMS table not found - Locator does not exist - Failed to execute (CreateRasterDataset_4)". I can create a raster dataset within the SDE database itself without a problem. I've looked at everything such as permissions for the connection, etc. I went as far as running a SQL trace of what happens during the attempt to create the raster. I replayed that trace up to the point where it checks to see that the table was created. The select statements pulls from the sde.sde.sde_table_registry table where database_name = "dbname" and owner = "owner_name" and imv_view_name = "whatever that is supposed to be". I find that all is good, the table is created in the DB where it should be, etc. But the select returns no rows because the imv_view_name field is null versus having the value it should (which appears to be the same as the name for the raster catalog). The next statement in the trace is the deletion of the table. I assume that this happens because the select fails.
Anyway, I was wondering if anyone else has seen this problem? I tried searches on the forum here first, but did not find anything.
Thanks for any help you can provide.