SQL Server 2019

Rank: #1670

Question

Hi all,

I have an enterprise license. My application server connects to SQL server 2019 in PROD and it works. But when I try to migrate SQL server 2016 to 2019 in UAT it shows a login error.

By the way, using the same user name and password I could connect the DB from SQL Server Management studio.

1) Is the login error because of the version? If so, how it works in PROD?

2) Is there any other reason which causes this connection error?

3) As Outsystems does not support SQL server 2019, instead of downgrading my PROD DB to 2016, is there any workaround to change the compatibility?

Regards,

Abirami Srinivasan

on 2020-12-31

Hélder Anselmo

Rank: #2879

Hi Abira,

I don't think it's related with the version. It might be related with the fact that you did the upgrade and something is missing.

Did you try to execute the configuration tool in the QA environment? If you "test connection" in the configuration tool, what does it say?

Maybe the trick is really to run the configuration tool and press "Grant Permissions".

Cheers.

on 3rd Jan

8 replies

Last reply on 4th Jan

Show thread

Hide thread

Abira

Rank: #1670

Hi Helder,

Yes, "test connection" works for the QA environment. Could you explain more about the "Grant Permission".

Regards,

Abirami Srinivasan

on 4th Jan

Hélder Anselmo

Rank: #2879

Replying to Abira's comment on 04 Jan 2021 05:11:38

Check the image attached. In the configuration tool there's a button to Grant permissions to database users.

Maybe this step was missing when you did QA?

Cheers.

Capture.PNG

on 4th Jan

Abirami Srinivasan

Rank: #67041

Replying to Hélder Anselmo's comment on 04 Jan 2021 08:10:54

I followed this step too. If the user does not have permission, how could I connect to the DB using the same user from the SQL Server Management studio.

on 4th Jan

Hélder Anselmo

Rank: #2879

Replying to Abirami Srinivasan's comment on 04 Jan 2021 08:25:29

So, for my understanding:

You can connect to dataase QA_Outsystems (or the cluster where this database is..) using the user OSRUNTIME ? (by using SQL Server Management Studio and user's credentials as the ones in the configuration tool)

After you do, can you do queries at random tables in the database (using the OSRUNTIME user) ? Do they work?

on 4th Jan

Abirami Srinivasan

Rank: #67041

Replying to Hélder Anselmo's comment on 04 Jan 2021 08:36:10

Yes. You are right. I did query the tables and I got the results.

on 4th Jan

Hélder Anselmo

Rank: #2879

Replying to Abirami Srinivasan's comment on 04 Jan 2021 08:45:53

Are there any other differences in the infrastructure between QA and Live environment?

on 4th Jan