Thursday, March 11, 2010

SQLExpress Login 'sa' failed for credential issue

http://www.techurbia.com/2009/03/cannot-set-a-credential-for-principal-sa-sql-server-20052008.html

On Security->Logins->sa property page:
Step 1:Make sure "Map to credential" is checked


Step 2:change password
step 3:in "status" tab, make sure "login" is enabled.
Step 4: Servr Property->Security, make sure "SQL Server and Windows Authentication Mode" is checked



Step 5: Stop and Start SQLExpress Service

Blog Archive