Re: connect the SQL Server in different domains

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bala Neerumalla[MSFT] (balnee_at_online.microsoft.com)
Date: 02/20/04 

Date: Thu, 19 Feb 2004 22:07:23 -0800

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.

Relevant Pages

  • RE: 0x80004005 - you need permission to view its data
    ... SPN without the port number and another SPN with the port number. ... typical, non-clustered computer that is running SQL Server, you only have ... to register the SPN with the port number. ...
    (microsoft.public.sqlserver.security)
  • RE: Msg 15404: Could not obtain information about user
    ... not register the Service Principal Name (SPN) for the SQL Server service. ... authentication to fall back to NTLM instead of Kerberos. ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to use Kerberos Delegation from IE6 --> IIS 5.0 (asp.net)--> SQL 2000
    ... If you change the port SQL Server listens on, ... need to register a new spn for SQL Server. ... The spn for the server is associated with a unique port. ...
    (microsoft.public.sqlserver.security)
  • Re: updating and downdating
    ... SQL Server and replication would lend itself really really well to this ... scenario and the Publisher/Subscriber model is made JUST for this. ... "Neil" wrote in message ... > I have a vb.net app that runs on a few machines storing data in a local ...
    (microsoft.public.dotnet.languages.vb)
  • Re: update and downdate ?
    ... SQL Server and replication would lend itself really really well to this ... scenario and the Publisher/Subscriber model is made JUST for this. ... periodically send the updates back and refresh them. ... > I have a vb.net app that runs on a few machines storing data in a local ...
    (microsoft.public.dotnet.framework.adonet)