erreur sql 448 azure devops server 2022

Question

I get erreur sql 448 azure devops server 2022, when trying to create a team

Answer 1

Hi @Diallo Ahmadou Baba

This issue occurs because Azure DevOps Server 2022 requires a specific SQL Server collation, and the error appears when the Azure DevOps databases use an unsupported or newer SQL collation (commonly after upgrades to SQL Server 2022 or Azure DevOps Server 2022). When creating a team, Azure DevOps executes internal SQL operations that depend on this required collation. If the collation does not match what Azure DevOps expects, SQL Server returns Error 448, causing team creation to fail. This is not related to user permissions and can happen even to Project Collection Administrators.

Resolution:

• Azure DevOps Server 2022 supports only the SQL collation SQL_Latin1_General_CP1_CI_AS.
• Manually changing the collation of existing Azure DevOps databases is not supported and can cause data corruption.
• Take a full backup of all Azure DevOps databases.
• Install or rebuild SQL Server using the supported collation SQL_Latin1_General_CP1_CI_AS.
• Reinstall and configure Azure DevOps Server 2022.
• Restore the databases after reconfiguration.

You can post your issue with Azure Devops Server Developer community to get assistance from Devops team here: https://developercommunity.visualstudio.com/AzureDevOpsServerTFS?ftype=problem&preview2=true

If the resolution was helpful, kindly take a moment to click on and click on Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

I have databases with diferent collation

Answer 3

The error SQL 448 in Azure DevOps Server 2022 typically indicates that there is an issue with the database configuration or permissions. This error can occur when trying to create a team if the necessary permissions are not set correctly for the service account or if there are issues with the database connection.

To troubleshoot this issue, consider the following steps:

1. Check Database Permissions: Ensure that the service account used by Azure DevOps has the necessary permissions to access and modify the database. You may need to grant the appropriate roles or permissions.
2. Verify Database Connection: Make sure that the connection to the SQL database is properly configured and that the database is accessible from the Azure DevOps Server.
3. Review Logs: Check the Azure DevOps Server logs for any additional error messages or details that might provide more context about the SQL 448 error.
4. Consult Documentation: Refer to the Azure DevOps documentation for any specific requirements or configurations needed for your version.

If the issue persists, consider reaching out to Azure DevOps support for further assistance.