Office web parts access

Hi all:



I built a dashboard utilizing the Office Web parts in the following
environment:



SBS 2003 Premium

Client running WS 2003 joined to the SBS domain



http://companyweb is the STS site and is in the Local Intranet Zone, if I
put it in "Trusted Sites" I get prompted for a username and password. I have
set the IE security to "Automatic logon with current username and password".



The dashboard is stored in the "General Documents" folder, and the data
source is a local SQL Server. So when I load http://companyweb on the server
machine, all is well, but when I go to the client and try to load the
dashboards, I get a prompt that says:



"This website uses a data provider that may be unsafe. If you trust the
website, click OK, otherwise click Cancel."



If I click OK, the dashboard loads OK, but that prompt is really not a good
thing when doing a Live demo, the customer immediately asks why they see
that security prompt! I have done this before and not seen the prompt, and I
have no idea what could be going wrong.


Can anyone offer any help?

John.

--
This message sent from Windows Vista!

Alan
Tue Sep 12 09:06:34 CDT 2006

Hi John,

I had the same thing. Add the website to your trusted zones in internet
explorer and that should fix it. If I remember correctly.

Alan


"John" <jstraumann@hotmail.com> wrote in message
news:6E8FC20F-C9FD-472F-8987-7C7789A748DB@microsoft.com...
> Hi all:
>
>
>
> I built a dashboard utilizing the Office Web parts in the following
> environment:
>
>
>
> SBS 2003 Premium
>
> Client running WS 2003 joined to the SBS domain
>
>
>
> http://companyweb is the STS site and is in the Local Intranet Zone, if I
> put it in "Trusted Sites" I get prompted for a username and password. I
> have set the IE security to "Automatic logon with current username and
> password".
>
>
>
> The dashboard is stored in the "General Documents" folder, and the data
> source is a local SQL Server. So when I load http://companyweb on the
> server machine, all is well, but when I go to the client and try to load
> the dashboards, I get a prompt that says:
>
>
>
> "This website uses a data provider that may be unsafe. If you trust the
> website, click OK, otherwise click Cancel."
>
>
>
> If I click OK, the dashboard loads OK, but that prompt is really not a
> good thing when doing a Live demo, the customer immediately asks why they
> see that security prompt! I have done this before and not seen the prompt,
> and I have no idea what could be going wrong.
>
>
> Can anyone offer any help?
>
> John.
>
> --
> This message sent from Windows Vista!

Alan
Tue Sep 12 09:16:32 CDT 2006

Sorry, I missed part of the statement there about already adding to the
trusted zones. I was doing the same thing and the trusted zone thing worked
for me.


"John" <jstraumann@hotmail.com> wrote in message
news:6E8FC20F-C9FD-472F-8987-7C7789A748DB@microsoft.com...
> Hi all:
>
>
>
> I built a dashboard utilizing the Office Web parts in the following
> environment:
>
>
>
> SBS 2003 Premium
>
> Client running WS 2003 joined to the SBS domain
>
>
>
> http://companyweb is the STS site and is in the Local Intranet Zone, if I
> put it in "Trusted Sites" I get prompted for a username and password. I
> have set the IE security to "Automatic logon with current username and
> password".
>
>
>
> The dashboard is stored in the "General Documents" folder, and the data
> source is a local SQL Server. So when I load http://companyweb on the
> server machine, all is well, but when I go to the client and try to load
> the dashboards, I get a prompt that says:
>
>
>
> "This website uses a data provider that may be unsafe. If you trust the
> website, click OK, otherwise click Cancel."
>
>
>
> If I click OK, the dashboard loads OK, but that prompt is really not a
> good thing when doing a Live demo, the customer immediately asks why they
> see that security prompt! I have done this before and not seen the prompt,
> and I have no idea what could be going wrong.
>
>
> Can anyone offer any help?
>
> John.
>
> --
> This message sent from Windows Vista!

Engelbert
Tue Sep 12 10:46:19 CDT 2006

This

"This website uses a data provider that may be unsafe. If you trust the
website, click OK, otherwise click Cancel."

is fairly standard and the only solution I know is to add that data provider
to your trusted sites list which it's unclear whether you have done or not.

The other question there about why is it asking for name/permission when you
have set trusted to "Automatic logon with current username and password"
might well be that the current username and password isn't what you think it
is. If they are for instance logged on to the client as Local admin on the
client and you have assigned them to WSS as domainname\username then current
username and password won't work as the site doesn't know them as that.

Engelbert

"John" <jstraumann@hotmail.com> wrote in message
news:6E8FC20F-C9FD-472F-8987-7C7789A748DB@microsoft.com...
> Hi all:
>
>
>
> I built a dashboard utilizing the Office Web parts in the following
> environment:
>
>
>
> SBS 2003 Premium
>
> Client running WS 2003 joined to the SBS domain
>
>
>
> http://companyweb is the STS site and is in the Local Intranet Zone, if I
> put it in "Trusted Sites" I get prompted for a username and password. I
> have set the IE security to "Automatic logon with current username and
> password".
>
>
>
> The dashboard is stored in the "General Documents" folder, and the data
> source is a local SQL Server. So when I load http://companyweb on the
> server machine, all is well, but when I go to the client and try to load
> the dashboards, I get a prompt that says:
>
>
>
> "This website uses a data provider that may be unsafe. If you trust the
> website, click OK, otherwise click Cancel."
>
>
>
> If I click OK, the dashboard loads OK, but that prompt is really not a
> good thing when doing a Live demo, the customer immediately asks why they
> see that security prompt! I have done this before and not seen the prompt,
> and I have no idea what could be going wrong.
>
>
> Can anyone offer any help?
>
> John.
>
> --
> This message sent from Windows Vista!

John
Wed Sep 13 03:14:42 CDT 2006

John
We had the problem of "This website uses a data provider that may be
unsafe. If you trust the website, click OK, otherwise click Cancel."
Initially, we solved it with the trusted zone solution but further
investigation uncovered that this warning was from MDAC and by setting
the 1A00 registry setting, the warning message was no longer shown.
This registry entry covers the Local Intranet (Zone 1) for a Windows
2000 machine:

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet
Settings\Zones\1]
"1A00"=dword:00000000

For further details try - http://support.microsoft.com/kb/182569/
Best Wishes, John.