You may sometimes receive an error which says "Cannot set a credential for principal 'sa'" while you are trying to alter the login 'sa' in SQL Server 2005 or SQL Server 2008.

Fix for this error is very simple. Just make sure that the option "Map to Credential" is checked in the "General" tab of the Login Properties Page.

Reference: http://support.microsoft.com/kb/956177

This happens because, the SQL Server tries to drop any credential that is mapped to your login credentials while altering and because your credential cannot be set to "sa" login, you will receive this error.
FIX:Fix for this error is very simple. Just make sure that the option "Map to Credential" is checked in the "General" tab of the Login Properties Page.
Reference: http://support.microsoft.com/kb/956177
2 comments:
Thanks Sandesh
Mua vé máy bay tại Aivivu, tham khảo
vé máy bay đi Mỹ giá rẻ
đặt vé máy bay giá rẻ từ mỹ về việt nam
vé máy bay nhật việt
vé máy bay khứ hồi từ đức về việt nam
giá vé máy bay từ Toronto đến việt nam
vé máy bay hàn quốc hà nội
khách sạn cách ly ở cam ranh
chi phí vé máy bay cho chuyên gia nước ngoài
Post a Comment