helloi'm totally new to sql server reporting services.i installed sql server 2008 express with advanced services on a 64 bit vista. available features for installation are db engine services, sql server replication, management tools and sql client connectivity. i have 2 questions:1. how can i determine if the SSRS is installed? there's no such thing in programs and features2. when i go to Reporting Services Config Manager.. it asks me for a server name, i type in my machine name, i click Find and i receive: "unable to connect to the report server vmi provider. details: Invalid namespace". what am i doing wrong here?thank u
Welcome to the forums. SQLExpress doesn't install reporting services, for that you need to install SSRS as seperate.
1. Generally speaking, you can run this query to determine the version you have installed. SELECT SERVERPROPERTY('productversion') AS SQLServerVersion, SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY ('edition') AS SQLServerEdition Also, if you have access to SQL Server Mgmt Studio, you can right click the ReportServer and ReportServerTempDB databases >> select Properties >> select Options >> and check the Compatibility level. It should be SQL Server 2005 (90). Also, to check SSRS/Reporting Services installation in general, you can: right-click My Computer >> select Manage >> select Services and Applications >> Internet Information Services >> Web Sites >> Default Web Site >> and check for the Reports and ReportServer virtual directories. Also, check the SQL Server Reporting Services (MSSQLSERVER) service (via: right-click My Computer >> select Manage >> select Services and Applications >> Services) and make sure that it exists and is shown as Started. Hope this helps.
[quote user="satya"] Welcome to the forums. SQLExpress doesn't install reporting services, for that you need to install SSRS as seperate. [/quote] Reporting services does install with SQL Server express advanced services
For a problem like this, I will first check whether the service is running. Check for this site: http://blogs.msdn.com/lukaszp/archi...hen-running-reports-in-the-report-server.aspx This may help you, if you have not yet resolved the problem.
Not only that it could be some service startup issues, http://msdn.microsoft.com/en-us/library/ms156468.aspx & http://support.microsoft.com/kb/968599 are good ones to resolve the issue.