Bug
Cannot create a new geodatabase if the SQL Express instance is a default instance instead of a named instance.
| Bug ID Number | NIM085923 |
|---|---|
| Submitted | October 23, 2012 |
| Last Modified | February 7, 2025 |
| Applies to | No Product Found |
| Version found | 10.1 |
| Version Fixed | 10.2 |
| Status | Fixed |
Description
Cannot create a new geodatabase on a SQL Server Express Amazon Machine Instance (AMI) from ArcGIS for Server 10.1 SP1 or ArcGIS for Server 10.1 Japanese.The new geodatabase appears under the Database Server node in ArcCatalog, but when a connection is made to the new geodatabase, the following error is returned:
"Failed to connect to database. Bad login user."
When the connection to the database server is refreshed, the newly created geodatabase no longer appears.
Cause
Creating a new geodatabase fails if SQL Server Express is installed as the default instance instead of a named instance.A default instance is identified as <machine_name>, for example, MyServer or Localhost.
A named instance is identified as <machine_name>\<instance_name>, for example, MyServer\sqlexpress or Localhost\sqlexpress.
Workaround
Please contact Esri Technical Support. A support analyst can provide a simple script that allows geodatabases to be created.Steps to Reproduce
Bug ID: NIM085923
Software:
- No Product Found
Get notified when the status of a bug changes
Related Information
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App