June 24, 2009 at 3:32 am
hii
i try to connect My cube to my web Application using OleBD connection using this connection String
oleDbConn.ConnectionString = "Datasource=.; Provider=msolap; Initial Catalog=FSIC_DB_V2;";
but this exception occurs "Either the user, MSief-PC\M.Sief, does not have access to the FSIC_DB_V2 database, or the database does not exist"
and when use this Connection string
oleDbConn.ConnectionString = "Provider=SQLNCLI.1;Data Source=.;Integrated Security=SSPI;Initial Catalog=FSIC_DB_V2";
this error occures
"Syntax error, permission violation, or other nonspecific error "
pleas can any one tell me how to Connect to Cube?
June 24, 2009 at 9:16 am
What security context is the conneciton being called under? ie, being a web app, it's likely that, unless you're impersonating on the thread, that the context is IUSR_xxx or perhaps even the ASPNET account used by IIS to execute the web app. In a vanilla install of SSAS, neither of these users will have access to the service nor the databases contained in it.
You have a few options, which include impersonating the active web user account (assumes certain things, like it's an internal site/app, your SSAS is on the same machine as IIS etc etc), impersonate a specific account (so this means, a windows username & pwd, accessible to your app, preferably all stored encrypted not clear text 😉 )or to open up access to the anonymous or ASPnet users (not preferred but often seen).
SSAS supports only windows authentication, so you need to keep in mind your context any time you (read as, our app) makes a call.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply