Hi @dra, welcome to the Wappler community!
You will require SQL Authentication setup on your SQL server to be able to access your SQL databases remotely say from Wappler. Windows authentication setup will only work on a local machine. Both SQL and Windows Authentications can be used interchangeably when using SSMS on the server locally.
Did you setup Mixed Mode of Authentication when installing SQL server? With this authentication mode, you can setup in-built SQL System Administrator (sa) account and use that to access SQL databases remotely. It is strongly recommended to setup SQL logins within SSMS to access all or specific databases depending upon your requirements.