CRM 2011: C# Plugin error - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

(0) Share

Report

Posted on by Community Member

I have a C# plugin which reads data from a different SQL server DB (through stored procedure) and creates record in CRM.

Stored Procedure:

The data is retrieved from a table in linked server.

Code:

DataSet dsCandidatesWithInvalidBAPS = new DataSet();

SqlDataAdapter da = new SqlDataAdapter("GetContactDataWithFaults", xyzDB);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.CommandTimeout = sqlTimeout;
da.SelectCommand.Parameters.Add("@topRows", SqlDbType.Int).Value = taskSchedulerArgs[0];

xyzDB.Open();

da.Fill(GetContactDataWithFaults); ------> error at this line

Error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Could you help me please?

Thanks

Bab

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

from the error looks like you didn't specify a username/password to connect to this SQL server, so the sql connection tries to connect with the default parameters and in this case the user is NT AUTHORITY\ANONYMOUS LOGON that has no rights to your database.

update your sql connection to include the username and password of a valid user for that db

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Guido

Thanks for your reply. I already have the username and password of the user which is valid for the database.

My connection string is:

<add name="xyzDB" connectionString="Data Source=servername;Initial Catalog=xyzdb;User Id=domain\username; Password=pwd;Integrated Security=True" providerName="System.Data.SqlClient"/>

Thanks

Bab

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Remove Integrated Security=true piece from your connection string.

Was this reply helpful? Yes No
Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

probably you put this connection string inside an app.config, but plugins can't access to the app.config

so you need to put the connection details inside the secure configuration of your plugin and read the string from it, or hardcode the connection details inside the plugin.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

I would prefer using windows authentication, can you let me know why should I remove the "Integrated Security = true" please?

Thanks

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Because when you have this option identity of current application is used. If you want to use credentials from your connection string you should remove this piece. You can find additional explanation here - stackoverflow.com/.../difference-between-integrated-security-true-and-integrated-security-sspi

Good luck.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andrii

I am getting an error after removing this line of code as well.

Regards

Bab

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Can you please provide code that you use, connection string and error that you get?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Code:

DataSet dsCandidatesWithInvalidBAPS = new DataSet();

SqlDataAdapter da = new SqlDataAdapter("GetContactDataWithFaults", xyzDB);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.CommandTimeout = sqlTimeout;
da.SelectCommand.Parameters.Add("@topRows", SqlDbType.Int).Value = taskSchedulerArgs[0];

xyzDB.Open(); ------> error at this line

da.Fill(GetContactDataWithFaults);

Connection string:
<add name="xyzDB" connectionString="Data Source=servername;Initial Catalog=xyzDB;User Id=domain\username; Password=pwd providerName="System.Data.SqlClient"/>

Error:
Login failed for user 'domain\username'.

Regards
Bab

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

That means that user "domain\username" doesn't have privileges to access xyzDB database or server "servername" at all.

Was this reply helpful? Yes No