connection problem 1

[minckle]

im creating an web app using standard asp. my connection string is as follows:

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Q2A;Trusted_Connection=yes;"

When i load the site via the localhost everything runs fine, but when i load the site externally i get the folloing error:

Microsoft OLE DB Provider for SQL Server error '80040e09'
INSERT permission denied on object 'tblEnquiry', database 'Q2A', owner 'dbo'.

The IUSR_ account is registered as a user and has the neccessary permissions to run an INSERT.

Am i missing something basic?? any 1 got any ideas????
thanks

 

[vongrunt]

Plz define "load externally". Same database, but from another web server?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[minckle]

Hi, yeh its the same database and also the same web server

when i open IE on the server where the DB and the webserver is n goto 'Localhost/webpage1.asp' the connection works fine. but when i try it from another computer '

http://www.website.co.uk/webpage1.asp'

i get the permissions error

im using exactly the same webpage,database etc

hope this helps !!!