Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BNP
Contributor
Contributor

Mysql Server connection error

Hi,

 

I'm new to this technology. I'm using  Microsoft SQL server management studio. While setup the Microsoft SQL server.I'm getting error. I have attached the error screenshot. Can help me this out

 

I'm using windows authentication credentials  to login Sql server

 

 

Labels (2)
2 Replies
Jesperrekuh
Specialist
Specialist

Im not sure about your config regarding MSSQL be aware of a \ its a special char and used for escaping in Java ,  so you probably need 2 slashes like \\ , never tested it or had to use it while configuring a connection.

Test your connection first with a component before adding a connection metadata.

 

Integrated security stuff recommend read the MS docs for parameters.

 

Ganshyam
Creator II
Creator II

Hello,

 

If you are able to login to DB server the same credentials needs to be used for Talend Connection.

 

0683p000009M9P7.png

 

Please make below changes to talend connection:

 

1) Login will be your username of the DB.

2) Server will be the servername, which will be the IP  host.

3)  You don't need to have backslash.

 

Hope this helps.

Regards