Access Analysis Services from a pc in a Workgroup

[pjw001]

Good Morning,

I have SQL2008 R2 running on an XP pc that is in a domain. On that pc is a VM that is in a Workgroup.

I need to access the Analysis Services on the host pc via a software package.

I have tried using Stored User Names but it does not work.

The software is able to create the two databases with the required entities, but it fails trying to update the datawarehouse. (The error message says that it had an error reading from a text file on the virtual pc.)

Any help or suggestions would be much appreciated.

Thanks.

 

[SQLBill]

The issue isn't that you can't access Analysis Services...you can since you can create the two databases.

The issue is the host server cannot access your PC. You need to find out how the host server is trying to access your file, create a share and put the file there, then grant the host server permission to access your share.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[pjw001]

Thanks for the reply.

The only software on the host that might be trying to access the VM is SQL Server Analysis Services.

I will create shares on the VM and see what happens.

 

[SQLBill]

What login is SQL Server Analysis Services using? That login needs to be able to access the shares on your PC. The default is for the service to use Local Admin login, which won't have access to other computers. If you could get it changed to a domain account, then it should be able to access the shares on your PC.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875