Explore information related to cloudlinux with mysql

Configure and Use Microsoft SQL Server Management Studio

This article will guide you on how to setup SQL server management studio. SQL Server Management Studio is a free #Windows #application to configure, manage, and administer Microsoft SQL Server (#MSSQL). 

SSMS is available only as a 32-bit application for Windows.

To get SQL Server Management Studio:

1. Go To Start Menu>Programs>Microsoft SQL Server Tools 18> Microsoft #SSMS 18. 

2. Below 'Connect to Server' screen will appear. 

3. Server Name defaults to the name selected while installing MS SQL server. 

4. Server type: This is an option to select one out of four available MS SQL services option.

To Enable remote connections to your SQL Server:

i. Open #SQL Server Management Studio.

ii. Right-click your server's name and select Properties.

iii. Tick the checkbox Allow remote connections to this server.

iv. Select OK.

Read More



Using Ansible to copy MySQL databases

This article will guide us on how to perform database migration using Ansible as the controller which can help to copy a MySQL database from one remote server to another.

Read More



SQL error Msg 3266

This article will help you to solve SQL error Msg 3266 which occurs when database backups job fails when the filemark in the backup device cannot be read. 

Read More



Recovering a database from suspect mode in SQL

This article will guide you through the process of repairing  a database which is in Suspect mode in SQL by performing consistency check on database in emergency mode and executing ALLOW DATA LOSS in single user mode.

Read More



Doing page level restore in SQL server

Best way to perform page level restore in SQL server.

Read More



Solution to error sql72045

How to fix error sql72045 as soon as possible.

Read More



Solve SQL Error 15421

We have dealt with numerous cases of SQL issues for our customers as part of our Server Support Services.

Read More