HI AL

I have tow domains, in the same forest. From one domain, which has a SQL Server A , I want to use the Enterprise manager or the Query Analyzer to connect the SQL Server B in the other domain and vise versa. Could any one elaborate all the method to do that

I'm assuming this is more than just opening Query Analyzer and connecting to
a server name. What you probably want to do is add a linked server -- go to
SQL Enterprise Manager and add a new linked server under the security
section. That will let you run queries such as

select * from serverb.<database>.<owner>.<table>

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]
Server A , I want to use the Enterprise manager or the Query Analyzer to
connect the SQL Server B in the other domain and vise versa. Could any one
elaborate all the method to do that.
[quoted text, click to view]

You should not find any difference in normal connectivity, but there is one
thing that you might want to be aware of in this particular scenario. If you
want to use Kerberos Authenticatin then you will have to register an SPN for
the SQL Server using NETBIOS name.

Generally SPN should be registered in the following format

MSSQLSvc/sqlmachine.domain.net:1433 sqlserviceact

But to enable Kerberos protocol in this inter domain scenario, you will also
need to register an SPN using the NETBIOS name
MSSQLSvc/sqlmachine:1433 sqlserviceact

Thanks,
Bala.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
[quoted text, click to view]
Server A , I want to use the Enterprise manager or the Query Analyzer to
connect the SQL Server B in the other domain and vise versa. Could any one
elaborate all the method to do that.
[quoted text, click to view]