Connect to SQL named instance from another domain

Hi,

I have two domains setup with two way trust in place. SQL server 2005 is installed in domain A.

Is it possible to log in to SQL server using machine account of a machine in domain B?

I have been told that you cannot access SQL server from another domain using machine account. But I cannot find any resource or references about it.

If this isn't the right MSDN forum for this I apologize, but any advice would be greatly appreciated.

Thanks in advance.

Hi,

You can achive this by creating the same machine account of the one in domain B on the machine in domain A, and grant login to it.

HTH.

Ming.

|||

Hi

I am facing the same issue ... I have reporting servcies in domain A and Analysis Server on domain B , but there are no trust principles between domains. I need the reports to query the AS but my datasources are not able to establish a connection with the Analysis Server becuase its lying on another domain.

Is there a work around .

Jayanth