SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Problem with Reporting services
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

amirssid
Starting Member

Canada
4 Posts

Posted - 12/19/2012 :  18:47:36  Show Profile  Reply with Quote
Hi
I am new to SQL Server. I have recently learned SQL server basic database architecture, the T-SQL language and some tools including SSIS and SSRS. I have one problem with reporting services, as given below:

When I install and setup SSRS, everything seems to be installed successfully and there is no problem. But when I go to browser and try to load report manager page "http://localhost:port/reports", it asks for a user name and password. When I give my Windows user name (which has administrative privileges), the page comes only with some title information (like "Microsoft SQL Server Reporting Services"), but I cannot do anything, as there are no links for "Report Builder", or "Data Source", ..etc.

If in user name, I give a service account (LocalSystem, LocalService, NetworkService, under which SSRS is run), then I get an error saying "you do not have the required privileges". In either case I cannot do anything on this page !!! can somebody please help me telling what I am doing wrong? and, how can I fix this problem?

Thanks in advance.

AmirSidd

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/19/2012 :  19:29:40  Show Profile  Reply with Quote
See if either of the workarounds on this connect page helps
Go to Top of Page

amirssid
Starting Member

Canada
4 Posts

Posted - 12/19/2012 :  23:49:52  Show Profile  Reply with Quote
Those workarounds didn't work. Actually the problem is; "what username and password should I give in the login dialog box which comes immediately when the report manager page loads ?"
As, I mentioned before, when I give my Windows user/passwd then the page comes with only titles but no workable links/commands, and if I give the service control account, then I get error. Here is the specific error message that I get:

"Access is denied.
Description: An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.

Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'C:\Program Files\Microsoft SQL Server8\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\home.aspx'."

AmirSidd
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52323 Posts

Posted - 12/20/2012 :  00:09:46  Show Profile  Reply with Quote
whats account you gave while you configured report server using Reporting Services Config Manager?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

amirssid
Starting Member

Canada
4 Posts

Posted - 12/20/2012 :  00:43:11  Show Profile  Reply with Quote
Here is what accounts I gave when I setup SSRS:

*-In the [Service Account] , I gave : Use built-in account "Local System"
*-In the [Web Service URL] , I gave : Virtual Directory=ReportServer, IP Address=All Assigned (Recommended), TCP Port=8081,
SSL Certificate=(Not Selected), SSL Port:
*-In the [Database] , I gave : SQL Server Name=AMBER-LAPTOP (this is my computer name), Database Name=ReportServer, Report Server
Mode=Native, Credetial = Service Account, Login=LocalSystem, Password=******** (this comes by default).

These are all relevant infomation which I gave in terms of accounts/users. Also, I did not give anything for [Execution Account] section, and I didn't check the check box for "Specify an execution account".

I hope this is enough information, that someone can help me. Please help ! thanks.


AmirSidd
Go to Top of Page

lopez
Starting Member

USA
8 Posts

Posted - 12/20/2012 :  00:43:29  Show Profile  Reply with Quote
Make sure the Reporting Services virtual directories ("Reports" and "ReportServer" by default) are:

Configured as applications, not just virtual directories
Using a different app pool than your main site
Target ASP.NET 2.0

for more info go through the given link

http://msdn.microsoft.com/en-us/library/ee248632.aspx
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000