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...

[briansms]

With regard to making MS SQL connections from TOS, I believe that you need to use SQL users/pwds for connections. Windows authentication is not currently supported. Is your server set to "SQL Server and Windows Authentication mode"?
As far as having that error in the management studio, not sure on that since I don't use the Express version.
- Brian

[Anonymous]

Hi All,
I am using talend open studio but when i create the MS SQL Server connection then talend gives me
error "host name is not found". My sql server 2005 name is : "SSS\SQLEXPRESS" and when i
filled this name in host name so error is coming "Connection failure. You must change the Database Settings.
Unknown server host name 'SSS\SQLEXPRESS'.
".
plz solve my issue .
Thanks,
SSS
Email : syed2uk@gmail.com

[Anonymous]

Hi All,
I am using talend open studio but when i create the MS SQL Server connection then talend gives me
error "host name is not found". My sql server 2005 name is : "SSS\SQLEXPRESS" and when i
filled this name in host name so error is coming "Connection failure. You must change the Database Settings.
Unknown server host name 'SSS\SQLEXPRESS'.
".
plz solve my issue .
Thanks,
SSS
Email : syed2uk@gmail.com

[briansms]

To use a MSSQL named instance in TOS, you only put the server name in the host field. The instance name goes in the Additional Parameters field. So you should try:
Login: yourDBlogin
Password: yourDBpwd
Server: SSS
Port: 1433
Database: yourdbname
Schema: dbo
Additional Parameters: instance=SQLEXPRESS

- Brian

[Anonymous]

Hi All,
I am using talend open studio but when I create the MS SQL Server connection then talend gives me
error "host name is not found" . My sql server 2005 name is : "SYED-PC\JAZZSQL" and when I
fill this name in server field then error is coming "Connection failure. You must change the Database Settings.
Unknown server host name 'SYED-PC\SQLEXPRESS'.
". I have been tried with only ?JAZZSQL? and with instance name but still error is coming.
plz solve my issue and give me result with snapshot plz.
Thanks,
SSS
Email : syed2uk@gmail.com

[briansms]

You'll need to specify your own db login, password and database name accordingly.
- Brian

[Anonymous]

Thanks very much briansms..

Take care ,
Bye bye
Syed

[Anonymous]

Thanks very much
engelm

[jb7]

i have a similiar problem, the connection don't know my data base user (login)
some idea??
thanks