When you use SQL Server Management Studio to connect to the DB server, the Server Name used in the Connect to Server dialog window is what you should use as the SQLCA.ServerName property value:

SQLCA.DBMS = "MSO"
SQLCA.ServerName = "xxxxxxxxxxxxxxxxxxxx"  // Same ServerName value used in SMSS.
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='xxxxxxx',TrustedConnection=1,DateFormat='mm/dd/yyyy',DateTimeFormat='mm/dd/yyyy hh:mm:ss',TimeFormat='hh:mm:ss'"

I personally prefer using Windows Authentication (Windows login/password) for my SQL Server login. This translates into the DBParm: TrustedConnection=1, as shown above. You may not need to specify DateFormat, DateTimeFormat and TimeFormat settings, but I use these parms so I've included them here.

I'm including below a link to some information regarding connecting to SQL Server from PB that I recommend you read through and might find helpful:

   https://docs.appeon.com/pb2019r3/connecting_to_your_database/ch03s04.html

Best regards, John

If using PB 2019 R3, you need to install v18 of the MSOLEDBSQL driver (not v19): https://www.microsoft.com/en-us/download/details.aspx?id=56730&WT.mc_id=DOP-MVP-37580

You also need to deploy additional runtime DLL with your app: PBMSOLEDBSQL.dll

As far as the connection string, just create a DB profile in the PB IDE and it will provide you the correct syntax: https://docs.appeon.com/pb2022/connecting_to_your_database/Using_database_profiles.html#XREF_83605_Creating_a