[resolved] Cannot connect to SQL Server 2008 - Windows Athentication
Hi there. This could be simple but I cannot get it. How do you connect to SQL Server using Windows Authentication? It looks like I Profiler wants me to use SQL Server authentication only... Am I missing something? Thanks.
Hi Darius, did you try to connect without setting a login and password?
Hi. I have found a reply on this forum: Currently SQL Server 2008 Windows Authentication is not supported.
I have created a standard SQL Server login and used it instead of win auth.
Best
Darek
Hi Darius, Could you elaborate how you got Talend to work with SQL Server 2005? I've tried using SQL Server authentication and that hasn't work for me. Thanks Jack
Hi, I do not reach to make run my TOS or TOP with Windows 7 and SQL Server 2008 R2. When I try to create a database connection, and after I click on button "Check" following error message appears "Check connection failure:login failed for user 'damien'. damien is a SQL Server user. Even with windows authentification user it's not running THanks in advance for your support. Damien.
I have found a reply on this forum: Currently SQL Server 2008 Windows Authentication is not supported.
Yes, TOP/TDQ change to use Microsoft JDBC driver and it don't support windows Authentication, to work round this, try to use MS SQL authentication. For TOS/TIS component, it use driver JTDS and it support windows Authentication by defaut.
Best regards
Shong
Hi,
After your advises to connect to my SQLServer 2008 with JDBC Driver with a SQLServer user, I still have some issues to make it run.
Perhaps the configuration is not the right, here below the configurations I filled in :
Driver JAR : C:\Program Files\Java\jdk1.6.0_15\jre\lib\rt.jar;
Driver class name : sun.jdbc.odbc.JdbcOdbcDriver
URL : jdbc:sqlserver://localhost:1433;DatabaseName=Test;zeroDateTimeBehavior=convertToNull&noDatetimeStringSync=true&characterEncoding=UTF-8
Error message is "Check connection failure:Can't create the connection!
Thanks in advance.
Damien.
I don't use MS SQL Server 2008 or Windows 7, but have you tried using an ODBC connection? Setting it up as a systems DNS might work. The windows authentication through an ODBC connections works perfectly for me with earlier verions of MS SQL server.
in Windows: open Control Panel -> Administrative tools -> Data Source (ODBC)
add your connection information to the System DNS section (tab System DNS). On 1st screen select SQL Server. Then on the next screen give it a name and provide the server information - remember the name you give your connection. You can specify on the 3rd screen the Windows Authentication.
in TOP: open Metadata -> Db Connections
add a db connection to the reporsitory. On the 2nd screen (step 2/2) select Generic ODBC in the DB Type field. Then enter the ODBC connection name to the DataSource field. Enter Login parameters in the form \ and don't forget your password. I'm not sure whether the last step is really needed, but it works for me.
Good luck.
