Friday, January 27, 2012

Add SSRS 2008 named instance to the same server.

A recent questions about how to add another instance of SSRS, couldn't find any that talking about 2008, anyway I decided to help by creating some screen shots.

The installation is straightforward, you just pop the CD, run the installer, select Reporting services from the "Feature Selections", then select "Named Instance", configure and you're done !


The installation files and additional checks.


Perform a new installation....



Select only Reporting Services ...


named instance or you'll get an error !


Confirmation...



Service account configuration...can be changed later..



Installation...& Completion...



Reporting Services Configuration Manager.
All Programs---> Microsoft SQL server 2008---> Configuration Tools



Selecting the new instance to configure... Hop to the database tab to install or point to an existing DB.

 I'm already using ReportServer default DB for the first instance, so I'll need to come up with a new name for the new instance to use !

 I'll create a new DB.

 On which SQL server the DB will be created in !
and which account the wizard will use to connect to that SQL box.


Name of the new DB.


Credentials for the new DB.

 Summary...


2 Mins and you're done.



 Initialize the web service URL, which port and which virtual directory..


Report server URL to view the reports..for user access.


the 2 instances and the SSRS URLs.

http://jyousef-3cce217/Reports_TESTINST     <---Newly added instance URL
http://jyousef-3cce217/Reports                         <---Default installed one.

That's it...
Hope that helps someone.

Wednesday, January 25, 2012

SQL Server 2012 Developer Training Kit

Ms just released 2 days ago the SQL Server 2012 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2012 database and BI solutions.
You'll need to have the Microsoft Web Platform Installer 3.0 installed before downloading

http://www.microsoft.com/web/downloads/platform.aspx


Then download the KIT from here... it'll need 269 MB space to download all the sets of LABS, Presentations and Demos.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27721


In the system requirments, they listed windows 7, windows server 2008.

During the installation, it'll give you an options t odownload and install VS2010,SQL 2012 and such required S/W.


Monday, January 23, 2012

Microsoft Virtual Academy - Free Online Training!

Aperantly MS has some goodies for the new year, I posted before a link to the new E-book, and now I just discovered this new GEM...


Improve your IT skill set and help advance your career with a free, easy to access training portal. Learn at your own pace, focusing on Microsoft technologies, gain points and get recognition.

Saturday, January 21, 2012

SSRS Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid.

Have you ever got this message? "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid."

It's simply as it says, just go back to your report and make sure to save the user credintials that runs the report, or go to Datasets under ReportServer.

Also you can refer to this MS 'How to' article.
http://msdn.microsoft.com/en-us/library/ms159736.aspx

Also make sure that your report is not using a User experssion, !userID
Check: http://msdn2.microsoft.com/en-us/library/ms156012.aspx


Wednesday, January 11, 2012

Check for file existance, copy or skip using script taks

A recent question about how to check for file existance, skip or copy using script taks. from 2 different locations.

 Here I'll ge ta list of files that needs to be copied from C:\Media, check if it exists in U:Media or not and act accordingly.


Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.IO
<System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _
<System.CLSCompliantAttribute(False)> _
Partial Public Class ScriptMain
 Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
 Enum ScriptResults
  Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success
  Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
 End Enum

    Public Sub Main()
        Dim FileToCopy As String
        Dim NewCopy As String
        Dim di As New IO.DirectoryInfo("C:\Media")
        Dim fi As IO.FileInfo() = di.GetFiles()
        Dim f As IO.FileInfo

        For Each f In fi
            FileToCopy = "C:\Media\" + f.ToString
            NewCopy = "U:\Media\" + f.ToString
            If File.Exists(NewCopy) Then
                MsgBox(NewCopy + "File Exists")
            Else
                System.IO.File.Copy(FileToCopy, NewCopy)
                MsgBox(NewCopy + "File Copied")
            End If
        Next
        Dts.TaskResult = ScriptResults.Success
    End Sub
End Class



Hope that helps.... 

Tuesday, January 10, 2012

SSIS expressions in variables...dynamic variables

A recent question about how to create dynamic variables using expressions in SSIS, well that's pretty easy, you just need to highlight the desired variable, press F4 to pull the properties window.


 Then set "EvaluateAsExpression" to TRUE, then click on ellipsis to set the expression....

Hope that helps...

Sunday, January 1, 2012

SQL Agnet Job Categories

I'm excited to write my first blog post in 2012 with a new year resolution, 99% of the times when I create a SQL agent job I forget to set the category of the job to a meaning category instead of the default [Uncategorized - (Local) ]

Does your jobs looks like this?


Make it a habit and add the category..
To add more categories to the list...(Right-click Jobs, select Manage Job Categories, then Add)


Hope that helps you to get your server more organized !