Thank you for all the replies, but as the error message stated, looks like its asking to specify a driver. Adding the ?driver={name of DSN for the sql server driver that was created} in the connection string solved my issue. 

here's my connection string:

"mssql://{username}:{password}@{ipaddress}/{databasename}?driver={name of DSN for the sql server driver that was created}"