Is This Content Helpful?
We're glad to know this article was helpful.
When ArcGIS for Desktop 10.4.1 is connected to SQL Server 2016, running the Enable Enterprise Geodatabase tool on a newly created database containing feature classes and tables copied from an existing enterprise geodatabase fails with the following error.
Error: Could not create geodatabase tables and stored procedures.
Note: The Enable Enterprise Geodatabase tool is only available for Standard or Advanced license levels of ArcGIS for Desktop. For more information, refer to the licensing information of this tool.
This error occurs because multiple Microsoft ODBC drivers are installed on the machine, which is sometimes done for troubleshooting or testing purposes. This causes conflicts when upgrading the geodatabase.
Note: For more information on Microsoft SQL Server database versions with drivers supported in ArcGIS for Desktop 10.4.x, refer to Supported database versions.
To run the Enable Enterprise Geodatabase tool successfully, identify the SQL Server versions used on the machine and uninstall the unneeded ODBC drivers on the machine.
Note: Ensure SQL Server Management Studio and all ArcGIS applications are closed prior to identifying the SQL Server version.