HLP SQL SERVER 2012

07/31/2012 17:54 xxhugobossxx#1
hello plz i need hlp cuz i did search rly hard 4 the answer but nothing :(:(:(:(

my problem is i cant delete sa's password i delete but when i press ok the password comes again

pic from my prob

[Only registered and activated users can see links. Click Here To Register...] tyvm
07/31/2012 17:59 Musta²#2
I can see that it's disabled,

Go to status, and enable it.
07/31/2012 18:04 xxhugobossxx#3
this when i try to enable it =( [Only registered and activated users can see links. Click Here To Register...]
07/31/2012 18:20 Musta²#4
Quote:
Originally Posted by xxhugobossxx View Post
this when i try to enable it =( [Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
07/31/2012 18:24 xxhugobossxx#5
even when i enable it i cant delete it steel full

tyvm for the help i did enable it and i try id connect with sever it worked with out i delete the password
07/31/2012 18:43 alshqqaa#6
GO
ALTER LOGIN [sa]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO

i know u can't use this 100% lol , but try it
08/01/2012 17:45 xxhugobossxx#7
wher i put this code,??
08/01/2012 17:47 →Striker←#8
New Query then Execute
08/01/2012 17:52 xxhugobossxx#9
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'sa'.
Msg 15099, Level 16, State 1, Line 1
The MUST_CHANGE option cannot be used when CHECK_EXPIRATION is OFF.
hlp plz
08/01/2012 18:01 →Striker←#10
Google it
08/01/2012 18:17 xxhugobossxx#11
i did try evry dammmn search and nothing trying to find the answer about 3 days but nothing

i already did that 3 days a go nothing =(
08/01/2012 18:20 →Striker←#12
create a new user then other than 'sa'
08/01/2012 18:25 xxhugobossxx#13
i tryed that but it comes with a password to

what the hell is this check the police is off ??

The CHECK_EXPIRATION option cannot be used when CHECK_POLICY is OFF. (Microsoft SQL Server, Error: 15122)

any one plz?????