get error when running PTServiceClient

tseveryn posted on Monday, November 06, 2006

Hi,

Need a little bit of help please.

I got PTWin and  PTWeb working. Also got http://localhost/PTWebSrvice/PTService.asmx working (all with the local data portal using CSLA authentication), however when running PTServiceClient get the following error:

System.Web.Services.Protocols.SoapException was unhandled

  Actor=""

  Lang=""

  Message="System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: User does not have permission to perform this action.

   at PTService.GetProjectList() in C:\WorkSpace\Projects\csla20vb\csla20vb\PTWebService\App_Code\PTService.vb:line 40

   --- End of inner exception stack trace ---"

  Node=""

  Role=""

  Source="System.Web.Services"

  StackTrace:

       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

       at PTServiceClient.PTService.PTService.GetProjectList() in C:\WorkSpace\Projects\csla20vb\csla20vb\PTServiceClient\Web References\PTService\Reference.vb:line 131

       at PTServiceClient.MainForm.MainForm_Load(Object sender, EventArgs e) in C:\WorkSpace\Projects\csla20vb\csla20vb\PTServiceClient\MainForm.vb:line 7

       at System.EventHandler.Invoke(Object sender, EventArgs e)

       at System.Windows.Forms.Form.OnLoad(EventArgs e)

       at System.Windows.Forms.Form.OnCreateControl()

       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

       at System.Windows.Forms.Control.CreateControl()

       at System.Windows.Forms.Control.WmShowWindow(Message& m)

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

       at System.Windows.Forms.ContainerControl.WndProc(Message& m)

       at System.Windows.Forms.Form.WmShowWindow(Message& m)

       at System.Windows.Forms.Form.WndProc(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

       at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)

       at System.Windows.Forms.Control.SetVisibleCore(Boolean value)

       at System.Windows.Forms.Form.SetVisibleCore(Boolean value)

       at System.Windows.Forms.Control.set_Visible(Boolean value)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

       at System.Windows.Forms.Application.Run(ApplicationContext context)

       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()

       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()

       at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)

       at PTServiceClient.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81

       at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)

       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)

       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()

       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)

       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

       at System.Threading.ThreadHelper.ThreadStart()

 

Thank you very much,

Teresa Severyn

RockfordLhotka replied on Tuesday, November 07, 2006

tseveryn:

System.Web.Services.Protocols.SoapException was unhandled

  Actor=""

  Lang=""

  Message="System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: User does not have permission to perform this action.

   at PTService.GetProjectList() in C:\WorkSpace\Projects\csla20vb\csla20vb\PTWebService\App_Code\PTService.vb:line 40

The exception tells you the issue: the user doesn't have permission to perform the action. Since this is a SqlException, the problem is coming from the database itself, so it is a good bet that the connection string for the database is incorrect and the user is unable to log into the database to get the data.