Manual activation is the standard protocol for or servers behind strict corporate proxies . It ensures that your productivity isn't hindered by network security policies, allowing you to use features like advanced IntelliSense, code formatting, and refactoring regardless of your connectivity status.
If your SQL Server machine has no internet access, follow these steps to activate SQL Prompt: redgate sql prompt offline activation