Troubleshooting database servers

The following are suggested solutions to problems you may encounter when working with database servers or geodatabases on database servers.

TipTip:

To capture errors in logs, you can create an etc folder in your ArcGIS installation location and log files will be generated automatically in that location. For example, if you installed ArcGIS Desktop to c:\Program Files\ArcGIS, create a folder named etc in that location—c:\Program Files\ArcGIS\etc. After you have gotten the information you need from the files or sent copies to technical support, delete the etc folder. The error logs that get created in the etc folder are not truncated and can rapidly grow to many megabytes in size. If you only delete the log files, they are re-created automatically in the etc folder.

Error: Cannot connect to this Data Server...SQL Server does not exist or access denied.

Possible reasons you received the error message:

  • If the SQL Server Express instance has not been started, the remote client will not be able to locate it.
  • If your user account was never set up on the database server or your user account was removed from the database server, you won't be able to query or connect to it.
  • Remote clients must have a way to communicate with the SQL Server Express instance. If the network protocol is not set, that method of communication is not set, and there is no way for a connection to be made to the instance over a network.
  • The SQL Server Browser service provides information about the SQL Server instances installed on the computer when it receives a request from a SQL Server client. If the SQL Browser is disabled, the client will not receive the names and ports used for each installed SQL Server instance and, therefore, cannot find the instance.

Fix:

First, ensure the database server to which you are trying to connect is started. If it is, confirm that you have permissions to access this database server remotely. If the database server is started and you have rights to connect to and query it, the network protocols are probably not enabled on the database server. To re-enable network protocols, do the following:

  1. Open the Microsoft SQL Server Configuration Manager. This can be accessed from Start > All Programs > Microsoft SQL Server > Configuration Tools.
  2. Expand SQL Server Network Configuration in the tree and click the protocols for your SQL Server instance.
  3. Right-click the TCP/IP protocol and click Enable.

You will receive the following warning message:

Any changes made will be saved; however, they will not take effect until the service is stopped and restarted.

Stop and restart the service. If the network protocols are enabled and you still cannot connect to the database server from the remote client, the SQL Server Browser service is probably stopped.To start the SQL Server Browser service:

  1. Open the Microsoft SQL Server Configuration Manager.
  2. Click the SQL Server icon to see the SQL Server Browser service.
  3. If the state of the SQL Server Browser is paused, right-click it and click Resume. If the state of the SQL Server Browser is stopped, right-click it and click Start.

If all the context menu options except Properties and Help are disabled when you right-click the SQL Server Browser, your SQL Server Browser start mode is set to Disabled. To change this:

  1. Right-click the SQL Server Browser and click Properties.
  2. Click the Service tab.
  3. Click Start Mode.
  4. From the pull-down menu, choose either Automatic or Manual. Setting the start mode to Automatic means the SQL Server Browser service automatically starts when you reboot the machine.
  5. Click OK.

Now when you right-click the SQL Server Browser service, Start should be an available option.

Error: Cannot Generate SSPI Context

Possible reason you received the error message:

This error is most commonly encountered if you are working on a laptop and are logging on with your domain credentials, but you are not actually connecting to your domain. This might happen if you are plugged in at a client site (as opposed to your own network) or using your laptop while not connected to a network at all, such as working in the field. It is related to TCP/IP network protocol and Windows authentication. You could also consult the Microsoft Web site for a knowledge base article on how to troubleshoot the 'Cannot generate SSPI context' error message.

Fix/Workaround:

Make your connection to the database server on your local machine (Add Database Server) using the TCP/IP loopback of 127.0.0.1 rather than the domain name; for example: 127.0.0.1\sqlexpress.

This will work as long as the database server (the SQL Server Express instance) is installed on your local machine.

Error: Failed to connect to database Underlying DBMS error (Microsoft OLE DB Provider for SQL Server. Login failed for user '<username>'. The user is not associated with a trusted SQL Server connection.)

Possible reason you received the error message:

When the environment variables SDEUSER or SDEPASSWORD are set either in the System Environment Variables or in a dbinit.sde file, they will take precedence over your Windows login when connecting to an ArcSDE geodatabase. Do not set these variables if you are going to connect from that machine to an ArcSDE geodatabase on a database server, or if you are going to connect to an ArcSDE geodatabase licensed with ArcGIS Server Enterprise using operating system authentication.

Fix:

Make sure you do not have an SDEUSER or SDEPASSWORD environment variable set on the connecting client machine.

Error: Failed to add feature class. <feature class name> is in load-only mode and cannot be added as a layer in this state.

Possible reason you received the error message:

If the spatial grid size of a dataset is set to 0 when you try to import it to the ArcSDE geodatabase, the import fails and the dataset can end up stuck in load-only input/output (I/O) mode. Recalculating the spatial index grid size should put the feature class back in normal I/O mode, and you should then be able to work with it.

Fix/Workaround:

Recalculate the spatial index grid sizes on the feature class.

  1. In the Catalog tree, right-click the feature class that is in load-only mode, click Properties, then click the Indexes tab on the Feature Class Properties dialog box.
  2. In the Spatial Index section, click Recalculate.
  3. Click OK on the Indexes tab.

Problem: The connecting user does not have access to database server administrative tasks, such as New geodatabase, Restore, or Permissions, even though the user has been added to the Windows Administrator group on the server machine.

Reason the Windows Administrator could not perform server administrator tasks:

Windows Vista, 7, and 2008 Server computers have UAC enabled by default. This enforces a tighter security model, which means Windows Administrators are not automatically sysadmin in the SQL Server database. Users accustomed to accessing ArcSDE database servers or other instances of SQL Server on a Windows XP or 2003 Server machine may be accustomed to the default behavior on these operating systems, and they may forget to take the steps necessary to add other Server administrator users to the database server.

Fix:

Either disable User Access Control (UAC) on the server machine or login as the administrator user that was added to the ArcSDE database server when the SQL Server Express instance was setup to store geodatabases, add the desired user to the database server, and grant him or her server administrator privileges.

Error: Version not found[sde.DEFAULT]

Reason you received the error message

If you make a Spatial Database Connection and forget to change the version from sde.DEFAULT, you will receive this error message.

Fix:

The system tables and DEFAULT version of geodatabases created on database servers are always owned by the dbo user. Therefore, you must change the version in the connection from sde.DEFAULT to either dbo.DEFAULT or another available transactional or historical version.

Error: Bad login user

Possible reason you received the error message:

Most likely, you attempted to connect to a geodatabase on a database server using a database-authenticated user name and password.

Fix:

Connections to geodatabases on database servers only use Windows authenticated log ins. Therefore, choose the operating system authentication option on the Spatial Database Connection dialog box while logged in with a valid Windows login.

Error: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Possible reasons you received the error message:

  • You attempted to connect to a geodatabase on a remote database server while logged in with a local Windows account.
  • You attempted to connect to a geodatabase on a database server with a domain account that has not been added to the database server.

Fix:

Log into the client computer with a domain account that a server administrator has added to the database server.

Error: Connection was attempted with an older version of SQL Server client communications software that is not compatible with the SQL Server database server

Reason you received the error message:

The client computer from which you are connecting to the geodatabase does not have a supported version of the Microsoft SQL Native Client installed.

Fix:

Install the SQL Native Client application on the client computer. If you are connecting to a SQL Server 2005 Express database, you need at least a SQL 2005 Native Client. To connect to a SQL Server 2008 Express database, you must install the SQL 2008 Native Client.


9/18/2012