SQL access across domains

From: Keith (keith_at_srcpmw.com_no_spam)
Date: 05/10/04

  • Next message: Jasper Smith: "Re: tracking table access" 
    Date: Mon, 10 May 2004 14:35:28 -0700

    We have a single master model with multiple sites,
    abc.com. One of our sites, Chicago, has a SQL server
    which communicates with a SQL box at our HQ's in Denver.
    For whatever reason, Chicago has to be put on its own
    domain in a separate forest than Denver, 123.com. All SQL
    servers use SQL authentication, not windows. I would
    rather not create trusts. If all authentication is done
    through SQL logins, would authentication be an issue with
    the new domain / forest? Basically, I want to remove the
    SQL box in Chicago, from abc.com and add it to 123.com,
    without modifying trusts. Is there a lot more to this, or
    would it be fairly straightforward?

  • Next message: Jasper Smith: "Re: tracking table access"

    Relevant Pages

    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
      (microsoft.public.sqlserver.connect)
    • It can be Done
      ... I just installed a 3 SQL Server 2005 instances on a 2 node Active/Passive cluster. ... IWiz will then offer you a choice of Group on where you can install teh Fail Over Clustered Instance of SQL. ...
      (microsoft.public.sqlserver.clustering)
    • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
      ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
      (microsoft.public.sqlserver.clustering)
    • Re: WSS 3.0 question
      ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
      (microsoft.public.windows.server.sbs)
    • Re: SQL Server 2005 Cluster Setup Quiz
      ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
      (microsoft.public.sqlserver.clustering)