This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Datastream connection test to SQL Server not passing

Posted on 09-26-2024 08:28 AM
SheldonYoungo
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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 <myusername>. 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

0 1 91
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
mcbsalceda
Staff
Reply posted on --/--/---- --:-- AM

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.

0 Likes