SQL Server 2005 Mixed Mode Authentication

Question

just wondering if you can use mixed mode for SQL Server 2005 for user sa? I know how to do this in the management studio, but this is not enough for the user "sa". I think it needs to be done where else.

I try to connect to the database through the console application, but continue to receive the error message "Account disabled"

Greetings

Louis

Answer 1

Yes

http://msdn.microsoft.com/en-us/library/ms144284(v=SQL.90).aspx

How to do: http://msdn.microsoft.com/en-us/library/ms188670(v=SQL.90).aspx

, a > ( Management Studio - . ). sa .

SQL , .

Answer 2

SQL Express 2005 SQL Server Management Studio, :

( % WINDIR%\regedit.exe) HKLM\Software\Microsoft\Microsoft SQL \MSSQL.1\MSSQLServer .

LoginMode. , 1. 2. .

( → Run → services.msc) MSSQL Server (SQLEXPRESS). .

SQL Server sa. OSQL :

osql -E -S .\SQLEXPRESS
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<password>' ;
GO

, :

osql -U sa -S .\SQLEXPRESS

Answer 3

SQL Server Mixed Mode Authentication, enable sa. Security->Logins.