Re: Connecting to SQL across Non-Trusted Domains

From: Barry McAuslin (barry_mcauslin_at_yahoo.com.nospam)
Date: 04/23/04


Date: Sat, 24 Apr 2004 09:22:56 +1200

You can do the following.

Your SQL Server instances must be running as a LOCAL or Domain account. If
you configure a LOCAL account on the server you are trying to connect to
with the same username and password it will log in using this account.

----------

Barry McAuslin

Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.

"CPNZ" <anonymous@discussions.microsoft.com> wrote in message
news:72C261EE-AB91-45D1-BA20-EE1F805E3FD0@microsoft.com...
> The problem I am having is this :
> SQL Servers in a non -trusted Windows 2000 Domain (Test domain) do not
show as being alive in Enterprise Manager unless you map a drive to a server
in the non-trusted domain.
> Has anyone seem this problem before? Not sure whether this is related to
Active Directory.
> Also all our SQL Instances use specific port numbers.
>
> Thanks
>
> CPNZ



Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • SQL services failing on startup
    ... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
    (microsoft.public.sqlserver.server)
  • Re: Connections errors
    ... Jasper Smith (SQL Server MVP) ... accounts and not the NT domain account. ... >> been observing connection errors that we can trace back ...
    (microsoft.public.sqlserver.security)
  • Re: Account Recommendations
    ... I use a Windows domain account for both SQL Server and SQL Server Agent. ... I had to changed the job agent service to run ...
    (microsoft.public.sqlserver.setup)