I have a Microsoft Windows Server 2000 (5.00.2195) Service Pack 4 with 1.5
Gigabyte RAM in a workgroup called: “Workgroup”. It runs a SQL Server package
with allows reports from our UNIX server to be run. The authors of the
package say the SQL Server cannot be moved into our Domain. They also do not
want us to create a domain and they want us to leave the SQL Server in the
workgroup. I have researched a “two-way Realm Trust”but this does not seem to
be a viable solution. I need it’s passwords to synch with our Windows Server
2003 Domain passwords.
Any ideas?
Thanks!

--
brian

Brian Buchholz wrote:
> I have a Microsoft Windows Server 2000 (5.00.2195) Service Pack 4
> with 1.5 Gigabyte RAM in a workgroup called: "Workgroup". It runs a
> SQL Server package with allows reports from our UNIX server to be
> run. The authors of the package say the SQL Server cannot be moved
> into our Domain. They also do not want us to create a domain and they
> want us to leave the SQL Server in the workgroup. I have researched a
> "two-way Realm Trust"but this does not seem to be a viable solution.
> I need it's passwords to synch with our Windows Server 2003 Domain
> passwords.

I don't think there is a way to do this without making it a member of the
domain. I don't think there is any way to create a trust between a domain
and a workgroup member.
But, I'm really not well versed in creating non-supported trusts.

--
Best regards,
Kevin D. Goodknecht Sr. [MVP]
Hope This Helps
===================================
When responding to posts, please "Reply to Group"
via your newsreader so that others may learn and
benefit from your issue, to respond directly to
me remove the nospam. from my email address.
===================================
http://www.lonestaramerica.com/
http://support.wftx.us/
http://message.wftx.us/
===================================
Use Outlook Express?... Get OE_Quotefix:
It will strip signature out and more
http://home.in.tum.de/~jain/software/oe-quotefix/
===================================
Keep a back up of your OE settings and folders
with OEBackup:
http://www.oehelp.com/OEBackup/Default.aspx
===================================

Thank you Kevin, This appears to be the consensus in all sources I have tried.
My Best!
Brian
--
brian


"Brian Buchholz" wrote:

> I have a Microsoft Windows Server 2000 (5.00.2195) Service Pack 4 with 1.5
> Gigabyte RAM in a workgroup called: “Workgroup”. It runs a SQL Server package
> with allows reports from our UNIX server to be run. The authors of the
> package say the SQL Server cannot be moved into our Domain. They also do not
> want us to create a domain and they want us to leave the SQL Server in the
> workgroup. I have researched a “two-way Realm Trust”but this does not seem to
> be a viable solution. I need it’s passwords to synch with our Windows Server
> 2003 Domain passwords.
> Any ideas?
> Thanks!
>
> --
> brian

"Brian Buchholz" <(E-Mail Removed)> wrote in message
news:33BCDBCE-7D9E-4241-869A-(E-Mail Removed)...
> Thank you Kevin, This appears to be the consensus in all sources I have
> tried.
> My Best!
> Brian

Even if you could create a "two way realm trust" that would
be essentially the same as adding it to the domain. (It's all
just forms of trust.)

Simple idea: (And maybe irrelevant since I missed the start of thread)

Can't the SQL Server be given an account in your domain and authenticate
explicitly?

If not, then trusts of some form are you only option and they are
being overly restrictive since they do wish access to shared
resources which required EITHER domain authentication OR
trusted domain authentication.


--
Herb Martin, MCSE, MVP
Accelerated MCSE
http://www.LearnQuick.Com
[phone number on web site]

> --
> brian
>
>
> "Brian Buchholz" wrote:
>
>> I have a Microsoft Windows Server 2000 (5.00.2195) Service Pack 4 with
>> 1.5
>> Gigabyte RAM in a workgroup called: "Workgroup". It runs a SQL Server
>> package
>> with allows reports from our UNIX server to be run. The authors of the
>> package say the SQL Server cannot be moved into our Domain. They also do
>> not
>> want us to create a domain and they want us to leave the SQL Server in
>> the
>> workgroup. I have researched a "two-way Realm Trust"but this does not
>> seem to
>> be a viable solution. I need it's passwords to synch with our Windows
>> Server
>> 2003 Domain passwords.
>> Any ideas?
>> Thanks!
>>
>> --
>> brian