New reply on DataCleaner's online discussion forum (https://datacleaner.org/forum):
Arjan replied to subject 'Can't connect to MS SQL Server with Windows Authentication' ------------------- Hi Sue, You should be able to get it to work using the official MS SQL Server driver, but it requires some extra configuration outside DataCleaner. I was able to get it to work using some hints from this stackoverflow discussion: [https://stackoverflow.com/questions/16497998/jdbc-connection-to-mssql-server-in-windows-authentication-mode jdbc-connection-to-mssql-server-in-windows-authentication-mode]. So in short: * Download sqljdbc_auth.dll which is part of a zip file available on[https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774]. * Copy it to your \Windows\System32 folder. * Then in DataCleaner create a SQL server connection using the official MS SQL Server driver (the one with driver class name com.microsoft.sqlserver.jdbc.SQLServerDriver. * For the connection string fill in somethink like this: jdbc:sqlserver://localhost;databaseName=datacleaner;integratedSecurity=true, make sure to add the ";integratedSecurity=true" part. * Fill in your username (I had to include domain, so for me it looked a bit like this: "MYDOMAIN\arjans". * And fill in your windows password. For me that worked. Good luck, Arjan Seijkens ------------------- View the topic online to reply - go to https://datacleaner.org/topic/2956/Can%27t-connect-to-MS-SQL-Server-with-Windows-Authentication -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/d/optout.
