Connecting to the Integration Services on the computer failed with following error : Access Denied

Installed SQL Server Integration Services. While tried to login Integration Services getting Access Denied Error. 

It will work fine when tried to login with Management Studio as "Run as a Administrator".

Here are the steps to access:

1. Run ->  dcomcnfg.exe

2. Navigate to Component Services ->Computers -> My Computer -> DCom Config

3. Search Application Name "Microsoft SQL Server Integration Services 11.0"

4. Open Properties:

5. Open Each edit option and add current user.

6. Save your changes.

7. Restart Your Service if required.

Watch the video for the details:

Date Function : DATEFROMPARTS() and TIMEFROMPARTS()

DATEFROMPARTS()

It returns the date value on specified year, month and day value.

It available in SQL Server 2012.

Syntax:

DATEFROMPARTS ( year, month, day )

Example:

SELECT DATEFROMPARTS(2010,10,30) AS DATEPARTS

OutPut:

DATEPARTS

2010-10-30

TIMEFROMPARTS()

It returns the full time on specified hour, minute and second.

It available in SQL Server 2012

Syntax:

TIMEFROMPARTS ( hour, minute, seconds, fractions, precision )

Example:

SELECT TIMEFROMPARTS(10,23,45,123,3) AS TIMEPARTS

OutPut:

TIMEPARTS

10:23:45.123

SELECT TIMEFROMPARTS(10,23,45,123,4) AS TIMEPARTS

OutPut:

TIMEPARTS

10:23:45.0123