# \#mssql **URL:** https://community.sonarsource.com/tag/mssql/110.md [Latest](https://community.sonarsource.com/latest.md) · [Categories](https://community.sonarsource.com/categories.md) · [Tags](https://community.sonarsource.com/tags.md) --- ## [New database tables created after server migration from 8.9.2 to 8.9.10](https://community.sonarsource.com/t/new-database-tables-created-after-server-migration-from-8-9-2-to-8-9-10/135875)
**Author:** [@arabenstein](https://community.sonarsource.com/u/arabenstein)\ **Replies:** 1\ **Last updated:** [February 27, 2025, 9:58am UTC](https://community.sonarsource.com/t/new-database-tables-created-after-server-migration-from-8-9-2-to-8-9-10/135875 "2025-02-27T09:58:32Z")
I’m running SonarQube Developer Edition version 8.9.2 on a Windows Server, where the database is stored in a local MSSQL 2017 instance. Now I needed to migrate to a new server, so I copied the database to the new MSSQL … --- ## [Sonarqube is not starting after change of SQL DB server change to 2022](https://community.sonarsource.com/t/sonarqube-is-not-starting-after-change-of-sql-db-server-change-to-2022/116185)
**Author:** [@subramadluru](https://community.sonarsource.com/u/subramadluru)\ **Replies:** 5\ **Last updated:** [June 2, 2024, 5:24am UTC](https://community.sonarsource.com/t/sonarqube-is-not-starting-after-change-of-sql-db-server-change-to-2022/116185 "2024-06-02T05:24:02Z")
Must-share information (formatted with Markdown): which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension):9.9.4 how is SonarQube deployed: zip, Docker, Helm: zip what are you trying to ach… --- ## [Migrating from Postgre to Microsoft SQL Server](https://community.sonarsource.com/t/migrating-from-postgre-to-microsoft-sql-server/114530)
**Author:** [@tbkonar](https://community.sonarsource.com/u/tbkonar)\ **Replies:** 2\ **Last updated:** [May 19, 2024, 7:57pm UTC](https://community.sonarsource.com/t/migrating-from-postgre-to-microsoft-sql-server/114530 "2024-05-19T19:57:02Z")
Hi All, We are currently on version 8.9.3 and running on Linux Vm with Postgre DB (OOTB Sonar). We are looking to upgrade to 10.5 via 9.9 and planning to use Microsoft SQL Server as DB instead. We are unable to find an… --- ## [SQL Server on AWS RDS](https://community.sonarsource.com/t/sql-server-on-aws-rds/113200)
**Author:** [@hi55](https://community.sonarsource.com/u/hi55)\ **Replies:** 2\ **Last updated:** [April 16, 2024, 2:28am UTC](https://community.sonarsource.com/t/sql-server-on-aws-rds/113200 "2024-04-16T02:28:04Z")
Hi,team. I want to connect SonarQube to SQL Server on AWS RDS. sonarqube:ECS(Fargate) SQL Server:RDS The ECS task definition is as follows. Please advise. "environment": \[ { "name… --- ## [Migrate SonarQube Scan History from 8.9 to 10.4](https://community.sonarsource.com/t/migrate-sonarqube-scan-history-from-8-9-to-10-4/112279)
**Author:** [@sonarprincipal](https://community.sonarsource.com/u/sonarprincipal)\ **Replies:** 1\ **Last updated:** [March 29, 2024, 3:11pm UTC](https://community.sonarsource.com/t/migrate-sonarqube-scan-history-from-8-9-to-10-4/112279 "2024-03-29T15:11:39Z")
Hi all, We currently have SonarQube Community 8.9 installed on an Azure based VM and we’re currently building out a new SonarQube environment based on 10.4 in AKS using Helm. Both environments are using SQL based databa… --- ## [Upgrading from 10.2 to 10.4](https://community.sonarsource.com/t/upgrading-from-10-2-to-10-4/110673)
**Author:** [@jjp\_69](https://community.sonarsource.com/u/jjp_69)\ **Replies:** 2\ **Last updated:** [March 7, 2024, 8:34pm UTC](https://community.sonarsource.com/t/upgrading-from-10-2-to-10-4/110673 "2024-03-07T20:34:51Z")
Currently using SonarQube 10.2 connect to MSSQL. Want to upgrade to version 10.4 to get support for python 3.12 but is says the database needs to be updated manually. In the past when upgrading version you would go to yo… --- ## [ActiveDirectoryServicePrincipal SQL Authentication](https://community.sonarsource.com/t/activedirectoryserviceprincipal-sql-authentication/109806)
**Author:** [@sonarprincipal](https://community.sonarsource.com/u/sonarprincipal)\ **Replies:** 1\ **Last updated:** [February 27, 2024, 2:56pm UTC](https://community.sonarsource.com/t/activedirectoryserviceprincipal-sql-authentication/109806 "2024-02-27T14:56:53Z")
Hello, I’ve been working to install SonarQube Community 10.4.0 in our AKS environment but have been running into issues trying to use an Azure SQL PaaS database with ActiveDirectoryServicePrincipal authentication. I see… --- ## [Sonarqube installtion with mssql](https://community.sonarsource.com/t/sonarqube-installtion-with-mssql/106598)
**Author:** [@Mohtishamahmed\_Arain](https://community.sonarsource.com/u/Mohtishamahmed_Arain)\ **Replies:** 2\ **Last updated:** [January 12, 2024, 6:02am UTC](https://community.sonarsource.com/t/sonarqube-installtion-with-mssql/106598 "2024-01-12T06:02:58Z")
Hi everyone! I am trying to setup sonarqube with mssql but not succed can anyone here help me out. --- ## [Cant connect to SQL Server with latest SQ version](https://community.sonarsource.com/t/cant-connect-to-sql-server-with-latest-sq-version/105291)
**Author:** [@Pontus](https://community.sonarsource.com/u/Pontus)\ **Replies:** 7\ **Last updated:** [December 22, 2023, 1:13pm UTC](https://community.sonarsource.com/t/cant-connect-to-sql-server-with-latest-sq-version/105291 "2023-12-22T13:13:17Z")
Hi We are using SonarQube (9.9.3.79811) LTS running from image on Azure App Services. We use SQL Server as database (also hosted in Azure). We want to use AD authentication so are connectionstring is jdbc:sqlserver:sq… --- ## [Code Coverage for DB Unit Test Cases Written in .Net (MS TestCases)](https://community.sonarsource.com/t/code-coverage-for-db-unit-test-cases-written-in-net-ms-testcases/97371)
**Author:** [@vinaykoul4](https://community.sonarsource.com/u/vinaykoul4)\ **Replies:** 3\ **Last updated:** [August 16, 2023, 8:30am UTC](https://community.sonarsource.com/t/code-coverage-for-db-unit-test-cases-written-in-net-ms-testcases/97371 "2023-08-16T08:30:03Z")
Sonar Version - 8.9.7 We have .Net SQL Project which contains unit test cases for DB Objects written in .Net(MS Tests) using below packages - Microsoft.VisualStudio.CodeCoverage.Shim, Microsoft.VisualStudio.QualityToo… --- ## [Migration to sonarqube-10.1.0.73491 failed](https://community.sonarsource.com/t/migration-to-sonarqube-10-1-0-73491-failed/95982)
**Author:** [@Simon\_Leclercq](https://community.sonarsource.com/u/Simon_Leclercq)\ **Replies:** 4\ **Last updated:** [July 21, 2023, 4:24pm UTC](https://community.sonarsource.com/t/migration-to-sonarqube-10-1-0-73491-failed/95982 "2023-07-21T16:24:27Z")
Must-share information (formatted with Markdown): which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension) sonarqube-9.9.1.69595 how is SonarQube deployed: zip, Docker, Helm zip what are … --- ## [Huge transaction Logs using SQL Server 2019 and Sonarqube 9.x](https://community.sonarsource.com/t/huge-transaction-logs-using-sql-server-2019-and-sonarqube-9-x/96024)
**Author:** [@ricksheeley](https://community.sonarsource.com/u/ricksheeley)\ **Replies:** 1\ **Last updated:** [July 20, 2023, 4:05pm UTC](https://community.sonarsource.com/t/huge-transaction-logs-using-sql-server-2019-and-sonarqube-9-x/96024 "2023-07-20T16:05:44Z")
Enterprise Edition Version 9.4 (build 54424) SQL Server 2019 Standard Edition (Windows Server 2019) So we are seeing huge transaction log backups for Sonar 9.X (avg. 15GB every hour). This is up from around 2GB just m… --- ## [Sonarqube developer edition cannot able to start](https://community.sonarsource.com/t/sonarqube-developer-edition-cannot-able-to-start/95688)
**Author:** [@Balaji\_Sudharsan](https://community.sonarsource.com/u/Balaji_Sudharsan)\ **Replies:** 1\ **Last updated:** [July 14, 2023, 6:47pm UTC](https://community.sonarsource.com/t/sonarqube-developer-edition-cannot-able-to-start/95688 "2023-07-14T18:47:10Z")
I installed the developer edition and I started the sonar without any DB configuration. Then after installing the SQL server 2019 and entered the connection string in the sonar.properties, right from there I cannot able … --- ## [How to resolve "Cannot find the object "org\_qprofiles.qprofiles\_org\_uuid" on update SonarQube"](https://community.sonarsource.com/t/how-to-resolve-cannot-find-the-object-org-qprofiles-qprofiles-org-uuid-on-update-sonarqube/90525)
**Author:** [@Higor](https://community.sonarsource.com/u/Higor)\ **Replies:** 1\ **Last updated:** [May 9, 2023, 6:20pm UTC](https://community.sonarsource.com/t/how-to-resolve-cannot-find-the-object-org-qprofiles-qprofiles-org-uuid-on-update-sonarqube/90525 "2023-05-09T18:20:39Z")
I’m upgrading SonarQube from version 8.5 to 8.9. The database is Azure SQL. I’m getting the error “Cannot find the object “org\_qprofiles.qprofiles\_org\_uuid” because it does not exist or you do not have permissions.” duri… --- ## [Error after upgrading from 9.9 to 10 | No shard available for \[get \[metadatas\]\[dbVendor\]](https://community.sonarsource.com/t/error-after-upgrading-from-9-9-to-10-no-shard-available-for-get-metadatas-dbvendor/89616)
**Author:** [@EBes](https://community.sonarsource.com/u/EBes)\ **Replies:** 2\ **Last updated:** [April 25, 2023, 2:04pm UTC](https://community.sonarsource.com/t/error-after-upgrading-from-9-9-to-10-no-shard-available-for-get-metadatas-dbvendor/89616 "2023-04-25T14:04:16Z")
Which versions are you using? We’re using SonarQube 9.9 (recently upgraded from 9.6) and wanted to upgrade to 10. How is SonarQube deployed? We’ve deployed a container through Docker using the following command docke… --- ## [SonarQube migratrion of ServiceApp/SQL Server to another Azure Subscription](https://community.sonarsource.com/t/sonarqube-migratrion-of-serviceapp-sql-server-to-another-azure-subscription/88203)
**Author:** [@nedeljko.scepanovic](https://community.sonarsource.com/u/nedeljko.scepanovic)\ **Replies:** 5\ **Last updated:** [April 20, 2023, 8:53am UTC](https://community.sonarsource.com/t/sonarqube-migratrion-of-serviceapp-sql-server-to-another-azure-subscription/88203 "2023-04-20T08:53:56Z")
Hello Team, I am using Developer SonarQube, and I got task to do migration of SonarQube (Azure AppService and Microsoft SQL server) from one Azure subscription to another Docker image is used for deployment I am trying… --- ## [MSSQL Unable to determine database dialect](https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022)
**Author:** [@STAP](https://community.sonarsource.com/u/STAP)\ **Replies:** 1\ **Last updated:** [March 27, 2023, 12:50pm UTC](https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022 "2023-03-27T12:50:23Z")
Dear Guru’s, I’am trying to run a Docker with 9.9.0-developer, using kustomization. When i use the default with the docker postgress i can run the application and access the website. Now i need to connect to our MSSQL… --- ## [How to analyse MS Sql database project](https://community.sonarsource.com/t/how-to-analyse-ms-sql-database-project/86059)
**Author:** [@OliB](https://community.sonarsource.com/u/OliB)\ **Replies:** 3\ **Last updated:** [March 20, 2023, 12:47pm UTC](https://community.sonarsource.com/t/how-to-analyse-ms-sql-database-project/86059 "2023-03-20T12:47:30Z")
ALM used: Azure DevOps CI system used: Azure DevOps Languages of the repository: C#, TypeScript, T-SQL Have set up our project in sonar cloud and happily seeing it run against our client app (Angular, typescript) and … --- ## [SONARQUBE 8.9 to 9.9 MSSQL not working](https://community.sonarsource.com/t/sonarqube-8-9-to-9-9-mssql-not-working/86188)
**Author:** [@Jersen](https://community.sonarsource.com/u/Jersen)\ **Replies:** 1\ **Last updated:** [March 20, 2023, 8:04am UTC](https://community.sonarsource.com/t/sonarqube-8-9-to-9-9-mssql-not-working/86188 "2023-03-20T08:04:13Z")
HI Everyone , I just upgraded our Sonarqube from 8.5 to 9.9 and it seems like that the sonarqube is not connecting to my local mssql server. whenever everything is in default the sonarqube site :9000 is working but when… --- ## [Error al conectarse a sqlserveren sonar 9.9 lts](https://community.sonarsource.com/t/error-al-conectarse-a-sqlserveren-sonar-9-9-lts/85177)
**Author:** [@moisesarrona](https://community.sonarsource.com/u/moisesarrona)\ **Replies:** 2\ **Last updated:** [March 6, 2023, 7:22pm UTC](https://community.sonarsource.com/t/error-al-conectarse-a-sqlserveren-sonar-9-9-lts/85177 "2023-03-06T19:22:50Z")
The new version of sonar 9.9lts was installed on a windows 2022 server, when connecting to the SQLServer database it shows an error connection string: sonar.jdbc.url=jdbc:sqlserver://server\\\\instance:1433;databaseName=s… --- ## [DB Migration issues during Upgrade from 8.9.10 LTS to 9.9 LTS](https://community.sonarsource.com/t/db-migration-issues-during-upgrade-from-8-9-10-lts-to-9-9-lts/84735)
**Author:** [@JuMi](https://community.sonarsource.com/u/JuMi)\ **Replies:** 3\ **Last updated:** [February 28, 2023, 9:38am UTC](https://community.sonarsource.com/t/db-migration-issues-during-upgrade-from-8-9-10-lts-to-9-9-lts/84735 "2023-02-28T09:38:55Z")
Hi Community, today I upgraded our test system from 8.9.10 LTS to 9.9 LTS. Sonar is running on Windows Server 2016 and we’re using a MS SQL database (2016 I guess). I’ve upgraded Java to OpenJDK 17.0.6 and also change… --- ## [SonarQube- Auzre K8S Sonar with Azure SQL as backend](https://community.sonarsource.com/t/sonarqube-auzre-k8s-sonar-with-azure-sql-as-backend/80971)
**Author:** [@mandapatiSreekanth](https://community.sonarsource.com/u/mandapatiSreekanth)\ **Replies:** 3\ **Last updated:** [January 12, 2023, 4:00pm UTC](https://community.sonarsource.com/t/sonarqube-auzre-k8s-sonar-with-azure-sql-as-backend/80971 "2023-01-12T16:00:47Z")
SonarQube on K8s with docker image 8.9.1-lts Is it possible to have Azure SQL as backed ?? It works with postgresql works perfectly Working for a finance client Postgresql is not allowed !! :neutral\_face: We are plan… --- ## [Server ID changed on upgrade?](https://community.sonarsource.com/t/server-id-changed-on-upgrade/79288)
**Author:** [@MBender](https://community.sonarsource.com/u/MBender)\ **Replies:** 1\ **Last updated:** [December 23, 2022, 8:41pm UTC](https://community.sonarsource.com/t/server-id-changed-on-upgrade/79288 "2022-12-23T20:41:45Z")
I wanted to upgrade our on-prem SonarQube installation from 9.3 to 9.8, and move it to Docker to make future upgrades easier. The database for this would remain unchanged (an on-prem MSSQL server). According to the docu… --- ## [Logs state database collation is wrong but its not](https://community.sonarsource.com/t/logs-state-database-collation-is-wrong-but-its-not/76118)
**Author:** [@Dylan\_Mi](https://community.sonarsource.com/u/Dylan_Mi)\ **Replies:** 1\ **Last updated:** [November 16, 2022, 7:44pm UTC](https://community.sonarsource.com/t/logs-state-database-collation-is-wrong-but-its-not/76118 "2022-11-16T19:44:17Z")
I’m having some major issues deploying the Enterprise edition using SQL authentication on MSSQL express 2019. The web server logs show that the SonarCube services for some reason think the collation is incorrect when it … --- ## [SonarQube on Virtual Machine / Integrated authentication with Azure AD Issue](https://community.sonarsource.com/t/sonarqube-on-virtual-machine-integrated-authentication-with-azure-ad-issue/75435)
**Author:** [@sfarr-dbd](https://community.sonarsource.com/u/sfarr-dbd)\ **Replies:** 5\ **Last updated:** [November 11, 2022, 2:49pm UTC](https://community.sonarsource.com/t/sonarqube-on-virtual-machine-integrated-authentication-with-azure-ad-issue/75435 "2022-11-11T14:49:47Z")
Version Info: SonarQube Developer Edition v9.7.1 Microsoft JDK 11.0.16.101 What am I trying to do? Setup of Azure SQL database authentication for virtual machine admin account running SonarQube, using Active Directo… --- ## [Experiencing FP related to the use of single quotes in T-SQL statements](https://community.sonarsource.com/t/experiencing-fp-related-to-the-use-of-single-quotes-in-t-sql-statements/75312)
**Author:** [@smeyer374NM](https://community.sonarsource.com/u/smeyer374NM)\ **Replies:** 1\ **Last updated:** [November 1, 2022, 12:26pm UTC](https://community.sonarsource.com/t/experiencing-fp-related-to-the-use-of-single-quotes-in-t-sql-statements/75312 "2022-11-01T12:26:51Z")
When pushing SQL script files via GitLab pipeline, SonarQube reports “An illegal character with code point 13 was found in this literal.” where ever our code uses single quotes which is standard syntax when working with … --- ## [Extremely slow analysis](https://community.sonarsource.com/t/extremely-slow-analysis/71438)
**Author:** [@Dominique\_Jean-Prost](https://community.sonarsource.com/u/Dominique_Jean-Prost)\ **Replies:** 7\ **Last updated:** [October 26, 2022, 11:45am UTC](https://community.sonarsource.com/t/extremely-slow-analysis/71438 "2022-10-26T11:45:21Z")
Hello, I’m currently running sonarqube CE in version 8.9.5, and I sometimes have extremely slow analysis. I managed to extract those execution time in ce.log Ligne 39: 2022.09.13 09:30:56 INFO ce\[AYM2CUAYbSX6o6UkLj… --- ## [MS SQL Integrated Security - Starting SonarQube on Linux](https://community.sonarsource.com/t/ms-sql-integrated-security-starting-sonarqube-on-linux/74236)
**Author:** [@bill07](https://community.sonarsource.com/u/bill07)\ **Replies:** 2\ **Last updated:** [October 13, 2022, 2:05am UTC](https://community.sonarsource.com/t/ms-sql-integrated-security-starting-sonarqube-on-linux/74236 "2022-10-13T02:05:44Z")
8.9 LTS Community Edition MSSQL 2019 on Windows Server 22, SonarQube LTS on RHEL 7.7 I’m trying to start SonarQube using integrated security. I made sure to install the correct driver package 9.2.0 and copied the .dll … --- ## [MSSQL Installation](https://community.sonarsource.com/t/mssql-installation/73202)
**Author:** [@bill07](https://community.sonarsource.com/u/bill07)\ **Replies:** 1\ **Last updated:** [September 20, 2022, 7:58am UTC](https://community.sonarsource.com/t/mssql-installation/73202 "2022-09-20T07:58:06Z")
I’ve recently installed SonarQube 8.1 community edition. I was successfully able to get a demo instance running but would now like to set up a production instance. SonarQube is currently run on a Linux VM and MSSQL is r… --- ## [Sonarqube-9.6.1.59531 can't connect to MSSQL database with SQL authenthication](https://community.sonarsource.com/t/sonarqube-9-6-1-59531-cant-connect-to-mssql-database-with-sql-authenthication/71249)
**Author:** [@501NotImplemented](https://community.sonarsource.com/u/501NotImplemented)\ **Replies:** 4\ **Last updated:** [September 16, 2022, 3:05pm UTC](https://community.sonarsource.com/t/sonarqube-9-6-1-59531-cant-connect-to-mssql-database-with-sql-authenthication/71249 "2022-09-16T15:05:49Z")
Hi. I’m trying to install the community version of sonarqube-9.6.1.59531 and connect it to MSSQL database. I went with SQL authentication option, and created a SQL login and blank database (on a local MSSQL instance) wi… [Next page](https://community.sonarsource.com/tag/mssql/110.md?match_all_tags=true&page=1&tags%5B%5D=mssql)