سلام دوستان چجوری باید دیتابیسمو بذارم روی mixed mod ??????????
نمایش نسخه قابل چاپ
سلام دوستان چجوری باید دیتابیسمو بذارم روی mixed mod ??????????
سلام
سرور ویندوز هست ؟
بله ویندوز 2008هستش
- Open regedit
- 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...1-1024x592.png- Change LoginMode from 1 to 2
- Restart the SQL Express service
- Open SQL Management Studio
- Login using Windows Authentication
- 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...properties.png- Enable the sa user, and set a new password
http://www.dekho.com.au/wordpress/wp...ies-enable.png
http://www.dekho.com.au/wordpress/wp...s-password.png- Click OK to save sa user details
- Close SQL Management Studio
- Open SQL Management Studio, login to SQL Express using SQL Authentication with sa user, and password you set.