I can run this from the server that runs on the same domain as the sql server but I need this on the webserver which is on another domain hitting the sql server across the web.
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MS-RTC LM 8; .NET4.0C; .NET4.0E; InfoPath.3)
Timestamp: Wed, 2 Mar 2011 19:27:51 UTC
Message: Unhandled Error in Silverlight Application
Code: 4004
Category: ManagedRuntimeError
Message: LoginException: Unable to login: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. --->
at IdeaBlade.EntityModel.CoroutineOperation.HandleError(INotifyCompletedArgs notifyCompletedArgs)
at IdeaBlade.EntityModel.CoroutineOperation.OnCompleted(INotifyCompletedArgs notifyCompletedArgs)
at IdeaBlade.EntityModel.CoroutineSerialProcessor.HandleCompletedAndProcessNext(INotifyCompletedArgs args)
at IdeaBlade.EntityModel.BaseOperation.BaseOnCompleted()
at IdeaBlade.EntityModel.BaseOperation`2.OnCompleted()
at IdeaBlade.EntityModel.BaseOperation`2.IdeaBlade.EntityModel.IHasAsyncEventArgs.OnCompleted()
at IdeaBlade.EntityModel.AsyncProcessor`1.<>c__DisplayClass2.<.ctor>b__0(TArgs args)
at IdeaBlade.EntityModel.AsyncProcessor`1.Signal()
at IdeaBlade.EntityModel.AsyncProcessor`1.<Execute>b__5(Object x)
Line: 56
Char: 13
Code: 0
URI: http://localhost:9009/Default.aspx