Reporting Services Architecture—SQL Server Management Studio NEW in 2005

Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio

SQL Server Management Studio ^{NEW in 2005}

SQL Server Management Studio provides a Windows form-based, integrated environment that can manage various SQL Server components. From the SSRS perspective, the Management Studio has similar functionality to Report Manager when used to manage a single instance of SSRS.

The advantages of using the SQL Server Management Studio include consolidated content view for SSRS web farm (scale-out) deployment, slightly better performance, an ability to script and replay administrative tasks, and a finer granularity for role-based security settings.