The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
ZubairCSC
1 year agoNew Contributor II
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
12 Replies
- naveen1New Contributor II
Create a custom connection in Systeam config
- ZubairCSCNew Contributor II
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?
- DanielWillisValued Contributor
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.
- DanielWillisValued Contributor
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.
- ZubairCSCNew Contributor II
I already have below firewall setting. Do I need to do something else?
Related Content
- 9 months ago
- 1 year ago
- 4 months ago