
I double checked everything, tried changing login information just to be safe to rule out any kind of errors there.basically I'm just a bit stumped. It's worth noting that if I just go the route of Get Data > Other Sources > Microsoft Query, I can bring in the data no problem. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)'. We encountered an error while trying to connect.ĭetails: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. since this morning i suddenly have this message 'DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. The second server always throws up this error when I try to connect via Power Query: One server (two databases) both connect flawlessly. I currently connect to three databases across two servers today. I'm happy to provide any additional details that I'm able to, but here's what I've got so far. Basically, I am having trouble connecting to one of our servers via Power Query.

Hi everyone, so my title pretty much says it all.
