Re: Logon failed for user ". but only for membership tables in same database that other request work

Hi Bill,

Since you use a same UserName and Password in the Computer A , it should be
OK to login SQL Server on Computer B.

I would like you to do a test that on ComputerB, log on using the Username
and then open the SQL Management Studio and try to execute the stored
procedure. Does any error occur?

You may use the GRANT statement to grant the EXECUTE permission for a user:
GRANT System Object Permissions (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms187797.aspx

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Adding users
    ... Not only does AUTHORIZE not show it, new processes did not get the right ... When I grant the id I get the GRANTMSG returned, but SHOW USERNAME does ... A second grant gives me a GRANTERR ...
    (comp.os.vms)
  • Re: Group policy software install & directory access rights
    ... Grant "Authenticated Users" read/execute access. ... > the install files if it does not have a username and password? ... > So I log into the local workstation as the local admin which is not a ... > So I'm thinking that the reason my GPO install is failing is because the ...
    (microsoft.public.windows.server.active_directory)
  • Re: editing /etc/sudoers
    ... Otherwise, to grant your ... limited root privileges to username, ... Bob Holtzman ...
    (Ubuntu)
  • RE: ERROR 1045: Access denied for user:
    ... When you select user from users what does the username say? ... mysql> GRANT ALL PRIVILEGES ON *.* TO 'mikesd'@'localhost' ... unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)