I have a SQL 2014 SP1 Standard Edition installed and running on Win 2012 R2.

SQL SSRS Reporting services are all setup, configured, running (all in native mode) and I can access and run reports on it fine.

I can access both ReportServer and ReportManager URL's no problem.

I cannot use SSMS <started and running as (Administrator)> to connect to the Reporting Service to manage ROLES, etc...

I tried my NT Domain account which is part of Local Admins, the NT Local Admin account that is running both SQL and Reporting services and SA but all fail with the error below:

The username or password is not valid or you do not have permission to access this server. (Microsoft.SqlServer.Management.UI.RSClient)

What can/should be done in order to access/manage "Reporting Service" via SSMS 2014?

Hi Nenea,

Does 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\' exist on your server ? 

If the answer is no, i think that you can reinstall SSRS. 

If the answer is yes, try to give access to "everyone" read/write on this folder, and type again http://boo/reportserver$demo in IE.

If the result is correct, we will try to give correct permission on this folder.

OR

Please input http://MACHINENAME/ReportServer_INSTANCENAME as the server name when connecting to the Reporting Services server type through SSMS. If it doesnt work either, please post the detailed errors in the Reporting Services Log file which is located in <Drive>:\Program Files\Microsoft SQL Server\MSRS10.<Instance Name>\Reporting Services\LogFiles folder.

 

Hi Nenea, 

According to your description, you cannot access to Reporting Services via SSMS, right? 

In your scenario, are you using Windows Authentication? And are you connecting to the correct server name? If so, since you open a connection, the Windows Authentication is default, and then the current logon user will be typed into the User name text box. You just need to click "Connect" to connect to the Reporting Services. 

For your issue, please user the full URL instead. 

For example, http://server.domain.com/Reportserver. 

If you have any other question, please feel free to ask. 

Regards,
Shrek Li

If you modify the rsreportserver.config value of SecureConnectionLevel to 0, I think you will be able to connect directly from SSMS