Skip to main content
Z
ZubairCSC
October 29, 2024

OneStream Connector Business Rule

  • October 29, 2024
  • 2 replies
  • 0 views

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 errorBusiness rule and error

 

2 replies

N
naveen1
October 29, 2024

Create a custom connection in Systeam config 

Z
ZubairCSCAuthor
October 29, 2024

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?

D
DanielWillis
October 29, 2024

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.

D
DanielWillis
October 30, 2024

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.

Z
ZubairCSCAuthor
October 30, 2024

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

 

ZubairCSC_0-1730329485901.png

 

Terms & ConditionsAccessibility statement