In non-domain environments, you can accomplish the same functionality by using the same username and password on both accounts. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server from a user session using the same domain account. SQL Server Analysis Services uses Windows authentication for server connections.
