Adding remote MSSQL server is necessary for those server which host very large traffic websites, and therefore splitting services to multiple servers is necessary to make them fast. Adding remote MSSQL server in Plesk is very simple and just requires few clicks, assuming that you have a server ready with MSSQL Login to plesk click on servers click in database servers click on … [Read more...]
How to Change Windows authentication to Mixed mode in MSSQL
September 24, 2010 by 1 Comment
The easiest method is using SQL Server Management Studio Express. The supported method is to use SQL Server Management Studio Express. Download it from the web at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en 1. Then connect to your server. 2. In Object Explorer, right-click the server, and then click Properties. 3. On … [Read more...]
