I’ve lost the proper configuration of the two instances of sql server on SBS 2003 Premium SP1.
Sql Server Standard Edition ver 8.00.2039 (SP4)
Sql Desktop Engine ver. 8.00.2039 (SP4)
Using svrnetcn.exe I’ve enabled “named pipe” and “TCP on port 1433” for SHAREPOINT and only “named pipe” for SBSMONITORING but I don’t know if this is ok.
At first time I enabled “named pipe” and “TCP 1433” for all the two instances but then sharepoint central administration, companyweb, ecc. can’t connect the database after every computer restart.
In the sql log there was logged “Binding failed on port 1433” (translation from italian version) for the SHAREPOINT instance and only SBSMONITORING was listening on 1433 port.
Now only SHAREPOINT has TCP connection and is listening but I don’t know if this config is ok.