I have a SQL box and a IIS server. On the IIS box I have istalled Analysis
Server and have place several cube that I wish client to access via a VPN
connection and a web application. When I try to reporcess the cube I get an
NT Authorization error. I can build the cube on the IIS server but not
process it. Any ideas on how to fix the authorization error without opening
up the SQL box to the world? The SQL box is Windows 2000 server and the IIS
is Windows 2003 web version. SQL and Analysis servers are both 2000 with the
latest patches installed.

My guess is that you don't have a common domain between machines; if one
doesn't exist then the system uses the anonymous account.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"pat" <pat (AT) discussions (DOT) microsoft.com> wrote

You are correct both servers are in the same workgroup on a network but not
appart of the network. My problem is how do I give the anonymous account
enough rights on the sql box to let it process the cube or is this a
possible. What I am doing now is creating a CAB file coping to the IIS box
and restoring the data base. This works but takes time.

Any better ideas????

"Dave Wickert [MSFT]" wrote:

Administration and querying requires a common domain between machines; you
cannot use workgroups. There are some workarounds that you can look at --
they are discussed in the security section of the AS Operations Guide, see:
http://www.microsoft.com/technet/pro.../anservog.mspx

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"pat" <pat (AT) discussions (DOT) microsoft.com> wrote

Thanks for the link. I will check it out -- looks like a work around in the
security section. I will read tonight.

Thanks again.

Pat
"Dave Wickert [MSFT]" wrote:

On a related note, I am trying to give access to my cubes, through the web,
to a user from home (ie. outside the domain). They can get to the page and
authenticate, but when they try and move a dimension there is the error
"Initialization of the data source failed".

Is there a way around this, please?

"pat" wrote: