I tested below code with SQL Server 2008 R2 Express and I believe we should have solution for all 6 steps you outlined. Let’s take on them one-by-one: 1 – Enable TCP/IP We can enable TCP/IP protocol with WMI: set wmiComputer = GetObject( _ “winmgmts:” _ & “\\.\root\Microsoft\SqlServer\ComputerManagement10”) set tcpProtocols = wmiComputer.ExecQuery( _ “select * … Read more
Well, glad I asked. The solution I finally discovered was here: How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433? Run SQL Server Configuration Manager. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS. Make sure TCP/IP is enabled. So far, so good, and entirely expected. But then: … Read more
You can run Postgres this way (map a port): docker run –name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d -p 5432:5432 postgres So now you have mapped the port 5432 of your container to port 5432 of your server. -p <host_port>:<container_port> .So now your postgres is accessible from your public-server-ip:5432 To test: Run the postgres database (command above) … Read more