"User Not Authorized" Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Travich - 10 Oct 2006 22:18 GMT

I have a .NET 1.1 WinForms application that used to only hit SQL Server
2000. We are now contemplating moving to SQL Server 2005.

To test this, we set up a SQL Server 2005 box and installed the web
services and client application on the same box. When the application
tries to call a web service that it could normally call in the past, it
get's the following error:

System.Web.Services.Protocols.SoapException: User Not Authorized

I have a feeling that something in IIS is not configured correctly, but
I've been looking at it all day and with no luck. I appreciate if
anyone can help me solve this mystery...

Travich

Reply to this Message

John Saunders - 11 Oct 2006 01:35 GMT

>I have a .NET 1.1 WinForms application that used to only hit SQL Server
> 2000. We are now contemplating moving to SQL Server 2005.
[quoted text clipped - 9 lines]
> I've been looking at it all day and with no luck. I appreciate if
> anyone can help me solve this mystery...

It looks like a case of too many variables. You moved the web services and
the client, and changed databases. Remove some of those variables so you can
see which one is causing the problem.

John

Reply to this Message

Travich - 17 Oct 2006 19:53 GMT

The exception was a user defined exception.

We're still troubleshooting, but the issue appears to be with the way
SQL XML is handled in our sprocs.

> >I have a .NET 1.1 WinForms application that used to only hit SQL Server
> > 2000. We are now contemplating moving to SQL Server 2005.
[quoted text clipped - 15 lines]
>
> John

Reply to this Message

"User Not Authorized" Error

Free Magazines