I need to create a new sde service with the command line for the first time with mssql on ArcGIS Server 10.0 so that 3rd party software can access it. Direct connect will not work unfortunately.
As far as I can understand I need to do the following:
How could I find out which port numbers should I use?
5151 is the standard. you are welcome to select any port that is open by editing the services.sde file and adding it, or alternatively remove the comment mark # from the default entry.
Help can be found on the esri website.
It isn't strictly required to alter the services or services.sde file with SQL-Server, and if you don't specify a port or mnemonic with the -i flag at step 1, then step 2 is completely unnecessary (since it's too late to change from the default of esri_sde 5151/tcp). In fact, best practice is to add non-standard services entries before sdeservice -o create.
You left out using sdeservice to register the Admin_database key (required from command-line with SQL-Server for correct operation), which is why there's a GUI postinstaller -- to make sure critical things don't get missed.
