JaY0,
Can you telnet to this sql server instance from your local machine?
Also, what does your connection string look like - I assume that you’re using the dblib driver. Most of these issues are related to cloud security in some fashion. Have a look here, though it is with Azure, still provides some useful hints.
Let me know about your progress.
Thanks,
- Mark