I am glad you were able to stablish a connection. We would need to take a closed look at your setup/configuration to further troubleshoot the database discrepancies.

Hello Nataly,

I was using SQLServer Configuration and Network Credentials. This worked after installing the SQL through the installation media of OpenBotServer but was not working with the existing SQLExpress that I had already installed, strange.

Regards, Anish

Hi Anish,

the HTTP Error 500.30 � ANCM In-Process Start Failure error is usually related to a database issue. Meaning, the OpenBots site is unable to access the linked database. Is your installation using SQLExpress or SQLServer configuration?

As a side note, OpenBots version 1.6.0 and 1.6.1 require .Net Core 3.1. You can install it from: https://dotnet.microsoft.com/download/dotnet Select .NET Core 3.1 > ASP.NET Core Runtime 3.1.20 > Windows Hosting Bundle

Also In the logs I get this error:

Unhandled exception. System.FormatException: Could not parse the JSON file.

---> System.Text.Json.JsonReaderException: 'S' is an invalid escapable character within a JSON string. The string should be correctly escaped. LineNumber: 61 | BytePositionInLine: 31.

at System.Text.Json.ThrowHelper.ThrowJsonReaderException(Utf8JsonReader& json, ExceptionResource resource, Byte nextByte, ReadOnlySpan`1 bytes)

at System.Text.Json.Utf8JsonReader.ConsumeStringAndValidate(ReadOnlySpan`1 data, Int32 idx)

at System.Text.Json.Utf8JsonReader.ConsumeString()

at System.Text.Json.Utf8JsonReader.ConsumeValue(Byte marker)

at System.Text.Json.Utf8JsonReader.ReadSingleSegment()

at System.Text.Json.Utf8JsonReader.Read()

at System.Text.Json.JsonDocument.Parse(ReadOnlySpan`1 utf8JsonSpan, JsonReaderOptions readerOptions, MetadataDb& database, StackRowStack& stack)

at System.Text.Json.JsonDocument.Parse(ReadOnlyMemory`1 utf8Json, JsonReaderOptions readerOptions, Byte[] extraRentedBytes)

at System.Text.Json.JsonDocument.Parse(ReadOnlyMemory`1 json, JsonDocumentOptions options)

at System.Text.Json.JsonDocument.Parse(String json, JsonDocumentOptions options)

at Microsoft.Extensions.Configuration.Json.JsonConfigurationFileParser.ParseStream(Stream input)

at Microsoft.Extensions.Configuration.Json.JsonConfigurationFileParser.Parse(Stream input)

at Microsoft.Extensions.Configuration.Json.JsonConfigurationProvider.Load(Stream stream)

--- End of inner exception stack trace ---

at Microsoft.Extensions.Configuration.Json.JsonConfigurationProvider.Load(Stream stream)

at Microsoft.Extensions.Configuration.FileConfigurationProvider.Load(Boolean reload)

--- End of stack trace from previous location where exception was thrown ---

at Microsoft.Extensions.Configuration.FileConfigurationProvider.HandleException(ExceptionDispatchInfo info)

at Microsoft.Extensions.Configuration.FileConfigurationProvider.Load(Boolean reload)

at Microsoft.Extensions.Configuration.FileConfigurationProvider.Load()

at Microsoft.Extensions.Configuration.ConfigurationRoot..ctor(IList`1 providers)

at Microsoft.Extensions.Configuration.ConfigurationBuilder.Build()

at OpenBots.Server.Web.Program.Main(String[] args) in C:\Users\OpenBotsAdmin\source\repos\Devops\OpenBots.Server\OpenBots.Server.Web\Program.cs:line 18

Hello Kriti,

I have tried all this with no luck seems to be some issue with .NET core version not sure. I have tried from v3.14 to 3.19. Tried installing OpenBotsServer_v1.6.0 with no luck and OpenBotsServer_v1.6.1 with no luck.

Regards, Anish

Hello Anish , Go to "services" and restart the SQL Express service .After a few moments the server will start correctly when restarted in IIS .If service does not exist, install SQLExpress from Microsoft�s website: SQL Server Downloads .Once service is running, open an admin command prompt or admin PowerShell and restart IIS using command: iisreset

Thanks