| Author |
Topic |
|
bpgupta
Yak Posting Veteran
75 Posts |
 Posted - 2007-06-14 : 02:50:22
|
| Hi,I am getting the following error - "Report Services instance could not be found". However, from services, I am able to start and stop SQL Server Reporting Services. I get the error when I try to connect to Reporting Services from Management Studio. I am using Sept CTP. How do I verify that I have this installed correctly? From the folder structure, I'm seeing MSSQL.1, MSSQL.2, and MSSQL.3, MSSQL.4Any help will be appriciated.Thanks,BPG |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-14 : 14:27:40
|
| Can you connect to it in ie? If so, try register it with url instead of host name. |
 |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-06-15 : 02:58:00
|
| I am able to connect the Database Engine with sql server authitication ,but i am not able to connect the reporting services using sql server or windows authintication .From the above response i am not able to understand what u mean to say.Please explore it .I am using the following credentialMymachine name is machine53 and instance name is sql2005 , so i am using the Machine\sql2005 with windows auth.so what will be URL in this case to connect the reporting services. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-15 : 14:53:55
|
| http://host_name/reports and http://host_name/reportserver by default. In ssms, you should register RS under reporting services. |
|
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-06-16 : 04:11:52
|
| I have tried the suggestion given ,but still it is not working showing blank page.I have already configured the reporting services steps with reporting services configuration option.I am able to stop and restart the RS also. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-16 : 17:32:38
|
| Is web service running? Do you use IIS? If so, check RS settings in IIS manager. |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-06-16 : 18:00:30
|
| Go to programs>Microsoft Sql Server>ConfigurationTools>Reporting Services Configuration.Do you have any thign listed that has a Red circle with a X through it, or is everything showing up green?If everything is green just open up IE and type http://"YOUR SERVER NAME WITHOUT THE QUOTEs"/reports and it should come up. Now if things are not all coming up green list out what is not, and we'll start from there.Also have you uninstalled/reinstalled this? If so this may be your issue. This is VERY tempermental when removing if not done properly. |
|
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-06-18 : 09:35:17
|
| In the Reporting service configuration Server status =ok , Report server Vitual Directory =ok, Report manager vitual Directory = Not working, Windows Service Identity =ok, Web Services Identity =Not working , Database Setup =OkI have tried to configure the IIS also but there Report manager is not working showing REd Mark. |
|
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-06-18 : 13:32:31
|
| Well this is the issue, does it allow you to re-configure that virtual directory? Change the virtual directory to something else, then stop and start reporting services? This will attempt to re-build that virtual directory. If that doesn't work, you should get a error message, please post what it says. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 15:55:58
|
| Is iis running? |
|
|
|
|
Reporting services not starting