I get this error, when I run a soap query: Basically it can't find the database, but it's fine if I log in as that user and view my cubes on analysis services? Anything I can do, or test? l== HTTP/1.1 500 Server Error l== Connection: close l== Date: Fri, 24 Jun 2005 21:58:47 GMT l== Server: Microsoft-IIS/6.0 l== X-Powered-By: ASP.NET l== Content-Type: text/xml l== l== <?xml version="1.0"?> l== <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> l== <SOAP-ENV:Body> l== <SOAP-ENV:Fault> l== <faultcode>XMLAnalysisError.80004005</faultcode> l== <faultstring>Database 'CRM Oracle' does not exist.</faultstring> l== <faultactor>XML for Analysis Provider</faultactor> l== <detail> l== <faultstring> l== <Error ErrorCode="2147500037" Description="Database 'CRM Oracle' does not exist." Source="XML for Analysis Provider"/></faultstring></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-EN V:Envelope>
when i set managed roles to everyone it works. But I have my user as part of the managed roles. Anyone know what's happening? "Cindy Lee" wrote in message news:%23%23RdrzQeFHA.2076@TK2MSFTNGP15.phx.gbl... > I get this error, when I run a soap query: > Basically it can't find the database, but it's fine if I log in as that user > and view my cubes on analysis services? > Anything I can do, or test? > > l== HTTP/1.1 500 Server Error > l== Connection: close > l== Date: Fri, 24 Jun 2005 21:58:47 GMT > l== Server: Microsoft-IIS/6.0 > l== X-Powered-By: ASP.NET > l== Content-Type: text/xml > l== > l== <?xml version="1.0"?> > l== <SOAP-ENV:Envelope > xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" > SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> > l== <SOAP-ENV:Body> > l== <SOAP-ENV:Fault> > l== <faultcode>XMLAnalysisError.80004005</faultcode> > l== <faultstring>Database 'CRM Oracle' does not exist.</faultstring> > l== <faultactor>XML for Analysis Provider</faultactor> > l== <detail> > l== <faultstring> > l== <Error ErrorCode="2147500037" Description="Database 'CRM Oracle' does > not exist." Source="XML for Analysis > Provider"/></faultstring></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-EN > V:Envelope> > > > >
You probably need to disable Anonymous authentication for the XMLA SDK virtual directory... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Cindy Lee" wrote in message news:Ogq7ABReFHA.580@TK2MSFTNGP15.phx.gbl... > when i set managed roles to everyone it works. But I have my user as part > of the managed roles. Anyone know what's happening? > > "Cindy Lee" wrote in message > news:%23%23RdrzQeFHA.2076@TK2MSFTNGP15.phx.gbl... > > I get this error, when I run a soap query: > > Basically it can't find the database, but it's fine if I log in as that > user > > and view my cubes on analysis services? > > Anything I can do, or test? > > > > l== HTTP/1.1 500 Server Error > > l== Connection: close > > l== Date: Fri, 24 Jun 2005 21:58:47 GMT > > l== Server: Microsoft-IIS/6.0 > > l== X-Powered-By: ASP.NET > > l== Content-Type: text/xml > > l== > > l== <?xml version="1.0"?> > > l== <SOAP-ENV:Envelope > > xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" > > SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> > > l== <SOAP-ENV:Body> > > l== <SOAP-ENV:Fault> > > l== <faultcode>XMLAnalysisError.80004005</faultcode> > > l== <faultstring>Database 'CRM Oracle' does not exist.</faultstring> > > l== <faultactor>XML for Analysis Provider</faultactor> > > l== <detail> > > l== <faultstring> > > l== <Error ErrorCode="2147500037" Description="Database 'CRM Oracle' does > > not exist." Source="XML for Analysis > > > Provider"/></faultstring></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-EN > > V:Envelope> > > > > > > > > > >