Developer forum

Forum » Swift » Login failed for user ''

Login failed for user ''

Aki Ruuskanen
Aki Ruuskanen
Reply

Hi,

Not sure if this is DW10 or Swift2 but I have installed a clean DW10 with Swift2 and everything works fine except for when I try to run the product indexer. The I get an error saying "Login failed for user ''"

What could cause that?

Stacktrace:

Product index builder experienced a fatal error.. System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken)
   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.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.Open()

Replies

 
Aki Ruuskanen
Aki Ruuskanen
Reply

Also appears if a click on Users:

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

The exception bears this:

System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.

So it seems like that you have lost your SQL user somehow - or is running with some connection setup that fails...?

 
Aki Ruuskanen
Aki Ruuskanen
Reply

Hmm. Well I have my connection in the GlobalSettings.config and fire it up with "dotnet run". 

 

 
Aki Ruuskanen
Aki Ruuskanen
Reply

Now I just fired it up again at it's working. Glitch in the matrix. 

/Aki

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Reply

Hm - could it be some git branch switching where the globalsettings is changed when you change branch while running or something like that?

 
Aki Ruuskanen
Aki Ruuskanen
Reply

Wouldn't everything fail in that case? Anyways its up and running now. Thanks. 

/Aki

 

You must be logged in to post in the forum