Re: Error 80004005 - Database ... does not exist

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 11:28:46 -0700

Bingo. Set it up as a domain account. That will be the security context for
accessing the Analysis server. 

-- 
Dave Wickert [MSFT]
dwickert@online.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.
"Chet Cromer" <chetsjunk@ccrtc.com> wrote in message
news:eJzEXVckEHA.1152@TK2MSFTNGP11.phx.gbl...
> Authentication methods are Anonymous and Basic.
>
> This page is part of an intranet site for a small company, and we
> control access to the pages through our own id/password list (do not
> utilize any windows security).
>
> The default user for Anonymous is the IUSR... account for the web
> server, which now that I think of it, would not have access to ANYTHING
> on the other server, since it's not a domain account. If I changed the
> default account to a domain account with access to the data on the
> server, would that do the trick?
>
> Thanks for your help... I'll stop reinstalling things now. :)
>
> Chet
>
> "Dennis Redfield" <dennis.redfield@acadia-ins.com> wrote in message
> news:eU7Lp1bkEHA.3872@TK2MSFTNGP11.phx.gbl:
> > Chet,
> > STOP reinstalling things.  (we assume here that the OLAP Database
> > Backoffice exists).
> > What is the authentication method used by the asp page which is
attempting
> >
> > to use your connection string.  The format you are using will us the
> > identity of the called (the asp page).
> > Is this user allowed to access the database?  look at your security
> > setup.
> >
> > hope this helps,
> >
> > dlr
> >
> > "Chet Cromer" <chetsjunk@ccrtc.com> wrote in message
> > news:%231XGsbFkEHA.3696@TK2MSFTNGP15.phx.gbl...
> >
> > > I have a web page on a web server that pulls data from a cube on
> > > another
> > > server that has SQL Server Analysis Serivces installed. When I try to
> > > establish the connection I get the following error:
> > >
> > > MicrosoftR OLE DB Provider for Analysis Services error '80004005'
> > >
> > > Database 'Backoffice' does not exist.
> > >
> > > /.../.../....asp, line 154
> > >
> > > I have done some reading and tried several things already, but have
> > > only
> > > gotten a little bit closer. I have AS installed on the web server as
> > > well
> >
> > (I
> >
> > > am moving the cubes from this computer to the other one to reduce the
> > > load
> > > on the server) and don't get any problems. Here is what I have done:
> > >
> > > Reinstalled SQL Server Analysis Services SP3 on the SQL Server
> > > Reinstalled SQL Server Analysis Services SP3 on the Web Server (this
> >
> > allowed
> >
> > > me to start using the MDX Sample Application to query cubes on the SQL
> > > Server, which did not work before I did this)
> > >
> > > I've gotten it so that I can access the server from another computer
> > > using
> > > the MDX Sample Application and Microsoft Excel 2003. However, I still
> >
> > cannot
> >
> > > get my web page to see the database. I am using an ado connection
> > > object
> >
> > to
> >
> > > try to establish the connection, and then (the code never gets this
> > > far),
> >
> > I
> >
> > > have an MDX statement that loads a recordset full of the data to be
> > > displayed. Here is the connection string:
> > >
> > > cn.Open "Data Source=SERVERNAME;Initial
> >
> > Catalog=Backoffice;Provider=msolap;"
> >
> > >
> > > Can anyone help me out? Thanks!
> > >
> > > Chet
> > >
> > >
>

Relevant Pages

  • Re: Borland is neglecting Delphi for Win32 badly
    ... Today in SQL ... Server 2000 you can write server extensions as COM objects and call them via ... SQLCLR allows CLR ... The security benefits are also tremendous and we could discuss for a long ...
    (borland.public.delphi.non-technical)
  • Re: SQL Permissions
    ... In advanced security the site server machine account has to be a member ... of the site server to sql connection group. ...
    (microsoft.public.sms.setup)
  • RE: Users Logins
    ... On the sql ... server machine, go to start, programs, SQL Server, then choose the icon for ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL permission problem when installing SMS2003 in 2003 network
    ... Scenarios and Procedures for SMS 2003: Security ... >> I may need to put this post in an SQL newsgroup, ... >> install SMS2003 on ServerB. ... >> "Either the SQL Server is in a Windows NT 4 domain or this computer's ...
    (microsoft.public.sms.setup)
  • Re: Web and SQL Security
    ... If SQL server is the same box of IIS, you may consider disable TCP and ... named pipes protocals so that it is not possible to access SQL server from ... | Thread-Topic: Web and SQL Security ...
    (microsoft.public.sqlserver.security)