Search results

Database user won’t have enough permission to access all the queries so here we can check how to assign permission to MSSQL database user. Login to SQL server Management studio. Now click on particular “Database” and select the table for which you need required permission. After that right...

Collation indicates that how character data will be handled. Collation is a configuration level setting. You can follow below steps to change database Collation: Login to RDP server and open SQL Management Studio. Now right click on particular Database name and then click on “Properties”. A...

You can follow below steps to provide db_owner permission to user: Login to server via RDP. Click on Run and then enter “%plesk_dir%admin\conf\”. Now your panel.ini file will be open and you have to add below lines in that file. [databaseManagement] features.roles.mssql.readWrite =...

You can follow below steps to verify MSSQL edition. Login to Windows VPS server. Open “SQL 2019 Configuration Manager” and here click on “SQL Server Services”. Now right click on “SQL Server” and click on “Properties” option. A new dialoge box will open, you have to click on “Advanced” tab...

You can follow below steps to close active MSSQL connections. Login to your server. Go to SQL server management studio. Here you will find new “query” option, where you have to add below query. NOTE: You have to execute below script on MS SQL Server 2012 and higher versions. USE [master]...

Here are the steps to make connection with MS SQL Server 2012: Navigate to Run >> Type SSMS and click on Enter. Now SQL Server Management Studio will open and you have to enter below details in it. Server type: Database Engine Server name: Your_server_IP_address, with port number...

In this article we are going to describe the details of changing recovery model on MS SQL database. You can easily change it through SQL Server Management Studio for your database. There are three recovery models are available. Simple Full Bulk-logged As you know mostly MSSQL database use full...

You can follow below steps to update Remote Query Timeout in MSSQL: Login to MSSQL server with SQL Server Management Studio On the left side in Object Explorer right click on particular server name and choose “Properties” option. A new window will open where you have to click on “connections”...

If you want to give permission of Hosting Type to all subscriptions in single service plan: Login to Plesk Navigate to Service Plans >> Service plan >> Now click on “Permissions” tab. Here you have to check the box “Hosting settings management” and click on “Update & Sync” button. If you want...

If you are not able to create Add Domain, Add Subdomain or Add Subscription in Plesk and getting blank page, also in browser console you are getting below error: TypeError: Cannot read property 'hostingSettings' of undefined at A (AddDomainForm.js:89) For single subscription you can follow...

Login to server via SSH. Open my.cnf file available at /etc/my.cnf location. #log_bin = /var/log/mysql/mariadb-bin #log_bin_index = /var/log/mysql/mariadb-bin.inde #log_slow_verbosity = query_plan After that restart MySQL systemctl restart mysql

Error: When you navigate to Domains >> example.com >> Hosting Settings >> Hosting type: there is no (Change) button available to set domain forwarding. Reason: The main reason behind this issue is additional domains are also available under the main subscription. If you have additional...

Orphaned users can be mostly created while database migration when the database user is available on server but its login doesn’t available on server. You can run below query to check the orphaned users in MSSQL. USE USER DATABASE EXEC SP_CHANGE_USERS_LOGIN ‘REPORT’ GO We can fix this issue...

We always recommend “db” folder which is created with ‘www’ or ‘wwwroot’ folder for .mdb file (MS-Access database). Here are the reasons why ‘db’ folder is used for .mdb file. 1. Read/Write Access: We place database file in ‘db’ folder because system user have read-write access of this folder...

Sometimes we got error messages in SQL server but it was in Spanish language. If you have checked the default language of database then it’s English. Solution: The only solution for this issue is we have to update the default language to English of database user configuration. So we can check...

You can follow below steps to check the active connections of MSSQL database. Login to Windows server. Open SQL Management studio. Here right click on particular database and click on execute. Now you have to run the select query to check active database connection. SELECT DB_NAME(dbid) AS...

With all the database features, there is restrict database access feature is also provided by MSSQL. Normally, there are 3 access modes are available Single User, Multiple User and Restricted User. You can easily change the User access mode in MSSQL Management Studio with below steps: Login to...

If you want to attach large file in your email then you have to increase the email attachment size in web.config file of MailEnable. You will find default attachment size is 10240KB in config file. You have to follow below steps to increase the attachment size of MailEnable: First go to...

You can follow below steps to change password of email account. Login to Windows server. Click on MailEnable to open it. Click on plus sign (+) to expand “PostOffice” and then click on “Domain”. Now click on MailBoxes and you will find all the available MailBoxes for that particular domain...

Error: MySQL: Error writing file '/rdsdbdata/tmp/MYZJySXi' (Errcode: 28 - No space left on device) Solution: If you are getting above error then it means there is no enough space in temp directory for MySQL. So first you have to check the used space of \tmp partition with below command. Df...