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: SQl Writer Service Hangs
    ... I've collected this informaton from Event Viewer. ... If you are prompted for an administrator password or for a confirmation, ... You don't have MS SQL Server running on the computer, if you don't know what it is or you shouldn't have it on the machine. ... The database in 99.9% of the time would be used by a software developer to develop software solutions on the computer that would use MS SQL Server as the database, which would be the reason that MS SQL Server would be installed on a computer. ...
    (microsoft.public.windows.vista.general)
  • 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)