connect the SQL Server in different domains

HI ALL
I have tow domains, in the same forest. From one domain, which has a SQL Ser
ver A , I want to use the Enterprise manager or the Query Analyzer to connec
t the SQL Server B in the other domain and vise versa. Could any one elabora
te all the method to do tha
t.
thank you very much.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.
****************************************
***************************
"ALLEN" <anonymous@.discussions.microsoft.com> wrote in message
news:3F57F4DF-7BB7-4C66-A362-5C112F850ABE@.microsoft.com...
> HI ALL
> 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.
> thank you very much.|||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.
"ALLEN" <anonymous@.discussions.microsoft.com> wrote in message
news:3F57F4DF-7BB7-4C66-A362-5C112F850ABE@.microsoft.com...
> HI ALL
> 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.
> thank you very much.