Login error

07-16-2009 11:16 AM |

I am using RIA Domain Services and 'out of the box' login routine in business apps happily and login to one site with no problem but another app on the same server using the same SQL Express 2008 sp1 db returns an error :

'Exception of type

'System.windows.Ria.Data.EntityOperationException was thrown.'

It also does not permit the registration of a new user - throwing same exception

Can anyone shed any light on why this might be happening?

Re: Login error

07-16-2009 2:59 PM |

Do you have more information? Like inner-exception and stacktrace?

Re: Login error

07-16-2009 3:24 PM |

Only the error - I don't know how to debug Silverlight 3 - sorry

Re: Login error

07-17-2009 1:08 AM |

Hmm, do you have Visual Studio 2008 SP1? Debugging is as simple as putting a breakpoint in your silverlight code.

If you're having problems, please refer tot his forum post: http://silverlight.net/forums/t/10005.aspx

Re: Login error

07-17-2009 4:20 AM |

Hi Mark

I don't think it is a code problem -

When I use the app on the local machine using the dev browser the login process works fine but if I bring up the app in IE8 (having set up IIS7) the login returns the error - perhaps it has something to do with the db link in the SQL Express db that you apparently have to use for the login (I have'nt yet discovered how to change this default to use the proper SQL server)

Is that why the process is failing? Thanks for your interest and help so far...

Re: Login error

07-17-2009 4:43 AM |

Well, well, well - thay say time heals all...

My login error has mysteriously disappeared after 14+ hours without having made any changes!

It looks intriguingly as though the sql express asp.net db has to think about things for quite a time before operating as intended!

Anyone know how to switch the default login to an asp.net db on SQL proper?

Re: Login error

07-17-2009 4:43 AM |

I agree, I didn't expect a code error, but something like a authorization problem in SQL Express. But the stacktrace most of the time gives a clue about the underlying problem in SQL Server.

Re: Re: Login error

11-05-2009 3:05 PM |

Hello jakb,

would you tell me, how do you resolve the exception, please!!!

I am having same error.

Thanks a lot.

fausto

Re: Re: Login error

11-06-2009 5:45 AM |

 Hi Fausto

Set a specific user, logon & password for your authentication database then modify your web.config:

<connectionStrings>
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="Data Source=[your db server];Initial Catalog=[your database];uid=[your uid];pwd=[your password]" />
</connectionStrings>
   

Re: Re: Login error

11-06-2009 8:24 AM |

Hello Jakb,

It dosn´t work.

If i run the application in my machine, it works excellent, but when i deployed over server (Win 2003) i get this

message:

I think mising one reference, is possible??

Thanks a lot,

fausto 

Re: Re: Re: Login error

11-07-2009 5:48 AM |

Fausto

Maybe -

In your web app make sure you reference:
System.Web.Ria
System.Web.Extensions
System.Web.Services

and if you are using Domain Services
System.Web.DomainServices
System.Web.DomainServices.Providers

 Hope this helps

Re: Re: Re: Login error

11-09-2009 3:53 PM |

Hello Jakb,

i have referenced all of them.

I don´t know, is very strange, in my local machine (win xp) works very well but in windows 2003 server

show this error:

Exception has been thrown by the target of an invocation

Thanks for you help,

Fausto 

Re: Re: Re: Login error

11-24-2009 3:29 AM |

Hi

I got this error with Visual Studio 2010 and .NET Framework 4 Beta and Silverlight Toolkit 4 Beta

Load operation failed for query 'Login'

 at System.Web.DomainServices.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
   at System.Web.DomainServices.DomainOperationEntry.Invoke(DomainService domainService, Object[] parameters, Int32& totalCount)
   at System.Web.DomainServices.DomainService.Query(QueryDescription queryDescription, IEnumerable`1& validationErrors, Int32& totalCount)
   at System.Web.Ria.Services.QueryOperationBehavior`1.QueryOperationInvoker.InvokeCore(Object instance, Object[] inputs, Object[]& outputs)

My settings in web.config are fine and when I use ASP.NET Configuration tool from Visual Studio 2010 it points correct to my aspnetdb database at correct app (it's an existing ASP.NET app with a lot of users).

Any ideas ?