Developer forum

Forum » Dynamicweb 10 » Product index DB connection error

Product index DB connection error

E-mail notifications
John Broers
Reply
Posted on 26/12/2023 16:16:11

I configured a Dynamicweb 10 installation using the .NET CLI and followed the steps outlined in the documentation to create a product indexer. However, upon attempting to execute the indexer, I encountered the following error.

Notably, this error persisted across both Mac and Windows systems.

License: Trial 10.0.26

2023-12-26 15:42:46.8197: Product index builder experienced a fatal error.. System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''.
   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.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Dynamicweb.Ecommerce.Indexing.ProductIndexBuilder.Build(IIndexWriter writer, Tracker tracker)
ClientConnectionId:2fdabefc-d2a9-4e2f-bbfc-8d9968f119de
Error Number:18456,State:1,Class:14

 

BR,
John

DW10_Error.png

Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 27/12/2023 11:16:43
Reply

Hi John

It is a SQL user that cannot login to your SQL Server database - so question is how your database section looks like in your config file? Or in the database setup under settings.

Can you do other things on the database - i.e. create a page etc.

BR Nicolai

 
John Broers
Posted on 27/12/2023 12:00:55
Reply

Hi Nicolai,

Thank you for your reply.

I think this issue was related to not secure localhost connection. When I was testing it today it was working fine. The only thing i changed was adding a trusted dev certificate after seeing this warning in my terminal after running 'dotnet run'.

'The ASP.NET Core developer certificate is not trusted. For information about trusting the ASP.NET Core developer certificate, see https://aka.ms/aspnet/https-trust-dev-cert.'

I applied the same fix on macOS, and it resolved the issue there as well. Other database actions, like creating pages and paragraphs, proceeded without any problems before this fix.

BR,
John

 

You must be logged in to post in the forum