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