Easy Question 2

[Douglas Osborne]

2. My Pivot table and linked chart render fine when I hit my web site.
However, when anyone else hits the site, they get a 'Login failed for use
'<username>' - can I run my query passing in the username and password - it
seems to ignore it. Here is my connection string

<add key="OLAPConnectionString" value="Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=True;Data Source=DOSBORNE2;Initial
Catalog=Advantage;User ID=sa;Password=password;" />

Does anyone see anything wrong with this? Why is it trying to run as the
user as opposed to the credentials I pass in?

TIA,
Doug