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
No comments:
Post a Comment