Accessing sql server from a remote machine

From: MP (NoSpam_at_TheWorld.com)
Date: 09/30/03


Date: Tue, 30 Sep 2003 16:19:33 -0400


Hi,
    We are running in a "domain" security environment. We have SQL server
configured and installed on Machine 'A' and a process that tries to access
the database from machine 'B'. The process on machine 'B' runs as a service
under the system account.

    We also have created global groups to restrict the access to our
database, I have tried to add machine 'B' to our global group in order to
give it access to our database, but we get errors on the SQL server. in the
event viewer we see 18456 : Login failed for user 'OURDOMAIN/MACHINEB$'.
   Why do I get this error? We really want to use our groups to control
access to our database.

   Can anybody help?

Best regards

MP



Relevant Pages

  • Re: Mystery Table Delete!
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > 29 tables in our live database were deleted the other day ... > We have found an entry in Application Event Viewer that ... > I understand that this is saying that the command failed, ...
    (microsoft.public.sqlserver.server)
  • Re: backup log <my database> with no_log
    ... The big question is why do you do a BACKUP LOG dbname WITH NO_LOG in the ... Tibor Karaszi, SQL Server MVP ... > database> with no_log. ... > what should i do to avoid this error in the event viewer? ...
    (microsoft.public.sqlserver.programming)
  • multiple domain access
    ... we have a global group of the ... sets up security and database access for the first SQL ... SQL creates the account, ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to view all procedures in management studio
    ... Did you try on different database/new database? ... If you run "GRANT VIEW ANY ... I manage access to our databases via global group. ... However in management studio none of the developers can see any ...
    (microsoft.public.sqlserver.clients)
  • Add Global Group to Database
    ... I am trying out several user access drafts in SQL Server 2000. ... Add this global group to SQL Server ... The Server user 'Domain\User' is not a valid User in the Database ...
    (microsoft.public.sqlserver.security)