Re: Server needs password to synch

"Brian Buchholz" <BrianBuchholz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33BCDBCE-7D9E-4241-869A-7DA78B69BA32@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Windows Authentication from a workgroup to a domain sql server
    ... The "trust" is in your domain. ... If you search TechNet for "domain workgroup trust" you will find several ... SQL Part of abc domain ... When the user tries to connect the SQL server comes back with: ...
    (microsoft.public.sqlserver.security)
  • Re: What is the best way to administering two separate forests?
    ... If you are going to have a number of users require access to the other forest, ... Setting up the trust will require that the domains have dns name resolution between ... network browsing, then configure the wins servers to be replication partners with the ... > development and SQL Server management for them. ...
    (microsoft.public.win2000.networking)
  • Re: What is the best way to administering two separate forests?
    ... Now that you mentioned a trust relationship, it actually makes sense to do ... development and SQL Server management for them. ... network and network resources i.e. Exchange, SQL Server, applications, etc. ... We will just have a separate logical network with a separate ...
    (microsoft.public.win2000.networking)
  • Re: What is the best way to administering two separate forests?
    ... > Setting up the trust will require that the domains have dns name ... >> our SQL Server guy should be able to access our client's SQL Server ... >> keep our network separate AND protected but in the mean time, ...
    (microsoft.public.win2000.networking)
  • Re: Server needs password to synch
    ... with 1.5 Gigabyte RAM in a workgroup called: ... SQL Server package with allows reports from our UNIX server to be ... I'm really not well versed in creating non-supported trusts. ...
    (microsoft.public.win2000.dns)