I am trying to setup cloudflare as proxy on internet facing sql server.
I have an azure database server and a test database with me which I can access thru SSMS but when I am trying to setup a spectrum as TCP proxy to origin (at DNS name by azure - db server name) over port 1433, it gets failed. Giving me some authentication error.
Authentication mode I am trying in - SQL
Database name is precisely mentioned under SSMS parameters.
Error codes received under SSMS - 10054, 64
I had earlier tried making ftp proxy under cloudflare - spectrum and worked fine. Not sure if Cloudflare allows using spectrum as proxy to public facing sql servers. Spectrum feature is supposedly been allowed on any TCP/UDP applications. So I guess sql server.
Has anyone ever tried setting up the similar and got success ? If yes, any tips you can share please ?
*** NOTE: why am I trying out on azure, because I don`t have right now public facing sql server hosted on premise. So thought azure can be used since spectrum allows defining origin reference as DNS record as well as IP address. Also I whitelisted Cloudflare IPs already under Azure - SQL firewall so that it permits traffic thru cloudflare into azure.
Thanks & Regards,