SQL Server Reporting Service 2012 - Cannot Connect to the Database Server
Hello Community, I am using SQL Server 2012 on a Windows 2012 Cluster. I am trying to configure the Report Server Database but every time I go through the Report Server Database Configuration Wizard to create a database I get this error: Could not connect to the server. A network-related error 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 the SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server). I am using "Current-User Integrated Security" with my own account which has public, sysadmin and database creator permissions. the MSSQLSERVER service is started, Named Pipes are defined, and I have Inbound and Outbound Fire Wall rules defined to allow traffic on port 1433. Has anyone else ever seen this problem and if so can you help me resolve it? Thanks! Tom Tom Molskow - Senior SharePoint Architect - Microsoft Community Contributor 2011 and 2012 Award - Linked-In - SharePoint Gypsy
May 24th, 2013 10:04pm

Hi Tom, Can you check the below steps: 1. Are you able to connect to ReportServer Database using SQL Server Management Studio ? 2. Are you able to create a new Database ? 3 Is your ReportingServices services is running ? 4. Did you check to run Reporting Services Configuration Manager using "Run As Administrator" option ?Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. Regards, Randhir
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2013 8:55am

Hi Tom, Can you check the below steps: 1. Are you able to connect to ReportServer Database using SQL Server Management Studio ? 2. Are you able to create a new Database ? 3 Is your ReportingServices services is running ? 4. Did you check to run Reporting Services Configuration Manager using "Run As Administrator" option ?Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. Regards, Randhir
May 25th, 2013 8:55am

Can you connect to the instance via SSMS?Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing Remote DBA Services: Improves MS SQL Database Performance
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2013 3:23am

Can you connect to the instance via SSMS?Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of database and data cleansing Remote DBA Services: Improves MS SQL Database Performance
May 26th, 2013 3:23am

Hello, 1. Are you able to connect to ReportServer Database using SQL Server Management Studio ? - No 2. Are you able to create a new Database ? - No 3 Is your ReportingServices services is running ? Yes 4. Did you check to run Reporting Services Configuration Manager using "Run As Administrator" option ? Yes Thanks! TomTom Molskow - Senior SharePoint Architect - Microsoft Community Contributor 2011 and 2012 Award - Linked-In - SharePoint Gypsy
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2013 2:20pm

No I cannot.Tom Molskow - Senior SharePoint Architect - Microsoft Community Contributor 2011 and 2012 Award - Linked-In - SharePoint Gypsy
May 27th, 2013 2:20pm

Hi Tom, This error message means the client can reach the server but there is no Named Pipe listener with specific pipe name on the target machine. It also means the account can have a file sharing session without a problem. You can refer to the link below to see how to solve it. http://blogs.msdn.com/b/sql_protocols/archive/2007/05/16/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error-xxx.aspx If you still see this error, please post questions at MSDN SQL Server Data Access Forum. It is appropriate and more experts will assist you http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1 Regards, Charlie Liao If you have any feedback on our support, please click here.Charlie Liao TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2013 10:05pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics