Component using logged on user information

I am trying to connect to a OLAP database using the ADO connection object.

I am giving the following connection string

"provider=msolap; data source=machinename;initial catalog=Foodmart"

It works provided the machine is the same as the IIS server but when I try to connect to a different machine on the network it says foodmart doesnt exist even though foodmart exists. I tried putting the connect method inside a vb DLL and register it under MTS. Now after giving it interactive identity it works provided the user who has the permission on the databse logged on to the server.

Users will be logging on uing the IE and not on server directly. Even though I logged as a different user from IE it is taking the same security credential as the user who has logged on locally.

How do I register the component so that it takes the user who has logged on remotely using IE rather then the user who has logged on locally?

Any suggessions is appreciated

Try setting up a system user account for the foodmart database, and then coding the UserId and password into the MTS object.

Then it should not matter where the object is called from.