CODEWITHSUNDEEP
sqlsql-serversql-server-2012
Brezhnews
Brezhnews

Reputation: 1569

Cannot alter procedure in SQL Server

When I run to alter the procedure, I get an error:

Msg 18487, Level 14, State 1, Line 1
Login failed for user 'tester'. Reason: The password of the account has expired.

However when I check under Security -> Logins, I can't find a user with this name.

I also tried removing the expiration with the following command:

ALTER LOGIN tester 
   WITH DEFAULT_DATABASE = [master], 
        DEFAULT_LANGUAGE = [us_english], 
        CHECK_EXPIRATION = OFF

The system says that the user does not exist or I don't have permission (I'm sysadmin)

Msg 15151, Level 16, State 1, Line 1
Cannot alter the login 'tester', because it does not exist or you do not have permission.

Upvotes: 1

Views: 2384

Answers (1)

Dave C
Dave C

Reputation: 7392

Per my comment...

Please verify that the stored procedure is not utilising a linked server which may contain/use the credentials indicated.

Stored procedures validate connections/credentials on recompile.

Upvotes: 1

Related Questions