I'm currently trying to build a small PowerApps application, mainly to mess around with it and learn what it can do. I have a gateway on my desktop that PowerApps has connected to, but whenever I try and create a connection I get the following error: Credentials are missing or not valid. inner exception: The credentials provided for the SQL source are invalid.
I'm not sure why it's refusing to connect.
So far I have:
What now?
Edit: I am using SQL Server 2017
I was using SQL Server 2017 - Express Edition, which does not have the SQL Server Agent available. This was rectified by switching to Developer Edition, which was suitable for my purposes.