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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-05-18 : 07:22:51
|
| Had trouble with this in the past. I always get through on luck and fiddling about long enough until now...All brand new server. Can connect to this new server instance with Management Studio, and with Crystal Reports! Most of the Reports Services Config is now done apart from the very top item, Server Status, is still stopped, and times out when I try starting it - service starts, then stops. Seen this many times before - what causes it?Database Setup is fine - default database ReportServer has been created and appeared in Management Studio.Initialization item is grey and I can't even select it in the config window. Web Service Identity is the only other red item - not sure if it matters. Blue item Encryption Keys seems to require restoration or deletion to allow configuration...?Why can't the Report Server connect to the SQL Server service?ThanksMike |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-18 : 21:49:32
|
| Did you check RS log file? |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2008-05-20 : 07:55:36
|
| Starting to sound good!Where is the RS log file and what's in it? I saw some log file options and didn't think much of it at the time.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 21:54:35
|
| It logs all kind of things in RS, is in rs directory under sql. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2008-05-23 : 19:56:04
|
| All lights are now green in Report Manager config & I don't know why.I can't get http://localhost/reportsto workwhere <localhost> is my database instance is PBA\MIKEDBwhy is the backslash changed to some strange characters when I put this into the browser? What am I doing wrong, and How do I get the Report Manager up?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-23 : 22:46:28
|
| Replace localhost with host name that RS runs on. |
|
|
|
|
|
|
Trouble with SSRS Config