--- Starting SF_Replicate for Account V965613:21:34: Parameters: SALESFORCEDEV Account Version: V965613:21:38: Running DBAmpAZ.exe.13:21:38: DBAmpAZ 22.0.9670.0 Copyright c 2023 CData Software, Inc.13:21:38: Warning: Could not get Session Info from Registry.13:21:38: Using options specified in Options parameter: soap,default13:21:38: Error: Unable to open a connection to SQL Server.13:21:38: System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'dbamp'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at afo220p.vN.A(Sv )ClientConnectionId:1140cf83-fb7a-493f-9cf7-a63fb3191124Error Number:18456,State:1,Class:1413:21:38: DBAmpAZ Operation FAILED.13:21:38: Error: Replicate program was unsuccessful.13:21:38: Error: Command string is C:\"Program Files"\CData\"CData DBAmp"\bin\DBAmpAZ.exe FullCopy "Account" "REPORTINGDEV" "SalesforceBackup" "SALESFORCEDEV" "soap,default" --- Ending SF_Replicate. Operation FAILED.
Question
I'm trying to update to OAuth and I'm getting this error
Hi
The error "Login failed for user 'dbamp'" indicates that DBAmp is unable to authenticate to your local SQL Server instance using the SQL login it relies on internally. This is a SQL Server configuration issue rather than a Salesforce connectivity issue.
DBAmp uses a dedicated SQL Server login named 'dbamp' in this case for its internal operations. The most common reasons this login fails are:
- The login does not exist (e.g., after a SQL Server migration or incomplete install)
- The login exists but has been disabled
- The SQL Server instance is configured for Windows Authentication mode only, which blocks SQL logins entirely
Please work through the following steps:
1. Verify the login exists and is enabled.
2. Confirm SQL Server authentication mode. In SSMS, right-click your server instance → Properties → Security. Ensure "SQL Server and Windows Authentication mode" is selected. If it is currently set to Windows Authentication only, change it and restart the SQL Server service.
3. Ensure that the credentials configured under the Remote tab of the configuration are correct. You can reach the DBAmp Configuration settings by opening the DBAmp Configuration app and navigating to Configuration -> Settings.
As for switching to OAuth, the help docs lays out the steps for setting up Oauth in DBamp: https://cdn.cdata.com/help/AFH/dbampd/Configuring_OAuth_Client.html
If the above do not help please reach out to the CData support team so one of our DBamp support specialists can further assist you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.