Hi Brain,

I have a problem here 🙁

I've configured everything correctly in my SCCM environment. And i used to connect the CAS database from a separate box(same domain) which has SSMS console installed in it. Now the problem is, whenever i try to run a query in CAS locally, it runs successfully. But when i connect the CAS database remotely and run the same query with the same login i used in CAS, it says the below error. This is happening from past 2 days only. :'(

Query ran :

select top 100 * from v_GS_WORKSTATION_STATUS

Error :

Msg 18456, Level 14, State 1, Line 1

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

OLE DB provider "SQLNCLI11" for linked server "abc.domain.com" returned message "Invalid connection string attribute".

I checked the SQL connection authentication information it says authenticated by kerberos.

1362015-01-30 17:50:29.2772015-01-30 17:50:29.280domain\userTSQLKERBEROSservernameMicrosoft SQL Server Management Studio

But, another wierd information is i can successfully run the below query.

select * from vSMS_R_System

Pleaseeeeeeee helppp me...... 🙁

Regards,

Jay