User has privileges required to create database objects. Database already exists. Geodatabase admin user created. Validated authorization file. User has required privileges for geodatabase setup. XML support is enabled for the database instance. Created geodatabase tables and stored procedures. Finished creating geodatabase schema. Succeeded at Thu Mar xx xx:00:11 2013 (Elapsed Time: 16.00 seconds)
Hi Jamal,
Since 'Create Enterprise Geodatabse' tool is designed to create the datafiles at the default location, you will need to create the database in SQL Server providing the custom location and then run 'Create Enterprise Geodatabase'.
In this case the tool will detect the existing database and will proceed with the remaining tasks of creating the geodatabase.User has privileges required to create database objects. Database already exists. Geodatabase admin user created. Validated authorization file. User has required privileges for geodatabase setup. XML support is enabled for the database instance. Created geodatabase tables and stored procedures. Finished creating geodatabase schema. Succeeded at Thu Mar xx xx:00:11 2013 (Elapsed Time: 16.00 seconds)
In case the database and the admin user (with appropriate permissions) are already created, you can use the "Enable Enterprise Geodatabase" tool.
Based on the description from webhelp:
Creating a database and geodatabase in SQL Server
"Create a database (500 MB) and log file (125 MB) in the default SQL Server location."
Jamal,
Just FYI,
even if you change the default data location of the Database files in SQL Server for a particular Instance, the newly created geodatabase using ArcGIS interface will still have its data files in the default location set by Microsoft.
So, the only option will be to create the database in SQL Server first at your preferred location, and then use the enable geodatabase option to convert it into a geodatabase.
Regards,
*All* database vendors have unfortunate default data locations. I *always*
manually create databases, so I *always* have the opportunity to specify
where I want my datafiles.
If you want Microsoft to change how their default storage location works, you
should probably take that up with them directly.
- V