Search results

You can clone your database in PhpMyAdmin and for that you have to create separate copy of your database. First login to phpMyAdmin. Here you will find list of databases, click on particular database to clone it. In the top bar you will find option “Operations”, click on it. You will find a...

You can follow below steps to remotely connect MySQL server. Login to your server and hit Start + R button. Now you have to go to the path C:\Program Files\MySQL\MySQL Server 5.X\bin and run below command: mysql -u root -p Now it will ask for MySQL root password, you have to enter the...

You can follow below steps to make connection to MySQL database from phpMyAdmin. If you have login details then you can open phpMyAdmin URL (http://VPS_IP_address:8080). Now enter your username and password, and click on Go button. Here you have to enter you server IP address instead of...

Error Message ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. If you are getting above error while making connection to mysql database with ASP.NET application then you can add ODBC 5.x DSN connection on Windows VPS. You can follow...

If you are getting below error while establishing connection with “Collection Max” then you can check below steps to resolve issue. Error while starting mysql: Fatal error: Can't open and lock privilege tables: Table '.\mysql\user' is marked as crashed and should be repaired. MySQL server would...

If you are trying to restart MySQL service and you are getting error 1503 then it means your service is not restarting properly. You can follow below steps to solve this issue: Go to Task Manager. Here you have to search for MySQL process which is named as mysqld.exe or mysqld-nt.exe. Now...

You can follow below steps to upload custom logo in webmail: Log in to WHM. Go to Home » cPanel » Customization Now click on Customize Brand tab. Here you can upload your desired logo with “Browse” option. NOTE: Your file type must be .svg or .png At last click on Save button.

if you are getting below error while installing MSSQL 2017 on dedicated server then you can follow below steps to resolve this issue: vs Shell installation has failed with exit code 1638 The main reason for this error is there Visual Studio 2017 already installed on your server before SQL...

If you are getting below error while accessing the SQL Server Configuration Manager then you can follow below steps to resolve this issue. Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers...

If a slow query is running on server then it will consume more resources like memory, disk, processor etc. You can find these kinds of queries and manage them easily with SQL Activity Monitor. Login into your RDP. Open your MSSQL Management Studio and click on your particular user. After that...

If you are not allowed to perform operations on online status then you have to take your database offline. You have to follow below steps to take your database offline. First login to SQL Server Management Studio. Click on “Database” and then choose particular database which you want to take...

If you have large MSSQL database then you can shrink it to free up some space on SQL server. This shrinking process will remove the unused space from database. You can follow below steps to shrink database via Microsoft SQL Management Studio Login to your SQL server. Now expand databases and...

If you want to login with multiple users n cpanel then you can use cPanel User Manager tool. With this you can create additional user in cpanel to login. Log in to your cPanel account. Click on “User Manager” option under “Preferences” section. You can create new account by clicking on “Add...

You can follow below steps to set the database size limit using SQL Management Studio. Login to your SQL Management Studio. Right click on particular database and choose “Properties” option. A new dialogue will open where you have to choose “Files” option. You have to click on three dots which...

When we try to upgrade your SQL server then sometimes it throws below error. "The report server database is not a supported compatibility level or a connection cannot be established." Sometimes the reason of this error is SQL Server name which was no longer existed in Reporting service...

To access MSSQL server data from PHP scripts you will need to enable two php extensions SQLSRV extension and PDO_SQLSRV extension. You can follow below steps to enable these extensiosn in SQL server 2008. First of all you have to check the compatible version of MSSQL drivers with your PHP, you...

AS we know Windows VPS default port number is 1533but if we want to change the default port then we have to follow below steps: Login to your Windows VPS. Navigate to Start >> All Programs >> Microsoft SQL Server 2008 R2 >> Configuration Tools >> SQL Server Configuration Manager. Now choose...

Here we are assuming that we have hoststud user and we need to change the password of hoststud user with below steps: First login to MS SQL management studio with current password. Now click on “Security >> Logins >> hoststud (user)” under “Object Explorer”. After that right click on user...

You can follow below steps: Login to SQL server database. Now right click on particular database and select “New Query” option. After that run this command: ALTER USER db_user WITH DEFAULT_SCHEMA = dbo; Here db_user is your database username.

You can easily disable PHP scripts from sending emails to, for that it is must to have root access of your server. You can check below steps: Login to WHM. Go to Server Configuration >> Tweak Settings >> Mail Here enable “Restrict outgoing SMTP to root, exim, and mailman (FKA SMTP Tweak)”...