Recently, i deployed BI solution using OWC and ASP.NET to the client. They use Windows 2000 Server for NT domain network. All Clients using Windows XP.
I set database roles to users in Analysis Services, those are domain users that i selected from the list in Analysis Services.
When accessing cubes from Pivot Table in most machines users to whom cube rights been granted can see cubes, but there are few client machines where Pivot Table can not connect to cubes, even though the same domain account works in other machines.
All clients machines running in same NT domain and are in same IP range. I suspect it is due to some setting in those WinXP machines where Pivot Table can not connect to cobe.
I would appreciate your assistance due to matter is very urgent.