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.

enable mixedmode

enable sa

be sure restart sql service after changing authentication mode changes take effect.


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -