Set up proxy settings to allow the BO Service account to pass through our firewall and access the DB

[former_member211289]

Hello All,

We are unable to connect BO with snowflake database and we found one solution in forums.

Could you please help me how to setup proxy settings to allow the domain (BO Service account) account to pass through our firewall and access the snowflake database.

Issue: Universe Design Tool to connect to Snowflake from one of our servers.

Update from forums:

The problem was our domain account that was running the SIA was not configured to use the appropriate proxy settings.

We had to run Internet Explorer as the service account and set the proxy settings to the appropriate ones in order to connect.

Once we made this change, everything works.

We have successfully created a universe and a Web Intelligence report against Snowflake using the Generic ODBC3 middleware.

In other words, We had to run Internet Explorer on our BI Servers as the domain account running our SIA and set up proxy settings to allow the domain account to pass through our firewall and access the snowflake database.

BO Server is using our computer's system proxy settings to connect to the snowflake.

Thanks

Ramanaidu

[denis_konovalov]

Sounds like you need a proper windows Administrator to look at your servers and their network setup.
I think windows (Microsoft) forums might be a better place to seek help for this situation.

Here is why :
The proxy settings in the Internet explorer govern internet access and network access for all users/accounts, unless your group policies or user access restrictions do not allow that - this is pure windows/network management.
If a domain account is not able to use network properly on windows machine - your domain and local security policies are not right. which is again pure windows/domain management.

this is not snowflake or SAP/universe/IDT issue.

Without knowing sensitive details about your network and security, it would be impossible to help you. And you should not share those details here.