I've installed sql 2012 express advanced and set up SSRS in the native mode. THe report server seemas to work OK since I can create reports with Report Builder and manage them with the report manager. The reports display properly also. THe only problem is that there is no report service in the Sql Server Management Studio. What am I missing?? CHeers NorNor

Hello Nor, SQL Server Management Studio Express(SSMSE) is different from the complete SQL Server Management Studio in the following ways: SSMSE cannot manage Analysis Services, Integration Services, or Reporting Services. You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.Interactive Resolver, which lets you resolve conflicts manually during on-demand synchronization in Microsoft Windows Synchronization Manager, is not supported in SSMSE.SSMSE does not support scheduling administrative tasks by using SQL Server Agent.In SSMSE, Object Explorer only supports Database Engine instances. The Connect to Server dialog box prevents connecting to other services, such as Analysis Services.Because SSMSE is a subset of SQL Server Management Studio, all objects that would normally be enumerated for a specific Database Engine Object Explorer tree are still visible in SSMSE. If it is an object for an unsupported item, only the refresh command is available.Help for SSMSE is not installed by the product. If you press F1, MSDN Online help opens. Pressing F1, you are able to access all F1 help topics, but you do not see a table of contents or an index for the SQL Server Code-Named Denali documentation. To add SQL Server Code-Named Denali documentation to SSMSE, install SQL Server Code-Named Denali Books Online from SQL Server Books Online Download Center. After installing, in the Contents pane of the Books Online, you can use the SQL Server Express filter to hide the content that does not apply to SQL Server Express edition. For more information, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms365247.aspx Regards, Bin LongBin Long TechNet Community Support

Hello Nor, SQL Server Management Studio Express(SSMSE) is different from the complete SQL Server Management Studio in the following ways: SSMSE cannot manage Analysis Services, Integration Services, or Reporting Services. You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.Interactive Resolver, which lets you resolve conflicts manually during on-demand synchronization in Microsoft Windows Synchronization Manager, is not supported in SSMSE.SSMSE does not support scheduling administrative tasks by using SQL Server Agent.In SSMSE, Object Explorer only supports Database Engine instances. The Connect to Server dialog box prevents connecting to other services, such as Analysis Services.Because SSMSE is a subset of SQL Server Management Studio, all objects that would normally be enumerated for a specific Database Engine Object Explorer tree are still visible in SSMSE. If it is an object for an unsupported item, only the refresh command is available.Help for SSMSE is not installed by the product. If you press F1, MSDN Online help opens. Pressing F1, you are able to access all F1 help topics, but you do not see a table of contents or an index for the SQL Server Code-Named Denali documentation. To add SQL Server Code-Named Denali documentation to SSMSE, install SQL Server Code-Named Denali Books Online from SQL Server Books Online Download Center. After installing, in the Contents pane of the Books Online, you can use the SQL Server Express filter to hide the content that does not apply to SQL Server Express edition. For more information, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms365247.aspx Regards, Bin LongBin Long TechNet Community Support

HI Bin, THanks for that Info. Very helpful!! Cheers NorNor