I would like to register database with ArcGIS Server. I know it is done through ArcGIS Server Manager under Site / Data Stores / Register: Database.
I am also aware there can be different connection files (.sde or .odc) imported for Publisher database connection and Server database connection. I understand this option is primarily meant for access of different databases.
In my case I do need to access same database by both connections but Publisher database connection must be set through external IP (as desktop can only connect through external IP to DB server), while Server database connection through internal IP (ArcGIS Server can connect to DB Server only internally, can't see external IP). I hope till this point I get it right.
Now how do I create Server database connection (.sde file)? Is the only way to get .sde file (with internal IP) to install ArcGIS Desktop on the server machine? Is not that an awful thing to do to be able to create a tiny .sde file? Am I missing something?