Here is a short T-SQL query to find the timezone offset of the SQL server.
SELECT 'UTC'+RIGHT(SYSDATETIMEOFFSET(),6) AS 'TimeZone Offset'
SELECT 'UTC'+RIGHT(SYSDATETIMEOFFSET(),6) AS 'TimeZone Offset'
USE ReportServer$SQL2008R2 --Change the Database Name GO IF EXISTS (SELECT * FROM sys.objects WHERE NAME = 'ConfigurationInfo') BEGIN DECLARE @Result nvarchar(max) SELECT @Result = Value FROM ConfigurationInfo WHERE NAME = 'SharePointIntegrated' PRINT CASE WHEN @Result= 'False' THEN 'The specified Report Server Database "'+ DB_NAME() + '" is configured in "NATIVE" mode' WHEN @Result = 'True' THEN 'The specified Report Server Database "'+ DB_NAME() + '" is configured in "SHAREPOINT INTEGRATION" mode' END END ELSE BEGIN DECLARE @DBName nvarchar(100) SELECT @DBName = DB_NAME() RAISERROR('The database %s is not a report server database',16,1,@DBName) END
Date 4/14/2014 11:47:53 PM Log Job History (SimpleJob) Step ID 1 Server SANSLAB\SQL2008R2 Job Name SimpleJob Step Name SimpleStep Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Unable to connect to SQL Server 'SANSLAB\SQL2008R2'. The step failed. |