sql server msde: 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.

hi Oleg,
[quoted text, click to view]

ALTER LOGIN sa
ENABLE;

http://msdn2.microsoft.com/en-us/library/ms189828.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply