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.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-10-26 : 10:32:25
|
| Hi I am in weired move kindly help me out..I created report using sql server 2005 Reporting services..At one stage it is working fine with proper parameter but due to bad input parameter my report goes in hang mode..so i went to my DB server and restart my reporting service and then MSSQLSERVER I dont remember sequence (may be vice versa) now I am not able to get report when i am passing right parameter..I went to google and only I came to know that due to sequence of restart of services will cause this error..error like..Application error:Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Syste error:The SQL Server Integration Services service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Kindly help me out. T.I.A |
|
|
Will H
Yak Posting Veteran
56 Posts |
Posted - 2007-10-26 : 12:09:05
|
| It doesn't sound like the problem has anything to do with parameters, I think your reporting service isn't started correctly. Go to Start --> All Programs --> Sql Server --> Configuration Tools --> Reporting Services Configuration. Look in the column on the left hand side. Are there any items with a red x in them? If so, start there. ---------------------------------------------------------SSRS Kills Kittens. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-27 : 01:30:12
|
| Check windows app event log, should have details of ssis start failure there. |
|
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-10-29 : 06:53:25
|
| HiWhen I chked on line I got User Action:"I deleted the existing keys and created new ones. Worked like a charm!"On my machin I m installed SQL Server Client and I am hitting to Machin "A" where my MS SQL SERVER installedMy quetion is on which machin I do User Action on my machin or Machin "A"...cause on my machin I am seeing "Reporting Services Configuration tool" as well as on Machine "A"..I am very new to this Reporting Services :(Please help me out and guide me to delete existing keys and created new ones...T.I.A |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-29 : 22:49:00
|
| Where is reporting service installed? Should run configuration tool on that machine. |
|
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-10-31 : 11:05:45
|
| HI I got it :) I deleted my dataset and again create it ... it worked fine :)Thanks for online :)T.I.A |
|
|
|
|
|
|
Err: Report Server Windows Service (MSSQLSERVER)