Datastream connection test to SQL Server not passing

Google Cloud Serverless Applications
1

Hi, I am trying to create a connection to my self-managed SQL Server database and I keep getting this error message when I try to test the connection:

Login failed for user . ClientConnectionId: eef5f99c-6a8d-49bc-add8-c03ba50b11e7

I have checked that the login and password are correct directly in the database but nothing seems to work.

Can anyone give me a clue as to what might be going on? I don’t know if it could be a problem with permissions or something else. Please help me

2

Hi @SheldonYoungo ,

Welcome to Google Cloud Community!

You might want to take a look at this documentation to make sure your Datastream user was set up correctly. After creating your Datastream user, just follow the steps to create a connection profile for your SQL Server database. It’s a straightforward process, and the docs will guide you through it.

I hope the above information is helpful.