Sample Header Ad - 728x90

Report Builder cannot publish to report server

1 vote
1 answer
1115 views
This is currently in a cloud lab environment. We're not allowed to join any AD domains. We have a linux server (RHEL 6) running MySQL 5.3 and a Windows SQL Server 2012 on Win 2k8 R2. Our laptop is Win 7 64bit running Report Builder 3.0. We created an OBDC connection to the MySQL database and are able to build reports in Report Builder. However, if we add the connection to the report server (http:// IP_ADDRESS/reportserver) it gives us the following error when trying to publish: > For more information about this error navigate to the report server on > the local server machine, or enable remote errors. > > Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) > > An error has occurred during report processing. (rsProcessingAborted) I am able to open SQL Management Studio locally on my laptop and connect to the remote SQL server without issue.
Asked by user37336 (19 rep)
Apr 21, 2014, 08:15 PM
Last activity: Jan 22, 2018, 02:17 PM