Hello Experts,
I have this problem when i go to http://<servername>/reprots
"The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible "
I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.
i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....
would be great if someone suggests.
regards,
lakshman.
Hi Lakshman,
Is it RS 2000 or 2005? In RS 2005, you can use RS config tool to see if all sections are correctly configured. If not, fix the problems using the config tool and try again.
Thanks,
Sharmila
Hi Sharmila,
Thanks for the reply.
Its RS2005. I am pretty new to the subject, can you please guide about using the RSConfig tool. Or resources where i can find the subject.
Best Regards,
Lakshman.
|||Hi Sharmila,
At the command prompt, I have done the following actions:
C:\>rsconfig -c -s iplserver -d iplserver -a SQL -u sa -p P@.ssword123445
The command completed successfully
C:\>iisreset
Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted
C:\>
when i try to access the report manager, the error persists.
pl let me know if i have to do something else.
many thanks,
lakshman.
|||Hi Lakshman,
To access the config tool, go to Start ->All Programs -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration. Make sure that all sections are configured properly. You should see a green check mark. Please try this and let me know.
Thanks,
Sharmila
Lakshman Pilaka wrote:
Hello Experts,
I have this problem when i go to http://<servername>/reprots
Is it safe to assume the mispelling of Reports is only here in the forums?
|||oops, i wrote it wrong here in the thread, but i was spelling it correctly when i am testing...
Sharmila, thanks for the msg, I have checked that one and got to see that there is a blue exclamation for the "Encryption Keys". and the initialization is not done, i find a red cross. but rest all are okay with a green check mark.
i am not even able to access it the Initialization tab as its giving an error message,
plz help, or just guied me to a resource where i can have all this information..
i appreciate all your time and efforts,
lakshman.
|||Hi,
I have installed the SQL SP2 on the server, and now the server is properly initialized. now i see a green check mark on all the tabs.
But unfortunately the problem still persists. I am seeing the same error:
when i attempt to go to http://<reportserver>/reports
what could be the problem?
many thanks,
lakshman.
Hi Lakshman,
Can you please take a look at the RS logs located here - %programfiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles and see what you can find around the same time you see the error or can you include information from the logs?
Thanks,
Sharmila
