Chart web component

[Candace]

The following message is being returned when trying to
access a chart web component from browser:
"Failed to get data. Data provider could not be
initialized. Login failed for user."
The data source is a sequel table located on another
server on our LAN.
Is there anywhere in the properties of the chart where I
can tell it what login credentials to use when accessing
the data? Or are there any other suggestions for getting
around this problem?
Incidently, users who are administrators do not have this
problem. But of course giving all users admin privileges
just to access this chart is out of the question.

 

[Lisa Wollin \(Microsoft\)]

Hi, Candace,

You need to determine how the web component is authenticating users. If it
uses Windows NT Authentication, then either the database or the network
server doesn't allows users to access the data. You can either give the
users greater privileges, which you've already said isn't an option, or set
different permissions on the server to allow read access to all users on the
network. If all users already have access to the server, then you may need
to set permissions differently in the SQL database to allow read access to
users.

If you need to limit access to the server to only administrators, then you
will need to determine a different way to access the data for end users.
For assistance, try one of the sqlserver newsgroups (for example,
microsoft.public.sqlserver.security) for assistance in setting this up.