Having Login Error problem

Posted by Naeem2049 under ASP.NET on 2/27/2011 | Points: 10 | Views : 1538 | Status : [Member] | Replies : 7
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




Responses

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

Up
0
Down
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 "

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/

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

Up
0
Down
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

Up
0
Down
Have you tried??

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/

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

Up
0
Down
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

Up
0
Down
Is it resolved??

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/

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

Up
0
Down
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

Up
0
Down

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

Login to post response