Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Report builder sql server 2005 does not start Expand / Collapse
Author
Message
Posted Tuesday, May 19, 2009 9:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 9, 2009 7:26 AM
Points: 19, Visits: 42
I installed SQL server finally after a lot of edo on my machine.
now im trying to launch report builder using url
http:\\localhost\Reports
which opens the report manager. i am trying to launch report builder but i get an error saying
application not starting. anyone please help. its so tedious.
gone through the documentation, forums, google cant find anything relevent.Below is the error log file.
please someone help
thanks
sirila


  Post Attachments 
problemreportbuilder.txt (25 views, 10.18 KB)
Post #719964
Posted Tuesday, May 19, 2009 5:47 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 3,433, Visits: 14,422
I am assuming you have not initialized Report builder so go to the folder below and run it before trying to locate it in report manager.

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\ReportBuilder



Kind regards,
Gift Peddie
Post #720244
Posted Wednesday, May 20, 2009 7:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 9, 2009 7:26 AM
Points: 19, Visits: 42
thanks Peddie.
I located the report builder.exe and ran it. It opened the report builder window and i created a sample report.
but it shows data source problem.
i still cant run the report builder from the report manager window
please help.
i have tried googling and the other blogs on this but no posts on this particular one. really fighting with this.
Really appreciate your help
Post #720535
Posted Wednesday, May 20, 2009 8:28 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 3,433, Visits: 14,422
I don't know what to tell you mine runs even without report manager but I have not created reports models or datasource. I am running XP so what operating system are you running and what edition of SQL Server because it does not come with Express and not easy to run without Standard or Enterprise.


Kind regards,
Gift Peddie
Post #720596
Posted Friday, May 22, 2009 12:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 9, 2009 7:26 AM
Points: 19, Visits: 42
mine is windows XP and sql server standard edition.
i cant get to http:\\localhost\Reports
yesterday i was finally able to get to it and i could deploy my reports. but today my report builder would not start. it was asking me for some credentials. so i thought the report builder must have been corrupted and tried to uninstall everything and reinstalled everything afresh. i cldnt get to do the default instance anymore because it says its still present on teh system.
so i used named instance.
now my question is hopw do i browse to get to report manager using url
please help
sirila
Post #722308
Posted Friday, May 22, 2009 12:48 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 3,433, Visits: 14,422
If it is asking you for an account it is both good and bad, good because I can help you fix it, bad because it took me about half to one day to fix each errror with the login page. So I will write it up and post it because I am also running XP but not SQL Server Standard. Now to be clear this is for report manager not the builder because I have no problem with that.

Kind regards,
Gift Peddie
Post #722330
Posted Friday, May 22, 2009 1:15 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 3,433, Visits: 14,422
Go to control panel User Accounts and create an account make it Admin account create password for the account then add SQL Server login for the account. Then add the account as Admin in ReportServerDB, ReportServerTempDB, and the DataSource DB. This will let you login to Report manager but your reports will not run because it will error out.

Go back to control panel then to Admin tool then local security then to local policies, then User Rights Assignment scroll down to Allow Logon locally double click it and then Add that account to the list of accounts. This will let you see the Reports but login is still required.

Now the last step to remove the login prompt open IE go to tools options and then security then click local intranet, then sites then click Automatically detect intranet network, then Advanced and then add the Report Manager url in there and the login prompt will go away. I had to do this because I tried the option posted by SSRS employee and my SSRS config file did not include what the person said to remove. I run VS2008 Team Suites which is he Team Foundation Server Main Development Tool. So print out the above and get to work and Goodluck.



Kind regards,
Gift Peddie
Post #722354
Posted Friday, May 29, 2009 7:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 9, 2009 7:26 AM
Points: 19, Visits: 42
Hi,
Thanks for the explanation but i gave in anonymous access and it worked.
my problem still continues. i need to pas to the end user and the report builder does not launch on my system as it was supposed to do. when i click on the button it says its downloading and stops there. i have to manually invoke it from the folder as you advised me the other day
i tried to uninstall and reinstall but nothing works
when i try to google iam getting my query back. noone else has this problem. only me
thanks
Post #725789
Posted Friday, May 29, 2009 8:03 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 3,433, Visits: 14,422
Rerun setup and choose repair also make sure you choose all components, on a side note you may have to work through what I posted because I also used anonymous before going through the spaces to fix this complex problem with login prompt.



Kind regards,
Gift Peddie
Post #725823
Posted Thursday, June 4, 2009 7:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 9, 2009 7:26 AM
Points: 19, Visits: 42
Hi Peddie,
My report builder is running fine and everything is working now.it doesnt launch in mozilla and only works with IE. i didnt know it doesnt work with mozilla and i was trying all the settings and finally to realise that.
anyways thank you for all the writing because i got a lot of insight into how this really works
thanks
siri
Post #728918
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse