- How to Change SQL Server Authentication Mode
It is allowed to change from Windows authentication mode to SQL Server and Windows authentication mode no matter you can login SQL Server or not.
- How to Enable SA Account in SQL Server
How to enable SA account in SQL Server 2005/2008/2012/2014 for logon just after Microsoft SQL Server installation, while only Windows Authentication is available?
- How to Empty and Delete SQL Server Log File
Whether SQL Server log file has occupied a lot of space on server? This passage will tell you how to shrink even delete log file to save or free space.
- How to Start/Stop/Pause/Restart SQL Server Service
This passage introduces how to operate on SQL Server Service for running SQL Server database or running tool to reset SQL password.
- 4 Ways to Enable Mixed Mode Authentication for SQL Server
This article introduces four ways for SQL Server users to enable Mixed Mode Authentication from installation to use.
- Why Cannot Login into SQL Server with Windows Authentication Mode
Have you encountered SQL Server failed logon using Windows Authentication mode?
- How to Set SQL Server Access with Single User Mode
This passage introduces how to access SQL Server in Single User Mode, when cannot access SQL Server using Windows Authentication Mode.
- How to Configure Remote Access Available in SQL Server
SSMS and Transaction-SQL are 2 effective ways if you need to configure remote access for SQL Server 2005/2008(R2)/2012/2014/2016.
- What's the Difference between SQL Server Login and Database User
SQL Server login is related to Database user. But actually they are different from each other.
- Fix Error 29506 When Installing SQL Server Management Studio Express on Windows 7
If error 29506 occurs when prepare to complete installing SSMS Express installation on Windows 7, you can fix it by command prompt run as administrator.
- Configure Windows Firewall to Allow SQL Server Access
In order to run SQL Server successfully when connecting to server or specified instance, it is necessary to configura Windows firewall to allow SQL Server at first.
- Solve SQL Server Connection Error 26 - Error Locating Server/Instance Specified
While SQL Server client unable to establish connection to server, or SQL network interfaces error 26 occurs, you cannot locate server or instance specified, how to resolve it?
- How to Identify Location of SQL Server Error Log File to View Error
Where are SQL Server ErrorLog file? How to verify path for SQL Server ErrorLog file in order to view and analyze errors recorded in it?
- How to Change SQL Server ErrorLog File Default Location
Learn to change path to save SQL Server errors and other information occurring in the process of running SQL Server.
- How to Manage Number of SQL Server Error Logs File
If you want to increase or decrease number of SQL Server ErrorLog file, this article could help you to configure it in SQL Server Management Studio or Registry Editor.
- How to Fix Login Failed to SQL Server - Error 18456/18452/4064/4062
Login SQL Server failed and receive error 18456/18452/4064/4062 messages? Please find the reason and take the appropriate measure to fix SQL Server login failed error.
- How to Restore a Master Database in SQL Server 2012
SQL Server couldn't start because of master database unavailable.
- How to Move SQL Database Files to Another Wordpress
Learn how to move sql database files from A wordpress server to B wordpress server without file size limitation.
