Having Login Error problem

Posted by Naeem2049 under ASP.NET on 2/27/2011 | Points: 10 | Views : 2336 | Status : [Member] | Replies : 7

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi All,

I have an application in Visual studio 2008 using SQL server 2008 R2 ...

When i try to login through Login Form ... I put the Username and password but following error is coming...

Error:
--=-=-=-

No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).

I can't understand What type of this error is ...

Please help me in this ...

Thanks
NAEEM

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Naimishforu on: 2/27/2011 [Member] [MVP] Bronze | Points: 25

0	This error occur because the OleDbProvider needs you to inform which provider it will use for Integrated Security, and by putting "true" in this parameter you are not really telling which provider it should use. Thus, in order to use Integrated Security with OleDb, you just have to inform that it should use the Security Service Provider Interface (SSPI) in your connection string: "Provider=SQLOLEDB;Data Source=ServerName\Instance;Initial Catalog=DatabaseName;Integrated Security=SSPI " Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

This error occur because the OleDbProvider needs you to inform which provider it will use for Integrated Security, and by putting "true" in this parameter you are not really telling which provider it should use.

Thus, in order to use Integrated Security with OleDb, you just have to inform that it should use the Security Service Provider Interface (SSPI) in your connection string:

"Provider=SQLOLEDB;Data Source=ServerName\Instance;Initial Catalog=DatabaseName;Integrated Security=SSPI "

Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 2/27/2011 [Member] [MVP] Bronze | Points: 25

0	Naeem.. please try as suggested by Naimish.. Thanks and Regards Madhu Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naimishforu on: 2/27/2011 [Member] [MVP] Bronze | Points: 25

0	Have you tried?? Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Madhu.b.rokkam on: 2/28/2011 [Member] [MVP] Bronze | Points: 25

0	Hope his issue is resolved.. Thanks and Regards Madhu Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naimishforu on: 2/28/2011 [Member] [MVP] Bronze | Points: 25

0	Is it resolved?? Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Madhu.b.rokkam on: 2/28/2011 [Member] [MVP] Bronze | Points: 25

0	hopefully... Thanks and Regards Madhu Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naeem2049 on: 3/1/2011 [Member] Starter | Points: 25

0	Hi All, No the upper error was solved but the new error was coming ... Please check this error.... Thanks for reply and Help... Regards NAEEM Download source file Naeem2049, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts