473,322 Members | 1,408 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

"User Not Authorized" Error

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

Oct 10 '06 #1
2 1819
"Travich" <tr*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
>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...
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
Oct 11 '06 #2
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.

John Saunders wrote:
"Travich" <tr*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
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...

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
Oct 17 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: MLH | last post by:
I copied the following code snippet from A97 HELP. Am getting an error at compile time suggesting there's a problem with the first line (compile error, user-defined type not defined). It is likely...
1
by: fl | last post by:
I am running ASPNET on my local machine. I have a problem when I try to connect to a SQL server database table. The data looks good when I right click SqlDataAdapter1 to preview the data. When F5...
3
by: Michael Tkachev | last post by:
Hello, I need to create an "Excel" file in the ASP.net. But a security system doesn't allow to do it. What can I do? There is an exception heppens when I try to execute the following row: ...
1
by: platinumbay | last post by:
Sometimes when I run or build (or save I think) one of several VB .NET CE applications I get the above error. I then get a 'save file as' option to change the 'myapp.vbdproj' file. If you keep the...
4
by: Ying Lu | last post by:
Hello, I have a table named "USER" under MySQL database. When I am trying to move tables from MySQL to PostgreSQL, I found that I could not create a table namely "USER". I guess "USER" is a key...
0
by: godsmustbcrazy | last post by:
Here is my problem. Brand new SQL Server 2005 Installation 1. Create a database "Test" 2. Create a database user "Domain\user" and set user mapping to "Test" with datareader, datawriter...
8
MMcCarthy
by: MMcCarthy | last post by:
Hi everyone I had an interesting problem today with a client. I have set up security and privilege on a database depending on NT User Login. However, I've only just realised that the code...
11
by: Jan | last post by:
Hi: Here's a problem I've had for a long time. The client is really running out of patience, and I have no answers. Access2003, front- and back-end. Single form with 4 subforms (each...
11
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.