Error tds protocol

Hey everyone,

In my config.exs

config :bebemayotte, Bebemayotte.EBPRepo,
  adapter: Ecto.Adapters.Tds,
  username: "sa",
  password: "@ebp78EBP",
  database: "Bbmay",
  hostname: "EBP_2017",
  port: 1433,
  show_sensitive_data_on_connection_error: true,
  pool_size: 10

but when i start the server by mix phx.server i got this error:

[error] Tds.Protocol (#PID<0.642.0>) failed to connect: ** (Tds.Error) tcp connect: nxdomain

I don’t know what is the problem!!

Someone can help???

Thank you

nxdomain means there is no such domain name. Can you ping the host? try: ping EBP_2017


I change my hostname by a server name but i have this new error:

[error] Tds.Protocol (#PID<0.596.0>) failed to connect: ** (Tds.Error) Line 1 (Error 18456): Échec de l'ouverture de session de l'utilisateur 'Sa'.

How i can fix it??

My translator says, this means “user login failed”, so you probably used wrong user credentials?

Thanks guys, I fix my problem:

In beginning
hostname: “******\####”

but i separate this to that to fix the problem:

hostname: “******”
instance: “#######”

Thank you

1 Like


  • Formatting those code blocks with backticks (`).
  • Accept your own answer to increase visibility for future readers.