Hi!
I'm trying to follow the Elevate Session from 2022 to set up a dynamic SQL Server database for housing the PowerServer caches. I am using PowerBuilder 2022 R3, which looks different than the presentation I watched.
https://www.youtube.com/live/a5U4XblFJbA
In my AppConfig.json file I modified the connection string based on what I could see in the video. I think there may be something wrong with it that I hope someone can point out to me.
"ConnectionStrings": {
"AppConfig": "Data Source=HSMSOHDB\\v200,64892;Initial Catalog=MicroMD;Integrated Security=False;User ID=XXXX;Password=XXXXXXXX;Pooling=True;Min Pool Size=0;Max Pool Size=100;TrustServerCertificate=True;"
}
Then I changed AppConfigExtensions.cs to only have the SQL Server configuration.
When I run the ServerAPIs, the command shell opens and doesn't report any errors, but I'm not seeing any tables created. Any idea how to troubleshoot this one?
Thanks!
John