Re: Server needs password to synch



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
===================================


.



Relevant Pages

  • Re: Does SQL Server 2005 run on SBS 2003?
    ... SQL Server 2005 Workgroup Edition is included with SBS 2003 R2 Premium, ... Les Connor [SBS MVP] ... product that requires SQL Server 2005 Workgroup. ...
    (microsoft.public.windows.server.sbs)
  • Re: Q: Named pipes and Windows (integrated) authentication
    ... Thanks Michael. ... If you don't have a full copy of SQL Server 2K you're not ... >Domain user, but you'll replace the Domain with the Workgroup name. ...
    (microsoft.public.sqlserver.connect)
  • Re: Active Directory and SQL 2000 clustering on W2003
    ... You can't have it on a workgroup. ... you really want security, then you'll have to put it within its own forest ... Columnist, SQL Server Professional ... this will be in a highly secure environment, so i dont want any AD nor ...
    (microsoft.public.sqlserver.clustering)
  • Re: Login by IP address in Management Studio
    ... In a workgroup, integrated authenticiation works, if username and password ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user . The user is not associated with a tru
    ... You can use Windows authentication in a workgroup, ... logged in to SQL Server, and is not a matter here. ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)