security problem with OWC 2003 + web page + SQL server...

[Jéjé]

Hi,

I've a web page created in Access.
This page access an SQL Server database.
I've put this page on a web site :
http://myweb1/project/page.htm

my database is on a second computer called databaseserver
My security model with SQL Server is the NT security

Each time a user access my web page, a popup appears with a message:
"this web site uses your identity to access a data source..."

How to disable this prompt?
if my database is on the same server as the web page there is no problems.

Thanks.

Jerome.

 

[Daniel_Ricker]

This is by design and based on IE security settings.

In the IE options dialog, Security Tab, your "site" can
be added to trusted sites where the default cross-domain
data access is allow.

The three settings for Cross-Domain data access are:
Disallow - OWC Silently fails
Prompt - What you are seeing
Allow - Connection with no prompt

 

[Sue]

I had the same problem. The only way I could find to solve
it was to change the User Authentication option to:

Automatic logon with current username and password

You can get to this from with IE:

Tools | Internet Options
Click Security tab
Click Custom Level button
Scroll to bottom of list to find User Authentication option

Hope this helps,
Sue

 

[Jéjé]

yes, thansk.

to resolve the problem I've put my web site under the "trusted" web site
list, and the only difference in the security between trusted and intranet
is the logon type.