Error when trying to create a Team Project Collection in Azure DevOps Server 2019

Question

I can’t seem to get the 1st project collection created in Azure DevOps Server 2019.

The creation process keeps timing out (within an hour range) and stating that it can’t connect to the DB, but it’s clear it’s been connected prior to step #67 in the creation process, which is where it times out.

Here is what I have tried:

Using 2 machines:

One machine has Azure DevOps Server 2019 and SQL 2017 (w/ SSMS) installed with following configuration

• 4G RAM
• At least 12 G free on hard drive now (will be increasing this)

Second machine will house build server

Error from Logs:

Caught exception in ExecuteScripts: Microsoft.TeamFoundation.Framework.Server.DatabaseRuntimeException: TF246017: Azure DevOps Server could not connect to the database. Verify that the instance is specified correctly, that the server that is hosting the database is operational, and that network problems are not blocking communication with the server. ---> System.Data.SqlClient.SqlException: A timeout occurred while waiting for memory resources to execute the query in resource pool 'internal' (1). Rerun the query

Answer 1

I had an additional 4G RAM installed to the server and that fixed the issue.