By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger > Technical | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.


(T0131) How to determine the port number SQL Server is using with ServiceLedger's MSDE

Would you like to...

Print this page
Email this to a friend

These instructions only apply to MSDE 2000 installations performed by ServiceLedger installation programs.

 

1) Go to Start->Run

2) Type in RegEdit

3) Click run or ok

4) Using the explorer, locate the following key:

My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SERVICELEDGER\MSSQLServer\SuperSocketNetLib\Tcp

5) Note the value of the TCPPort and TCPDynamicPorts fields

6) Close the registry editor

 

All unique values listed plus UDP port 1434 should be enabled for bypass in the local network on firewall and routers so that the client application can communicate with the specified server.  Additionally, the SQL Server should allow "File and Printer Sharing" for the local network (UDP/TCP 135-139) if referred to by machine name on the workstations.

 

ServiceLedger client applications may or may not use UDP port 60981 & TCP port 8080 depending on your configuration.  TCP Port 8080 is only for automation servers used by web portals ServiceLedger provides.  UDP 60981 is used for record update broadcasts and may not be necessary unless you notice refresh issues.


Related Questions:

Attachments:

No attachments were found.


ServiceLedger KnowledgeBase Copyright © 2019 support.serviceledger.com
Powered by AcitveKB Knowledgebase Software