Failed to connect to a MSQL SERVER

Support
#1

Hello,

I try to create the DB for a project with MSQL database but I have the following errors:

Executing task 'createDb'...

> Task :myDB-core:assembleDbScripts UP-TO-DATE

> Task :myDB-core:createDb FAILED
[CubaDbCreation] Failed to execute SQL: drop database myDB;
Error: Login failed for user 'sa'. ClientConnectionId:57bf8936-091a-477d-886d-c5717f9f4a81

FAILURE: Build failed with an exception.
> [CubaDbCreation] Failed to drop database
(I am under Linux...)

Please advise!
-n

#2

Hi, Neutrino
Have you tested the connection to the database through “Data Stores”/“Main Data Store”, right clicking mouse “Edit Data Store” and pressing “Test connection”.
It seems the problem is the credentials for the database user “sa”.

Regards,
Xavier

#3

Yes. I already did. Connection failed!
I suspected that the problem is the credentials but I don’t know what should I do.

Thank You!
-n

#4

I tried to
ALTER LOGIN sa WITH PASSWORD=N’cuba’ but I have
Password validation failed. The password does not meet SQL Server password policy...
So I need to changed with a strong password…
I wonder why Cuba Team put this password default…

#5

Hi,
I don’t understand very well your scenario, because it seems that you are running a Cuba Platform application example.
You can change the database connection properties of the project at your needs. You can change the default password in the database connection properties by the right password of ‘sa’ user. Also, you can change too the user by another one you have defined as SQL SERVER login.

imagen

Regards,
Xavier

#6

Yes I already did. Now it works.
Just I wondered why Cuba Team did not choose another strong password.
Thank you Xavier!