I was working my way through the PWS setup but i can't seem to get it to work with a custom port for the database.
If i run the setup on the default ports, the database will be created.
when i'm at the Database settings page, i enter the DB server, instance name and credentials (i've obscured some details)
My MSSQL is setup according to the SQLExpress 2019 documentation and both PWS and SQL run on the same machine.
when i test the connection, i get positive results.
But when i click next, it start to try and create the PWS database and user, but it returns an error.
i've edited the SQL Server Network Configuration as described in the documentations
Unfortunately, i can't seem to get it to work on a custom port. I tried changing the "Listen All" setting to no avail. Nor did it help to enable the "Named Pipes" setting or enabling the SQL Server Browser.
When i open Microsoft SQL Server Management Studio and try to connect to the servername: HOSTNAME,PORT\SQLSERVER i can connect just fine.
testing it with a powershell command:
powershell -Command "Test-NetConnection -ComputerName 'HOSTNAME' -Port 12345" says the TcpTestSucceeded: True.
The strangest thing i see is when i look in Event Viewer. After i restart the SQL Server service, i see the Event ID 26022 initially show the correct port i specified.
Server is listening on [ any <ipv4> 12345].
but a fraction of a second later, it shows a random port but for localhost:
Server is listening on [ 127.0.0.1 <ipv4> 49699].
I'm a bit at a loss here what i can see/do to fix this problem. Maybe i've missed something during the SQL setup or i'm configuring PWS wrong. Hopefully you can help me out here.