Try with the fully qualified domain with port no.

Example. Servername.domain.com\SQLinstancename,11001 (port no)

It seems to be an issue with double hop. Assigning kerberos delegation to the sql service account or proxy account would fix it but involves lot of work in my...

The account used must NT AUTHORITY\NetworkService - when you call CreateService or ChangeService config.

Local Security policy - Local policies - User Rights Assignment - Log on as a service -...

I would check if the Network Service account have full permission to this folder.

<install>\Reporting Services\ReportServer\ReportService.asmx

Network service is the default account to run SSRS. The best practice is to...

I believe it's a double hop authentication issue. The account that I am using does have sys. admin permission on both the server.

It does have matching parameter.

SiteID - int

UserID - varchar(32)

If we remove the user_login_test view in the query and replace it with one of the permanent table - it runs in...

Thanks for the tips!

I changed the outer join to inner join and then using >= and <= operator instead of between. The execution time is now less then 10...

Thanks for the quick response !!

The problem is with the VIEW in the query. Here is the view structure

SET QUOTED_IDENTIFIER ON

GO

ALTER VIEW [dbo].[login_test] AS

SELECT * FROM DB_arch.dbo.login_CUR

UNION ALL...

Thanks for the response.. But in my case, database mirroring for 101 databases is working fine :).. I even did a failover, everything seems to be okay. I am not...

yes, that would have caused the job not to run..

I have also seen if the previous day job is running for more than 24 hrs then it will skip or...

Did you check if the job is enabled ?

THANKS FOR THIS ARTICLE. THIS FIXED MY ISSUE............

I found the solution

select convert(varchar(400), decryptbykey(fieldname)) from tblname. Thanks,

I had the same problem. when using the query

Select convert(varchar, decryptbykey(fieldname))

From view_decrypted_MyTable

I found the solution. Try this query

Select convert(varchar(200), decryptbykey(fieldname))

From view_decrypted_MyTable

This works

CONNECTIONSTRING DATATYPE IS VARBINARY(500)

ANY HELP IS APPRECIATED ?