Error when trying to connect MS SQL Server 2005

[Anonymous]

When I configure the MS SQL Server connection I have this error :
"I/O ErrorSO Failed: Native SSPI library not loaded. Check the java.library.path system property"
I still have the same problem in MS SQL Server Management Studio Express when I need to see Properties for a table in a Database.
Thank you for your help...

[Anonymous]

Hi 28Khyati,
Did you restart your sql server brower? Can you connect to your sql server express without using Talend tool.

Best regards
Sabrina

[_AnonymousUser]

Hi Sabrina,
Yes, I did that successfully too. 
Thanks
Khyati

[Anonymous]

xdshiHi,

The studio version am using on talend is  V5.4.1. I can connect to my sql server directly with DB tools.

Sorry for delay.
What's your sqlserver authentication?
Usually there are two ways to connect to sqlsever: sql server authentication and windows authentication
If you use windows authentication , you need put ntlmauth.dll (library for windows authentication)into
c:\windows\system32 and /.
Restart talend product.
Let me know if it is OK with you.
Best regards
Sabrina

[_AnonymousUser]

Please provide solution  without using "ntlnmauth.dll" how to connect MSSql server(Windows authentication mode) with help of tMSSQL_Connection.
 because I don't have permission for "System32"

[_AnonymousUser]

Hi all, i am using the Talend 6.1 in  CentOs and I want to store the oracle db data to MS Sql server table in different machine with windows 10 OS.
What are the steps i need to follow can anyone help me...
Thanks and Regards
 

[Anonymous]

Hi,
With talend open source, if you want to migrate  oracle db data to MS Sql server table, you need to create many subjobs for each table, each subjob is used to migrate data from one table to another table. If the table does not exist in Mssql DB, you can create it by checking the option 'create table if not exist' in the action on table list on tMssqlOutput component.

Best regards
Sabrina

[Anonymous]

Hi,
I added " ntlmauth.dll" to  c:\windows\system32 and  <TALEND studio="" install="" dir=""></TALEND>.
Didn't help. Still timeout error message:
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: Login timed out.
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
....
Caused by: java.sql.SQLException: Login timed out.

Any ideas?

I use:
Login: <MYLOGIN></MYLOGIN>
Password: <MYPASS></MYPASS>
Server: LAPTOP_ELQ2Q8QT
Port: 1433
Database: <MYDB></MYDB>
Schema: 
Additional Parameters: instance=SQLEXPRESS

[Anonymous]

Hi,
Can you successfully connect to your mssql server by client without using talend tool? On which build version you got this issue?
Best regards
Sabrina

[Anonymous]

Yes. I'm able to connect to MS SQL server via Microsoft SQL server management studio.
The issue is on built 6.2.1
Dan

[Anonymous]

Hi,
Are you trying to connect local SQL server or remote?
If you are trying to connect local SQL server, h ave you tried to use  localhost or  127.0.0.1 to see if the connection is Ok?
Best regards
Sabrina