Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Unanswered: The operation requested failed due to security problems (the user cannot be authentic

    Hi people,
    I've run into a problem using OLAP service. I am making a MDX select querry to a database located on my company's server. I have an OLAP administrator permissions both on my desktop computer and on the server. And here is the problem, when my ASP.Net application tries to open the connection an Exception occurs:
    "Cannot connect to server "my_server". The operation requested failed due to security problems (the user cannot be authenticated)". When I am debugging my application from my server there is no problem everything goes smooth and on the contrary when I try it from my desktop machine the exception occurs.
    The connection string is:
    sConnString = "Provider=msolap;Data Source= Temp;Initial
    Catalog=temp";
    I have tried though with "Provider=msolap.1" and "Provider=msolap.2"
    and the results are all the same.
    I am using windows 2000 and SQL Server 2000 Enterprice with sp3.
    Any help will be highly appreciated. Thanks in advance.
    Last edited by kamen; 08-31-04 at 05:34.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •