step 1 , login as windows authenticatin mode, using 'Administrator' login.
step2, Then go to 'Object Explorer'
step 3, Find Security menu from that. Then find Login
step 4, From Login menu select 'sa' --> properties.
step 5, in left site find the status and make enable in right side. also set the password in General section.
Note:
it is possible to login failed for windows authentication mode. For this problem there is a possible low disk space in ms sql server installed drive. so make free space then restart computer then attempt to login. it will fine.
step2, Then go to 'Object Explorer'
step 3, Find Security menu from that. Then find Login
step 4, From Login menu select 'sa' --> properties.
step 5, in left site find the status and make enable in right side. also set the password in General section.
Note:
it is possible to login failed for windows authentication mode. For this problem there is a possible low disk space in ms sql server installed drive. so make free space then restart computer then attempt to login. it will fine.
No comments:
Post a Comment