Forum Discussion

ZubairCSC's avatar
ZubairCSC
New Contributor II
3 months ago

OneStream Connector Business Rule

Hi,

I am trying to establish a connection between OneStream and my local SQL server but getting below error.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (SQL Error Number -2146232060, -1)

Business rule and error

 

Connectors
    • ZubairCSC's avatar
      ZubairCSC
      New Contributor II
      3 months ago

      Thanks for your response.

      Can you please guide me how can we create custom connection in system config? Where does this system config located? can you share some screenshots?

      • DanielWillis's avatar
        DanielWillis
        Valued Contributor
        3 months ago

        Where is OneStream installed? On your machine? Your own hosting? Cloud? If it isn't installed on your local machine then it would not be able to use that connection string as it has no idea where your MZUBAI machine is.

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    3 months ago

    You do not 'need' SIC to get through a Firewall. IF you have a firewall blocking OneStream from accessing your database you may modify the firewall settings to allow OneStream through. In my mind, if required, this would be a much simpler option for your use case.

    • ZubairCSC's avatar
      ZubairCSC
      New Contributor II
      3 months ago

      I already have below firewall setting. Do I need to do something else?