SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report builder sql server 2005 does not start


Report builder sql server 2005 does not start

Author
Message
sirila29
sirila29
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 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
Attachments
problemreportbuilder.txt (52 views, 10.00 KB)
Gift Peddie
Gift Peddie
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11192 Visits: 14456
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
sirila29
sirila29
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 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
Gift Peddie
Gift Peddie
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11192 Visits: 14456
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
sirila29
sirila29
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 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
Gift Peddie
Gift Peddie
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11192 Visits: 14456
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
Gift Peddie
Gift Peddie
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11192 Visits: 14456
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
sirila29
sirila29
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 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
Gift Peddie
Gift Peddie
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11192 Visits: 14456
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
sirila29
sirila29
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search