SQl server 2008 R2 configurations

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SQl server 2008 R2 configurations

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-16 : 03:02:13

Hi Experts here,

I have installed SQL server 2008 R2 enterprise edition along with reporting services on windows server 2008.

While configuring the report server i am not getting any folder in report manager.Do i need to do any extra configuration.

I am able to see only below on URL http://localhost/reportserver_r2

localhost/ReportServer_R2 - /

----------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 10.50.4000.0

Please kindly help me to configure the report server,any reference link may help as well.

Thanks,
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-16 : 04:37:16

you need to create folder.
One way to do it is to specify folder details in Business Intelligence Development Studio while creating reports and while deploying it will create the folder for you in the server.
Alternatively you can also go to report manager page and create folder yourselves.
The url for Report Manager home page should be something like below

http://localhost/reportserver_r2/Pages/Folder.aspx

this should give you with a GUI with create folder button to create new project folders

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-16 : 07:39:48

Hi Visakh,

Yes with this URL http://localhost/reportserver_r2/Pages/Folder.aspx i am getting onlt blank page with details of ,it does not showign any GUI to create folder or any other menu pls help.

localhost/ReportServer_R2 - /

--------------------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 10.50.4000.0

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-16 : 13:45:13

Tell whats the role to which your credentials are mapped in report manager

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-19 : 03:27:13

no..i am unable to open the report manager.

When i open the URL http://localhost/reportserver_r2/Pages/Folder.aspx
It shows blank and no error in it.

I am local windows box admin and hence as well as SQL server

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-19 : 03:56:01

quote:
Originally posted by gangadhara.ms

no..i am unable to open the report manager.

When i open the URL http://localhost/reportserver_r2/Pages/Folder.aspx
It shows blank and no error in it.

I am local windows box admin and hence as well as SQL server

Thanks,
Gangadhara MS
SQL Developer and DBA

My question is on report server role. Whats the role to which you're mapped to currently.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-22 : 22:18:10

how to open the report server role page ? I am not able to see any page which shows the report server role.

The user in which i have logged to windows box having admin access.

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-23 : 01:09:27

see

http://www.optimusbi.com/2012/10/17/report-server-role-management-ssrs/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-23 : 01:58:25

Thanks Visakh for reply.

But my question here is that i am not landing at the report manager URL.There don;t have any option i am gettign only below in the Report server URL.

URL---------->>>> http://localhost/ReportServer
Content inside the report server URL -------------------->>> I am not seeing anything inside this .First of all i am not able to get Home page in reporting services.

localhost/ReportServer - /

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 10.50.4000.0

Thanks,
Gangadhara MS
SQL Developer and DBA

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-23 : 02:42:29

after accessing the report server URL out side the server i am getting the below error

URL >: http://itsausyw00017/Reports/Pages/Folder.aspx

XML Parsing Error: no element found
Location: http://itsausyw00017/Reports/Pages/Folder.aspx
Line Number 1, Column 1:
^

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-23 : 04:03:24

Are you sure you configured report server properly?

http://www.mssqltips.com/sqlservertip/1453/sql-server-reporting-services-configuration-tool/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-23 : 05:33:21

I am configuring SQL server 2008 R2 report server there is no IIS configuration in it.

Thanks,
Gangadhara MS
SQL Developer and DBA

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-07-26 : 02:17:30

Pls suggest with SQL server 2008 R2 report server configuration.

Thanks,
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources