[datacleaner.org] New reply by tmmackay to topic: Howto connect to SQLServer with integratedsecurity

[not...@eobjects.dk]

Dear dataclean...@googlegroups.com,

There is a new reply by tmmackay to the topic at the DataCleaner forum: Howto connect to SQLServer with integratedsecurity

-------------------

I don't know if anyone's still trying to figure out how to do this, but I have this working and here's what I did.

1) Download JDBC driver from Microsoft and unzip.

2) Copy the file "sqljdbc4.jar" into the .\DataCleaner\lib folder. If you do this, you don't have to worry about classpaths.

3) Copy the file "sqljdbc_auth.dll" from the "auth" subfolder of the Microsoft JDBC Driver folder (use either the x86 or x64 version depending on your version of the JVM); copy this file into the .\DataCleaner folder (the same folder that has DataCleaner.exe). If you do this, you don't have to worry about the environment variables.

4) From the DataCleaner Options menu, select the "Database drivers" tab and click "Add database driver".

5) Enter com.microsoft.sqlserver.jdbc.SQLServerDriver as the Driver class name.

6)Select "Local jar files" and browse to the lib folder and select the jar file you copied above. Click "Add database driver"

7) You should now be able to select "Microsoft SQL Server (official)" from the list of more datastore types.

8) When creating the connection string, use the format below:

jdbc:sqlserver://<hostname>;instanceName=<instancename>;integratedSecurity=true;databaseName=<databasename>

I was unable to get it to connect when passing a port number, so I suggest if you aren't using the default instance that you use the instance name syntax shown above. It's working very well for me with integrated windows authentication on a SQL Server 2008 server using a non-default instance and database.

-------------------

Please visit this URL to follow along in the discussion: http://datacleaner.org/topic/94/Howto-connect-to-SQLServer-with-integratedsecurity

[not...@eobjects.dk]

Dear dataclean...@googlegroups.com,

There is a new reply by tmmackay to the topic at the DataCleaner forum: Howto connect to SQLServer with integratedsecurity

-------------------

I don't know if anyone's still trying to figure out how to do this, but I have this working and here's what I did.

1) Download JDBC driver from Microsoft and unzip.

2) Copy the file "sqljdbc4.jar" into the .\DataCleaner\lib folder. If you do this, you don't have to worry about classpaths.

3) Copy the file "sqljdbc_auth.dll" from the "auth" subfolder of the Microsoft JDBC Driver folder (use either the x86 or x64 version depending on your version of the JVM); copy this file into the .\DataCleaner folder (the same folder that has DataCleaner.exe). If you do this, you don't have to worry about the environment variables.

4) From the DataCleaner Options menu, select the "Database drivers" tab and click "Add database driver".

5) Enter com.microsoft.sqlserver.jdbc.SQLServerDriver as the Driver class name.

6)Select "Local jar files" and browse to the lib folder and select the jar file you copied above. Click "Add database driver"

7) You should now be able to select "Microsoft SQL Server (official)" from the list of more datastore types.

8) When creating the connection string, use the format below:

jdbc:sqlserver://<hostname>;instanceName=<instancename>;integratedSecurity=true;databaseName=<databasename>

I was unable to get it to work by passing a port number, so I suggest if you aren't using the default instance that you use the instance name syntax shown above. It's working very well for me with integrated windows authentication on a SQL Server 2008 server using a non-default instance and database.