Run configuration manager
Expand SQL Server Network Configuration
Select Protocols for ETRACK
Double Click TCP/IP to bring up proeprty dialog (shown below)
Scroll to bottom sectionIPALL
remove port in TCP Dynamic Ports
Enter 6464 in TCP Port
Click okay.
Restart ETRACK SQL Server instance

After you do this need to make adjustment to etrack.config file on the server in Programs folder – Need to add static port (6464 from above) to the etrack.config file in the DataSource line as shown below (Shown in red):

<?xml version=”1.0″?>
<Configuration>
<Server>
<eTrackVersion>1000</eTrackVersion>
<UpdateExec>\\CAIRO\ETRACK\Programs\Update.exe</UpdateExec>
<Path>\\CAIRO\ETRACK</Path>
<UpdateIni>\\CAIRO\ETRACK\Programs\etrack.config</UpdateIni>
</Server>
<File>
<Name>etrack.exe</Name>
</File>
<File>
<Name>etrackconfig.dat</Name>
</File>
<Database Name=”Production” UseIdentity=”true” StrongPassword=”true”>
<Comment>eTrack Production Database</Comment>
<Provider>SQLOLEDB</Provider>
<DataSource>CAIRO\ETRACK,6464</DataSource>
<DatabaseName>etrack</DatabaseName>
<Username>etrackuser</Username>
<ConnectTimeout>120</ConnectTimeout>
<BackupPath>C:\eTrack\Programs\</BackupPath></Database>
<ConfigDB>\\CAIRO\ETRACK\Programs\eTrackConfig.mdb</ConfigDB>
<Maintenance UseTransaction=”0″></Maintenance>
<ErrorLog Active=”0″>
<File>eTrack.log</File>
<Size>500</Size>
</ErrorLog>
</Configuration>

Posted in: eTrack FAQ, Server and Databases