گذاشتن دیتابیس روی حالت mixed mod

[nimyasoft]

سلام دوستان چجوری باید دیتابیسمو بذارم روی mixed mod ??????????

[Mehran18]

سلام
سرور ویندوز هست ؟

[nimyasoft]

بله ویندوز 2008هستش

[Mehran18]

[*=left]Open regedit
[*=left]Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQLServer
or
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLServer\MSSQLServer
http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/SQL-LoginMode1-1024x592.png (http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/SQL-LoginMode1.png)
[*=left]Change LoginMode from 1 to 2
[*=left]Restart the SQL Express service
[*=left]Open SQL Management Studio
[*=left]Login using Windows Authentication
[*=left]Go to the Security, Logins users and select properties on sa user (which is disabled by default when Windows Authentication mode was selected on install)
http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/sa-properties.png (http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/sa-properties.png)
[*=left]Enable the sa user, and set a new password
http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/sa-properties-enable.png (http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/sa-properties-enable.png)
http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/sa-properties-password.png (http://www.dekho.com.au/wordpress/wp-content/uploads/2011/06/sa-properties-password.png)
[*=left]Click OK to save sa user details
[*=left]Close SQL Management Studio
[*=left]Open SQL Management Studio, login to SQL Express using SQL Authentication with sa user, and password you set.