The way I reproduced the issue was by doing the following on my lab setup which was configured for Basic Authentication: The underlying issue is still the same as the other messages. When ever you see “error: 26 - Error Locating Server/Instance Specified”, it is SQL Browser related. This lookup is fielded by SQL Browser over UDP port 1434. Named Instances have to do a lookup to get the port number for the actual instance we are connecting to. The other two are when we are trying to connect directly to the SQL Server. The first error is specific to a Named Instance server. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Verify that the instance name is correct and that SQL Server is configured to allow remote connections. The server was not found or was not accessible. (provider: TCP Provider, error: 0 - The requested name is valid, but no data of the requested type was found.)Ī network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Ī network-related or instance-specific error occurred while establishing a connection to SQL Server. When they try to create a new report through Report Builder, they encounter errors similar to the following:Ī network-related or instance-specific error occurred while establishing a connection to SQL Server. In all of the cases, reports and Report Builder function normally locally. This is where the problems come into play when a firewall is involved. Some examples of that are the Query Designer and general Metadata lookup for the DataSet. There are other aspects that will run Client Side. This is assuming that we are in connected mode in Report Builder.
For example, DataSource retrieval and preview of a report. There are some aspects of Report Builder that will run server side (from the context of the Report Server). Some were using Named Instances, others were using a Default Instance for the Data Source. In this scenario, the customer has a data source defined on the Report Server. We have had a few customer calls come in on this scenario that I thought this needed to be documented a bit.
0 kommentar(er)
