Hello,
I am in the process of developing a .Net application which will connect to one of my VM servers. Through this server, and ONLY through this server, another VM server is accessible which contains my SQL databases.
Currently I am having trouble accessing through my desktop application the SQL server database through a port being used for OMNI service. I connect successfully but then it throws me a general error during the handshake process and errors out.
After speaking with some developers, there are several solutions I could do to achieve my goal, however I want this to remain an independent desktop application for internal company use which means I either need to build a web service to call my data or open a Port (1433) to my understanding.
Since I am new to .Net, I do not want to figure out how to build a web service, thus I am leaning towards opening Port 1433 on the VM server I am initially connecting to. There are many risks involved in doing so though, and I wish to minimize those risks. If I restrict RDP access to only machines (anyone with the desktop app) I want to access port 1433, would this minimize the risk? If not, what would be the best way to go about doing so?
Any help would be appreciated. Thank you for your time!
I am in the process of developing a .Net application which will connect to one of my VM servers. Through this server, and ONLY through this server, another VM server is accessible which contains my SQL databases.
Currently I am having trouble accessing through my desktop application the SQL server database through a port being used for OMNI service. I connect successfully but then it throws me a general error during the handshake process and errors out.
After speaking with some developers, there are several solutions I could do to achieve my goal, however I want this to remain an independent desktop application for internal company use which means I either need to build a web service to call my data or open a Port (1433) to my understanding.
Since I am new to .Net, I do not want to figure out how to build a web service, thus I am leaning towards opening Port 1433 on the VM server I am initially connecting to. There are many risks involved in doing so though, and I wish to minimize those risks. If I restrict RDP access to only machines (anyone with the desktop app) I want to access port 1433, would this minimize the risk? If not, what would be the best way to go about doing so?
Any help would be appreciated. Thank you for your time!