How To
- Approve order function.
- Cost Activities
- How does the “Approved Supplier” (QA status) functions work?
- How does the Approve direct purchases onshore work?
- How does the rule-based approval matrix work?
- How To - Set Failure Report Running Number
- How To - Add SQL Server to Windows Firewall Exception
- How To - Access the report template editor
- How To - Accounts and Budget (v. 2.662 and later)
- How To - Active a unit for use with the Incidents Module
- How To - Add same document on multiple components
- How To - Approve Purchase Orders and Change Requests when using Approval Rules and Change Approval
- How To - Assign user rights
- How To - Automatically resize images
- How To - Backup TMv2
- How To - Cancel Job History (Job Signed Out In Error)
- How To - Cancel job history (Video Link)
- How To - Catalogs
- How To - Change a Unit Code in TM Master V2
- How To - Check for File Not Found Error. Document Handling.
- How To - Circulating Components
- How To - Company tags
- How To - Connect the TM Master v2 Client Application
- How To - Connect the TM Master v2 client to more than one database
- How To - Contract Management
- How To - Copy Components, Component Jobs and Spare Parts
- How To - Create a new unit
- How To - Create a New User TM Master v2
- How To - Create and use batch jobs in TM
- How To - Create Credit Note
How To - Add SQL Server to Windows Firewall Exception
How to add SQL Server to Windows Firewall Exception
- Open Windows Defender Firewall with Advance Security. (Using windows key and type).
- Adding sqlsvr.exe
- Create New Inbound Rule, Select Rule Type as ‘Program’, click on Next button.
- Click the "Browse" button and then navigate to you SQL Server installation path and click next. I.e: ‘C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2014\MSSQL\Binn\’
Here, choose the file called sqlservr.exe and add it. The navigate to:
- Allow the connection for Action, click next.
- Specify all the profiles for which the rules applies, click next.
- Give an appropriate name for the rule, click finish.
- Adding Inbound Rules for TCP PORT.
- Create New Inbound Rule, Select Rule Type as ‘Port’, click next button.
- Select port as ‘TCP’ and Specific local port as ‘1433’, click next.
(Generally local ports ‘1433' will be the same in most cases. If it is not same then it should require to check in the sql server configuration manager.)
- Allow the connection in Action and click next.
- Specify all the profiles for which the rules applies, click next.
- Give an appropriate name for the rule, click finish.
- Adding Inbound Rules for UDP PORT.
- Create New Inbound Rule, Select Rule Type as ‘Port’, click next button.
- Select port as ‘UDP’ and Specific local port as ‘1434’, click next.
- Allow the connection in Action and click next.
- Specify all the profiles for which the rules applies, click next.
- Give an appropriate name for the rule, click finish.
Once finished all the settings, test the database connection between the server computer and the client/bridge computer.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article