# MSSQL Unable to determine database dialect

**URL:** <https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022>\
**Category:** SonarQube Server / Community Build\
**Tags:** mssql, sonarqube\
**Created:** [March 27, 2023, 6:38am UTC](https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022 "2023-03-27T06:38:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![STAP](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@STAP](https://community.sonarsource.com/u/STAP)\
**Post date:** [March 27, 2023, 6:38am UTC](https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022/1 "2023-03-27T06:38:17Z")

</div>

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 database, but no mather what i do i keep getting this error:

```auto
2023.03.23 13:49:25 INFO web[][o.s.p.ProcessEntryPoint] Starting Web Server
2023.03.23 13:49:26 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.8.0.63668 / 6498415c5112d868f6206d8bcc043a1dac92d1c4
2023.03.23 13:49:26 WARN web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase': Initialization of bean failed; nested exception is Unable to determine database dialect to use within sonar with dialect null jdbc url sonar.jdbc.url=jdbc:sqlserver://SQLSERVER\I01:50001;databaseName=K8S_SONARQUBE_ONT
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27-org.sonar.db.DefaultDatabase': Initialization of bean failed; nested exception is Unable to determine database dialect to use within sonar with dialect null jdbc url sonar.jdbc.url=jdbc:sqlserver://SQLSERVER\I01:50001;databaseName=K8S_SONARQUBE_ON

```

I have no idee where too look, the JDBC connection should be ok `jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]`.

If anyone could give me some pointers on where too look, that would be great.

Kind regards  
Dennis

---

<div class="post-metadata">

**Author:** ![STAP](https://avatars.discourse-cdn.com/v4/letter/s/7993a0/32.png) [@STAP](https://community.sonarsource.com/u/STAP)\
**Post date:** [March 27, 2023, 12:50pm UTC](https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022/2 "2023-03-27T12:50:23Z")

</div>

Used  
`value: sonar.jdbc.url=jdbc:`  
should be:  
`value: "jdbc:`  
than we had to tell it `insecureMode=true`  
but we are up and running.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/system/32/31083_2.png) [@system](https://community.sonarsource.com/u/system)\
**Post date:** [April 3, 2023, 12:50pm UTC](https://community.sonarsource.com/t/mssql-unable-to-determine-database-dialect/88022/3 "2023-04-03T12:50:32Z")

</div>

Closed on April 3, 2023, 12:50pm UTC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.