Question: I work behind a corporate firewall. I need pymssql library to use some queries. I try installing via pip, which gives me the error: 

> 
> 'pip is configured with locations that require TLS/SSL, however the ssl module in Python is not available.'
> 
> 
> 

I install openssl as mentioned by multiple answers in this site from <https://slproweb.com/products/Win32OpenSSL.html>. I get the same error even after installation.

I set http\_proxy and https\_proxy in the system variable and try again. I get the same error

I set the above proxies via command prompt and do a pip/easy\_install. Same issue

I try the --trusted host method in pip. Same issue.

After this, I download the package manually and do a python setup.py install, which gives me an error:

> 
> 'Microsoft 14+ build tools are required'
> 
> 
> 

I download the build tools, hoping this will solve the issue, But i get the same error

How can I solve this? I tried with proxy, without proxy and all combinations of the above. Why is my build tools installation not recognised?

Note: I do not have anaconda and i have never used it.

Answer: 
Ok figured this out after paying more attention to the error message. In packages\Umbraco.SqlServerCE.4.0.0.1\build\Umbraco.SqlServerCE.targets it needed the namepsace i added it there and now it builds.

Issue now is figuring out how to get updated package for that dependancy
I just wanted to expand on Ismail's answer.

His solution is correct however if you are wondering on how to add the namespace and get it running the file should look like this:

[Solution](https://i.stack.imgur.com/l6FBw.jpg)