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

I was able to log on to computer b and execute the stored procedure. There
was no error after I corrected the permissions for the user. BUT, BUT BUT
I can access the stored procedure but I can not use membership.validateuser.
Membership.validateuser must use a different method or user id / password.
Is this using the aspnet_wp user of ASPNET? If I make the passwords the same
on all the machines will the membership.validateuser work from computer a?
Finally, thanks for your assistance. This has been very flustrating.


"Wei Lu" <weilu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:NdHWadfXGHA.3700@xxxxxxxxxxxxxxxxxxxxxxxx
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: Executing dynamic select statement in a SP
    ... EXECUTE permissions for a stored procedure default to the owner of the ... the statementwithin the EXECUTE string are checked at the time EXECUTE ... > everything works just fine but with dynamic SQLs when I ...
    (microsoft.public.sqlserver.security)
  • With in a SP Truncate dbo.table table-name permissions..
    ... If i give execute permission to this ... truncate table permissions on the table. ... If a user who creates a stored procedure does ... not qualify the name of the tables referenced in SELECT, ...
    (microsoft.public.sqlserver.security)
  • Re: SET IDENTITY_INSERT Privileges?
    ... on the stored procedure to get around this. ... stored procedure and the user has execute permissions on the ... How do I grant permission to a SET Statement?? ...
    (microsoft.public.sqlserver.security)
  • Re: app role has exec permission but still cant execute sp
    ... that the stored procedure references in it's code. ... ADO connection sometimes opens a new connection to the server if the first ... > The stored procedure which I can't execute is below, ... >>> well as some users with no permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: Exec permissions on Stored Procedure
    ... If I grant EXEC permissions on a Stored Procedure to a Domain User ... shouldn't they be able to Execute that stored procedure reguardless if they ...
    (microsoft.public.sqlserver.security)