I found a solution which is to remove the word (microsoft ) from the connection url ,from <connection-url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=URDB</connection-url> to be like this <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=URDB</connection-url> and it will do the magic