topic Re: Mysql Server connection error in Talend Studio

Mysql Server connection error

BNP — Mon, 06 Apr 2020 18:50:01 GMT

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

Re: Mysql Server connection error

Jesperrekuh — Mon, 06 Apr 2020 20:40:23 GMT

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.

Re: Mysql Server connection error

Ganshyam — Wed, 08 Apr 2020 06:27:52 GMT

Hello,

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

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