# Servoy 8.3.1 and SQL2017 Developer Edition

**URL:** <https://forum.servoy.com/t/servoy-8-3-1-and-sql2017-developer-edition/19890>\
**Category:** Classic Servoy\
**Created:** [January 30, 2019, 12:46am UTC](https://forum.servoy.com/t/servoy-8-3-1-and-sql2017-developer-edition/19890 "2019-01-30T00:46:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dean](https://avatars.discourse-cdn.com/v4/letter/d/3be4f8/32.png) [@dean](https://forum.servoy.com/u/dean)\
**Post date:** [January 30, 2019, 12:46am UTC](https://forum.servoy.com/t/servoy-8-3-1-and-sql2017-developer-edition/19890/1 "2019-01-30T00:46:48Z")

</div>

The standard MS SQL driver 4.2 just doesn’t work and using the JAR for 8 and 10 still doesn’t allow Servoy to access the database.  
The error says that a TCP/IP connection can’t be initiated over port 1433. Yet SQL Configuration shows TCP/IP active and the system’s firewalls are turned off.  
Excel and other third party applications can access the SQL server (we used AdventureWorks as a test DB) but Servoy just refuses.

---

<div class="post-metadata">

**Author:** ![kwpsd](https://avatars.discourse-cdn.com/v4/letter/k/bb73d2/32.png) [@kwpsd](https://forum.servoy.com/u/kwpsd)\
**Post date:** [January 30, 2019, 5:38pm UTC](https://forum.servoy.com/t/servoy-8-3-1-and-sql2017-developer-edition/19890/2 "2019-01-30T17:38:16Z")

</div>

I have not tried connecting to SQL 2017 but will attempt to help.

What are your connection parameters? They should look like the below sample:

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL: jdbc:sqlserver://localhost:1433;DatabaseName=\<your\_database\_name\>;SelectMethod=cursor

User name: sa

Also, using MS-SMS, create a systems admin account (sa) and use it to connect Servoy to the SQL server. The other items you mentioned, most likely, use a Windows account to connect.

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [February 5, 2019, 9:58am UTC](https://forum.servoy.com/t/servoy-8-3-1-and-sql2017-developer-edition/19890/3 "2019-02-05T09:58:52Z")

</div>

you can always try to use the latest 7.x driver of MS:  
[https://docs.microsoft.com/en-us/sql/co … erver-2017](https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017)

We updated the driver also for the next servoy release (just delete the old driver and extract the new one from that download)