What tools are used for SQL Server Report Server Administration?

Posted on by
Reply

Last weekend, a friend of mine and I, were discussing on SQL subject and SSRS in particular, asked me this question. Since he is yet to work on Administering SQL Server Reporting Services, he asked me some tips to get started and asked me to tell him the tools that are used by Admins while Administrating SQL Server Report Server. I thought to list those, that way the readers can be also benefited. 

Though explaining about how and where these are used is beyond my plan for this blog, I shall try to write about them in detail in future..

The list of tools goes like this (in no particular order)..

  • SQL Server Configuration Manager.
  • Reporting Services Configuration Manager.
  • SQL Server Management Studio.
  • Rsconfig Utility
  • RS Utility
  • Report Server Web Service URL
  • Report Manager
Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

Connecting to Named and Default Instances in SQL Server

Posted on by
Reply

You might be aware that SQL Server supports multiple instances on a single machine and a there can be one default instance on any machine. When working with a default instance of a SQL Server you can connect to it by using just the name of the Windows Server where it is installed on. Whereas the when you have to connect to a named instance of SQL Server, you have to connect using the convention Servername\Instancename.

Let us look at this with examples.

Connecting to Default Instance:

When connecting to a default instance of SQL Server, you just have to enter the machine name where the SQL Server is installed. In the below example, I am connecting to a SQL Server 2005 default instance on a Server named SQLSVR2005VM.

Connecting to a named Instance:

Connecting to a named instance, you have to specify the machinename followed by a back slash “\” followed by the instance name. In this example (picture below), we are going to connect to a named instance called SQLTESTINSTANCE on the same machine SQLSVR2005VM, hence we need to type SQLSVR2005VM\SQLTESTINSTANCE to connect to the named instance.

Note: It is possible to configure the port number of a named instance to be 1433 in order to be able to access similar to default instance (without the back slash), but that case is not considered for this blog post. 

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

Activity Monitor in SQL Server 2000, 2005 and 2008

Posted on by
Reply

In this blog post, we shall take a look at how to access Activity Monitor in the last 3 Major Versions of SQL Server, SQL Server 2000, 2005 and 2008 (of course it has not changed in SQL 2008 R2).

YouTube Preview Image

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty