I'm trying to connect to SQL MSDB store using ADO.Net SQLConnection class in the windows authentication mode using c#.
Connection string I'm using is "Data Source=datasource; Initial Catalog=msdb; Integrated Security=True".
When the control reaches connection.open() in the code, it errors out with the message
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I made sure that I'm an admin on the SQL machine and my 'user' object is mapped to MSDB db .
View Complete Post