HLP SQL SERVER 2012

[xxhugobossxx]

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

tyvm

[Musta²]

I can see that it's disabled,

Go to status, and enable it.

[xxhugobossxx]

this when i try to enable it =(

[Musta²]

Originally Posted by xxhugobossxx

this when i try to enable it =(

[xxhugobossxx]

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

[alshqqaa]

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

[xxhugobossxx]

wher i put this code,??

[→Striker←]

New Query then Execute

[xxhugobossxx]

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

[→Striker←]

Google it

[xxhugobossxx]

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 =(

[→Striker←]

create a new user then other than 'sa'

[xxhugobossxx]

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?????