I am a network engineer and am working with our SharePoint / SQL folks to resolve the following problem. We get the following error when trying to connect to a data source with the query designer. "An error occurred while connection to data source 'DataSource1'. Only the text-based query designer will be available." In the Details of the error it says: "A network-related or instance-specific error occerred while establishing a connection to SQL Swerver. 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: Named Popes Provider, error: 40 - Could not open a connection to SQL Server) I know this is a long error message, but I'm hoping someone out there has seen this and has an easy resolution to the problem. Thanks!

The above error message is generic message when the connectivity fails to the backend SQL Server. The database we are trying to connect from ReportBuilder, is it on the same machine or a different machine? Did we check the regular connectivity from the ReportBuilder machine to the DB Server? Try these: From the Remote machine, try to do a Telnet to the server on the SQL Server port. If this is failing, then probably the port might be blocked. Try to force the TCP/IP protocol for connecting to the Server from the remote machine. You can use tcp:ServerName,PortNumber and check the connectivity from SSMS remotely. You can also try forcing NamedPipe protocol, if that is enabled on Server. On the remote machine, check if there are any aliases created. Goto Start>Run>cliconfg. This will open Client Network Utility. On the aliases tab, check if there are any aliases created for this server. If there are, try to delete them and check the connectivity. http://technet.microsoft.com/en-us/magazine/dd450973.aspx [Configure Remote Server Connections] Hope this helps!! Chaitanya

Hi, Besides Chaitanya's reply, more information about Troubleshoot Connectivity Issue, please see http://blogs.msdn.com/b/sql_protocols/archive/2005/12/22/506607.aspx Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi MCSE-RHartman, Have you solved the issue following Chaitanya's reply and relevant link? please give a feedback,thanks. Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.