SQLEXPRESS: Login failed for user 'sa'. Reason: The accoun..

Hi all,

I've installed Visual Studio 2005 professional with SQL Express Edition. A
third party app needs to use it. When installing, it's asking to login as
'sa' user.

I've enabled MIXED MODE in Registry and reset the 'sa' password with
'sp_password'.
However, if I enter the correct password, I get

SQLEXPRESS: Login failed for user 'sa'. Reason: The account is
disabled.

How can I enable this account?

Thanks,
-Oleg.

here's how i fixed the problem:
1) Open SQL Server Management Studio Express and Login
2) In Object Explorer, click Security followed by Logins
3) Right click sa user and select Properties.
4) Uncheck Enforce password policy
5) Select Status. Click the Grant and Enabled radio buttons. Click OK
6) In the Registered Servers top pane, right click on the database and choose restart

that should fix your problem.

From http://www.developmentnow.com/g/107_2005_10_0_0_627785/SQLEXPRESS-Logi...ailed-f

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/