Hi all! in SQL 2008 Instance (Right Click) ---> Facets ---->in the drop down list im unable to see the option for "Surface Area Configuration for Reporting Service" COuld anyone say how i can get tht option?? --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi all! in SQL 2008 Instance Hello, You are connected to a SQL Server database engine or to a reporting services instance? You have to connect to SSRS instance to see the facet of it.Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich http://olafhelper.over-blog.de

Sorry to ask this Is there any separate instance for SSRS? if so where should i need to go for it?--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

When you open "Connect Object-Explorer" you have a combobox "Server type" with a list of all types: Database Engine, Analysis Services, Reporting Services, SQL Server Compact Edition and Integration Services. Select Reporting Services to connect to your SSRS instance.Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich http://olafhelper.over-blog.de