# Music.properties example for SQL Server 12.0

**URL:** https://community.stardog.com/t/music-properties-example-for-sql-server-12-0/1786
**Category:** Support
**Created:** [July 17, 2019, 6:37pm UTC](https://community.stardog.com/t/music-properties-example-for-sql-server-12-0/1786 "2019-07-17T18:37:12Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![pierluigi](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pierluigi/32/472_2.png) [@pierluigi](https://community.stardog.com/u/pierluigi)
#### Post date: [July 17, 2019, 6:37pm UTC](https://community.stardog.com/t/music-properties-example-for-sql-server-12-0/1786/1 "2019-07-17T18:37:12Z")

</div>

That's my question: I have been able to use virtual graphs routinely on mysql, mariadb.

Now I need to connect to a SQL Server 12.0 (2016, I think) database. Would anyone have a basic example of the .properties file that would work for the music example in the tutorials?

Thank you,  
Pierluigi

---

<div class="post-metadata">

### Author: ![Simon\_Krauss](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/simon_krauss/32/383_2.png) [@Simon\_Krauss](https://community.stardog.com/u/Simon_Krauss)
#### Post date: [July 18, 2019, 12:13am UTC](https://community.stardog.com/t/music-properties-example-for-sql-server-12-0/1786/2 "2019-07-18T00:13:36Z")

</div>

Hi Pierluigi,

- The JDBC connection URL looks like this jdbc:sqlserver://localhost;databaseName=master . Note that the port is not included so it assumes the the default of 1433. If you’re on a different port, you need to put it after, e.g. localhost:1234. And of course change ‘master’ to whatever the name of your database is. More info here: [Building the connection URL - JDBC Driver for SQL Server | Microsoft Learn](https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017)

- The jdbc.driver to use is “com.microsoft.sqlserver.jdbc.SQLServerDriver”. You also need to copy the .jar file with the JDBC driver to your stardog\_install\_dir/server/dbms/ directory. You can download the file (and any other drivers) from our docs: [Home | Stardog Documentation Latest](https://www.stardog.com/docs/#_supported_jdbc_drivers)

And then username and password and that should do it.

Simon (Stardog PM)

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)
#### Post date: [August 1, 2019, 12:13am UTC](https://community.stardog.com/t/music-properties-example-for-sql-server-12-0/1786/3 "2019-08-01T00:13:40Z")

</div>

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