May 31, 2012 at 1:53 am
Hi All,
I installed SQL serever 2008 r2 on my local machine and I configured the URL's from report configuration manager but when I try to access the link its asks Username and password. It does not allow me to connect to both report server and report manager. Is there something That i am missing or what I am suppose to check?
Thanks for your help.
Regards
May 31, 2012 at 1:56 am
By default the only accounts permitted to connect to a fresh instance of SSRS is anyone in the administrators group of the server where SSRS is installed.
Does the account you are logged in as have admin rights to the machine where SSRS is installed?
May 31, 2012 at 2:06 am
Yes, I am do admin rights and I am logged in as administrator. Still cant resolve the isse.
Regards
May 31, 2012 at 2:09 am
What authentication types do you have in the RSReportServer.config file under the <Authentication> xml node?
May 31, 2012 at 2:11 am
Getting the following error when i try to deploy reports from BID:
TITLE: Microsoft SQL Server Report Designer
------------------------------
Could not connect to the report server http://Local-pc/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.
------------------------------
ADDITIONAL INFORMATION:
System.Web.Services.Protocols.SoapException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.
at Microsoft.ReportingServices.WebServer.WebServiceHelper.EnsureModeFromCatalog()
at Microsoft.ReportingServices.WebServer.RsSoapBase.Init(String itemPath, Boolean checkAccessToSharePoint)
at Microsoft.ReportingServices.WebServer.ReportingService2010.Initialize(String itemPath, Boolean checkAccessToSharePoint)
at Microsoft.ReportingServices.WebServer.ReportingService2010.IsSSLRequired() (Microsoft.ReportingServices.Designer)
------------------------------
BUTTONS:
OK
------------------------------
May 31, 2012 at 2:13 am
does the account running the SSRS service have access to the SSRS Databases?
May 31, 2012 at 2:35 am
Ho wto check that?
From config file, i tried to find authentication and this is what it contains:
<Authentication>
<AuthenticationTypes>
<RSWindowsNTLM/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
May 31, 2012 at 2:38 am
If you add in <RSWindowsNegotiate/> under authentication types, then restart SSRS what happens?
So it should look like the below.....
<Authentication>
<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
May 31, 2012 at 2:57 am
No Difference.
May 31, 2012 at 3:02 am
in sql server config manager, what is the user which is running the SSRS service?
then in SSMS, ensure that this account has access to the databases under the security tab.
May 31, 2012 at 3:46 am
Its the same user for both , still the issue
May 31, 2012 at 4:15 am
Please refer the attachmenet which seems oto be an issue where it should be logon as Built in account but how to address it
May 31, 2012 at 4:17 am
running as local system which is a highly priviledge account, should really be running your services with a less priviledge account, that aside, check that local system has access to the ReportServer DB's which it pretty much should do if its been configured.
May 31, 2012 at 4:37 am
Not able to access reporting services from Database.
May 31, 2012 at 4:40 am
You dont have access to the SSRS DB or Local System doesnt? Is the report db on your local machine or is it on a remote server?
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply