BUG

Cannot create a new geodatabase on a SQL Server Express Amazon Machine Instance from ArcGIS for Server 10.1 SP1 or 10.1 Japanese

Last Published: April 25, 2020

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.

    Article ID:000011666

    Software:
    • ArcGIS Server

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Related Information

    Discover more on this topic