Thursday, May 22, 2014

cannot set a credential for pricipal 'sa'.Error Number: 15535 Severity: 16

Alter failed for Login 'sa'.
Cannot set a credential for pricipal 'sa'.
Error Number: 15535 Severity: 16 State: 1


The above error occurred when we attempted to change the sa user password using sql server management studio.



To resolve this, check the 'Map to credential' as shown in the picture and give a try.

No comments:

Post a Comment

Featured Post

Generate single index on table 

Transaction tables such as F0911, F4111 etc hold a huge amount of data probably a third of petabyte. Generating indexes on such tables (th...

Popular Posts