# MS SQL 2016 support

**URL:** https://www.finalbuilder.com/forums/t/ms-sql-2016-support/5544
**Category:** Discussion
**Created:** [March 8, 2017, 4:56am UTC](https://www.finalbuilder.com/forums/t/ms-sql-2016-support/5544 "2017-03-08T04:56:29Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![sergeykagan](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/s/4af34b/32.png) [@sergeykagan](https://www.finalbuilder.com/forums/u/sergeykagan)
#### Post date: [March 8, 2017, 4:56am UTC](https://www.finalbuilder.com/forums/t/ms-sql-2016-support/5544/1 "2017-03-08T04:56:29Z")

</div>

I am going to upgrade the MS SQL Server that runs my Continua database to version 2016&nbsp;.&nbsp; Should I change the connection string in continua configuration file? Thanks

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [March 9, 2017, 1:06am UTC](https://www.finalbuilder.com/forums/t/ms-sql-2016-support/5544/2 "2017-03-09T01:06:13Z")

</div>

Hi Sergey,  
  
Providing the SQL server instance name is the same then you should not need to change the connection string in the configuration&nbsp;file.&nbsp;  
  
The dialect property in the&nbsp;configuration&nbsp;file&nbsp;e.g.&nbsp;

`<``property` `name``=``“dialect”``>NHibernate.Dialect.MsSql2008Dialect``property``>`

  
defines how the&nbsp;NHibernate, which we use as our database ORM, interacts with the database.   
  
Currently this can be set to&nbsp;NHibernate.Dialect.MsSql2005Dialect or&nbsp;NHibernate.Dialect.MsSql2008Dialect. &nbsp;The value&nbsp;MsSql2008Dialect works with SQL Server version 2008 and later including SQL Server 2016.&nbsp;  
  
We have recently upgraded the NHibernate component and this now includes a&nbsp;MsSql2012Dialect&nbsp;dialect. We are in the process of updating our code to support this dialect for the next version. Once this is released we will recommend changing the dialect to &nbsp;MsSql2012Dialect.  
  
Note that the configuration file is by default located at&nbsp;%Program Files%\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config  
&nbsp;