402.1 error

Question

402.1 error

Malka W

SSC Enthusiast

Points: 153
More actions
September 5, 2006 at 6:10 am

#172350

Hi,
as you can tell i am new to sql server.
I have access to databases in the sql server, via another server.
But apparently I acn only access the tables in the databases for viewing alone.
The minute I add a bit of code to create a new recordset or update, etc, I get the 401.2 error:
HTTP Error 401.2 - Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)
I've looked everywhere on the www for a solution to the problem, but have come up with nothing. I hope you can provide me with some help.
Thanks in advance
eM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Sounds like you have a problem with IIS and not sql server itself (unless you are missing permission to do inserts/updates/delete from a remote server)... Just throwing ideas in there .

Malka W SSC Enthusiast Points: 153 More actions · Answer 2

I have changed the permissions to the tables I am using, allowing select, insert, update, delete.

What recommended changes do you think I should try in IIS to try and fix the problem?

I am such a newbie, that I'll need elaborated explainations. I appologize in advance for being such a newsense.

Thanks,

Malka

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Don't worry about the newbie thing, we all started there some day . However I have no idea how to fix that problem since I was never confronted with anything like that. Did you retry to execute the code after you made the permission changes? Did the error message change?

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 4

Have you tried executing the Code that was generated by the web page(using the login credential used by the web page). If that works then its nothing related to SQL Server and your "Insert/Update" statement. If that fails it will tell you what the problem is.

Thanks

Sreejith

Malka W SSC Enthusiast Points: 153 More actions · Answer 5

I realized that the problem isn't update and insert but that the display message for ALL errors is the same message.

So my next question is, what changes do I do in the IIS to make it display user friendly error messages? (Like trying to execute an instruction on a recordset that didn't exist - all I'd want to see in the error message is that the recordset doesn't exist or something similar)

I hope you are able to help me through this.

M

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

I wish I could help but my experience with IIS in extremely limited and I never encountered that error.