Having a problem loading rasters into an sde geodatabase. I connect as a database user (db authentication), the user is a schema owner, has created several feature datasets and has select/insert/update/delete privileges on those datasets. When I try to import a raster (or copy and paste, or create a new raster), I get the following error:
Invalid SQL Syntax: Incorrect syntax near the keyword 'PRIMARY'
SQL Server Native Client 11.0
No spatial reference exists.
I am going to bet there's some sort of permissions issue here, and the first error is the result of the user not having the rights to create a table. But I'm able to create feature datasets and feature classes and import vector data. I'm not sure what other privileges the user needs if it can create the tables for vector data.
We are running SQL Server 2008R2, and Arc Desktop 10.2.1.
Any suggestions will be appreciated.