MS SQL Reporting Services 2005 and Host Headers


MS SQL Reporting Services is a very valuable and powerful reporting engine; however, “personalizing” or “branding” it is not the easiest task.  The following MSDN article was very helpful in configuring SSRS using a DNS Alias and a host header in an intranet domain.

The key to this is to create the Web Site first using the DNS alias, with port 80.  Then using RS Configuration Tool, create a new “Report Server Virtual Directory” Site and a new “Report Manager Virtual Directory” based off the new site you have created.  The RS Configuration will automatically create the necessary virtual directories for the Report Services to work.

Now that I had all the configurations done, I opened my web browser entered the new URL and….nothing.  Then I realized that the actual Report Server is a virtual directory of the website I just created, not the ROOT website.  So I then added a simple index.htm page to redirect to the virtual directory.

<HEAD>
<SCRIPT language="JavaScript">
window.location="http://reports.mydomain.com/Reports/";
</SCRIPT>
</HEAD>

That did it!  Now my SQL Reporting Services worked using a DNS alias, mapped to a IIS website configured to use Host headers.

Advertisements

Posted on August 17, 2010, in SQL 2005. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Humor Me a T-SQL Princess

DBAs really do have a sense of humor

Andrea Allred presents RoyalSQL

Bringing happy endings to all your data stories.

IDERA Community

A community site for users of all IDERA product and SQL community members.

Strate SQL

Data Adventures with a Architect

SQL Sanctum

A Join on SQL And Everything Else

Grant Fritchey

Intimidating Databases and Code

rhondastephens

To Catch A Falling Cactus

SQLSwimmer

Swimming through the Sea of SQL

SQL Studies

 Live, Learn, Share

Aunt Kathi's SQL Server Home

Learn SQL Server from your favorite aunt!

Jen's Blog: We Owls

...stuff. Also, things.

Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL

Voice of the DBA

Writings from Steve Jones, the Voice of the DBA

Glenn Berry's SQL Server Performance

Semi-random musings about SQL Server performance

%d bloggers like this: