0

I am attempting to use Liquibase to deploy changes to SQL Server.

I have set up the sqljdbc jar file and placed it in my local maven repository. I then attempt to use the liquibase-maven-plugin to run the changes placed in the changelog for the given connection URL.

Here is what my connection URL is: jdbc:sqlserver://localhost:1433;user=Jenkins_BuildServices;password=hi;

I already created the login on my localhost and gave it sysadmin privileges. I also have made sure that the properties -> security is set to both SQL Server and Windows Authentication mode. Any ideas as to why the url being passed in is giving me back this error and not reading it from the URL?

Jens
  • 6,243
  • 1
  • 49
  • 79
Tyler Wells
  • 1
  • 1
  • This may be a [duplicate question.](http://stackoverflow.com/questions/14945075/receiving-sqlexception-login-failed-for-user-connecting-to-sql-server-2008) Looks like you need to pass in `integratedSecurity=true` to your JDBC URL. – BJones Jun 21 '16 at 21:50
  • That is for Windows Authentication though, is there a way to just use SQL Server Authentication that is what I am trying to use when getting the error – Tyler Wells Jun 22 '16 at 03:12
  • What does your `pom.xml` - especially the configuration for liquibase maven look like? Are you using property files? Did you go by the [documentation](http://www.liquibase.org/documentation/maven/index.html) of the liquibase maven plugin? – Jens Jun 22 '16 at 08:00
  • org.liquibase liquibase-maven-plugin 3.5.0 database.changelog-master.xml com.microsoft.sqlserver.jdbc.SQLServerDriver liquibase ${DatabaseURL} local debugfalse – Tyler Wells Jun 22 '16 at 13:27
  • com.microsoft.sqlserver sqljdbc4 4.2 – Tyler Wells Jun 22 '16 at 13:27

0 Answers0