SQL Server 2005 mixed mode authentication -
just wondering possible use mixed mode on sql server 2005 user sa? know how in management studio isn't enough user "sa". think needs done else where.
i trying connect database via console app keep getting error "the account disabled"
cheers
louis
yes
http://msdn.microsoft.com/en-us/library/ms144284(v=sql.90).aspx
how to: http://msdn.microsoft.com/en-us/library/ms188670(v=sql.90).aspx
if didn't enable mixed mode authentication during setup need in server properties > security (you can use management studio - see above link). need enable sa login , set appropriate password.
be sure restart sql service after changing authentication mode changes take effect.
Comments
Post a Comment