Friday, February 24, 2012

Connecting MS, or EM to a server on a non-trusted domain

We have just put a new SQL Server 2000 (on Windows Server 2003 R2) in a
non-trusted Windows domain.
I can rdp to the machine just fine, but I can't get MS to connect.
My machine (and most servers) are in the HOME domain and the new server is
in the non-trusted QA domain.
I've tried several combinations, including creating a SQL Server login for
my use on the server - no joy.
I'm fairly certain this can work, but I'm out of idea's as to how ...
Thanks,
JayMake sure that you configured the SQL in Mixed mode authentication.
Regards,
Mohammad Daoud | Technical Development Manager | Mobile +962 79 999 65 85
Tel. +962 6 554 3721 | daoudm@.greatpbs.com
http://www.greatpbs.com| http://www.facebook.com/group.php?gid=18895609248/
"Jay" wrote:

> We have just put a new SQL Server 2000 (on Windows Server 2003 R2) in a
> non-trusted Windows domain.
> I can rdp to the machine just fine, but I can't get MS to connect.
> My machine (and most servers) are in the HOME domain and the new server is
> in the non-trusted QA domain.
> I've tried several combinations, including creating a SQL Server login for
> my use on the server - no joy.
> I'm fairly certain this can work, but I'm out of idea's as to how ...
> Thanks,
> Jay
>
>|||Ya, thanks. I had already checked that. Actually, I found that port 1433 was
blocked and that it was by design.
Jay
"Mohammad Daoud" <MohammadDaoud@.discussions.microsoft.com> wrote in message
news:CC64BC8A-BE8C-4BBC-BB84-AC45FA5BFBB7@.microsoft.com...[vbcol=seagreen]
> Make sure that you configured the SQL in Mixed mode authentication.
> Regards,
> Mohammad Daoud | Technical Development Manager | Mobile +962 79 999 65 85
> Tel. +962 6 554 3721 | daoudm@.greatpbs.com
> http://www.greatpbs.com|
> http://www.facebook.com/group.php?gid=18895609248/
> "Jay" wrote:
>

No comments:

Post a Comment