Plesk 11.x / Windows :: Change Database From MySQL To MSSQL
Apr 22, 2013I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
View 7 Replies
ADVERTISEMENT
Plesk 11.x / Windows :: Add Existing MSSQL Database?
Sep 18, 2012I restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.
View 2 Replies View RelatedPlesk 11.x / Windows :: Copy Mssql Database In Panel
Feb 5, 2014I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."
Plesk 12.x / Windows :: MSSQL - Unable To Backup Database Operating System Error 5
Mar 28, 201512.0.18 update #39
Server 2012r2
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
Windows Hosting With MSSQL Database
May 7, 2008Any windows hosting provider with MSSQL database?
View 14 Replies View RelatedPlesk 11.x / Windows :: Import MySQL - Database Failed After Upgrade
Aug 13, 2013Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
Plesk 11.x / Windows :: Importing MySQL Backup - Unable To Restore Database
Mar 20, 2014I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
How Do I Change Mass Database Names In Mysql
Jan 18, 2007How do I change mass database names in mysql?
I have hundred of database names with "$" in the name? How do I change all instances of "$" with "_"?
Plesk 11.x / Windows :: Regional Settings And MSSQL Collation
Apr 28, 2014We received the following request from customer in order for his website to function properly:
Go to the control panel of your Windows Server change Regional Settings so that the default language iS Greek.
Also, change the collation of Microsoft SQL Server to Greek-Accent Insensitive-Case Insensitive.
Will these create any problems to the rest of the websites that are hosted on the server? And if no, how to change the collation of the Microsoft SQL Server?
Plesk 12.x / Windows :: MSSQL Webadmin Connection String
Oct 3, 2014I am using connection string that written below but it does not work in your host.
<add name="LocalSqlServer" connectionString="Data Source=mssql.mydomain.at; Initial Catalog= mydb; User ID= myuserid; Password= mypassword; MultipleActiveResultSets=True;"/>
Any connection string instance for mssql webadmin ?
Plesk 11.x / Windows :: Delete Inactive MSSQL Remote Server
May 13, 2014I have an account which used a remote MSSQL server which I have since deactivated, but before deactivating I forgot to remove the DB and Server from plesk.
So now I can't remove the remote MSSQL server from plesk as there is a DB associated with it, and I can't remove the DB because it obviously can't find the remote server! I'm now stuck in a loop!
How I can force remove the DB/User from plesk and then the remote server ? I'm now receiving errors whilst backing up the account, so needs to be done.
Plesk 12.x / Windows :: Unable To Add MSSQL 2014 Express Server
Aug 9, 2014I have Plesk 12 on Windows Server 2012 and SQL 2014 Express, and I am unable to add the SQL server to Plesk. It looks like it is waiting for a long time for something, then I get this error:
Get database server version failed: mssqlmng failed: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (Error code 1)Click to expand...
Plesk 11.x / Windows :: MSSQL Quota Not Updating - Statistics Showing 0
Apr 3, 2014I am using Plesk 11.5.30 Update #39. The statistics in not updating the mssql database size. It is always showing 0. I am attaching the screen shot. This account has 2 mssql 2008 database and uses 70MB. In plesk it is showing as 0 MB.
We are not able to block the account for mssql over usages.
Plesk 11.x / Windows :: External MSSQL Servers Connected To Multiple Installations
Oct 21, 2013I'm looking for information about having EXTERNAL ms-sql 2008/2012 servers with MS-SQL Web Edition license connected to one or more Plesk servers.
We don't want to use the Express version coming with Plesk but use MS-SQL 2008 & 2012 (both accessible by clients if possible), on individual dedicated machines for SQL only.Of course we'd like to have all current functionality coming with Plesk Power Panel inc. backup/restore options from within Plesk.
Plesk 12.x / Windows :: MSSQL 2012 User Is Created Without DB Owner Role
Jan 5, 2015After upgrading to Plesk Panel 12, when db user is created on MsSQL 2012 server, db user seems to be missing db_owner role which is causing a lot of hassle at the moment.
I was not able to locate any settings for such except for following option.
"Enable the db_backupoperator role membership for all Microsoft SQL Server database users"
Please note, this only applies to new db user created as Plesk 11.5 didn't have such problem and only seems to be related to SQL 2012 not 2008.
Restoring MSSQL Database
May 5, 2009How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
View 12 Replies View RelatedMSSQL Database Intensive Hosting
Oct 4, 2009We were on shared hosting until we were asked to move off due to our database using a lot of the CPU - how much, we dont know.
Anyway, moved to a 1GB Hyper-V VPS, seems like we have one core of an E5420 but presume the server is shared between 12 people.
When our ASP application runs, the MSSQL server reaches 100% CPU and the website performs slower than the shared server we were on.
Where can we go from here? Seems like going from shared to a Dual/Quad Core Dedicated Server is a large jump and a massive jump in price.
What about a host with a high performance dedicated server for MSSQL shared between customers.
MSSQL Database's Backed Up And Then Moved To A New Server
Jan 5, 2007one of my servers currently died (it was a 1u System) Dual Xeon, 3GB RAM. I need the DATA off my SCSI harddrives.. i have a 2U system only, but when i try and put the SCSI harddrive into the Machine, windows crashes on the "Windows 2003 " starting screen. Windows, ugh, horrible. I need to get into windows to get my MSSQL database's backed up and then moved to a new server.
View 11 Replies View RelatedPlesk 12.x / Linux :: Can't Change MySQL User Password
Mar 31, 2015I try to change a mysql user password, but I get an error message:
Fehler: attribute name is invalid: status
Search for related Knowledge Base articles
I'm running12.0.18 Update Nr. 39
Convert A MSSQL To A MySQL Db
Jul 22, 2007I am currently using phpdotnuke for a site, and have a forum linked to it supplied by activemodules.com. I would like to move to a non-cms site and something like vbulletin, so want to convert the forum db from MSSQL to MySQL - and hopefully keep all the posts and login data!
As a complete novice to that process, is there any pointers out there in terms of reading material, non-command line software etc I can use? Has anyone done this conversion, and what are the dangers?
Plesk 12.x / Windows :: How To Change Subscription
Mar 7, 2015I want to change subscription from vmtraininginstitute.com to vmtechnosys.com. How can i do?
View 1 Replies View RelatedPlesk 11.x / Windows :: How To Change Available Value To Be Switched On
Jul 4, 2012I have a working PHP on the server, it is enabled and the sites are working. However they are not synced with the plan. If I try to sync it it shows:
PropertySubscription valuePlan valueAvailable valueAffected sites PHP supportswitched off switched onswitched off mydomain.com
Now how do I change the available value to be switched on?
Plesk 11.x / Windows :: Change PHP Value For Domain
Jan 8, 2014Today I received this Error Message when i try to change php value for a Domain.
Error: ProtDirUser_IIS::update() failed: Update Protected Directory #427 user failed: no such table: ProtectedUrls (Error code 1)
Plesk 11.x / Windows :: How To Change Subdomain To Sub Directory
Feb 25, 2015I use plesk 11, I was creat sub directory: domain.com/test. but I access via test.domain.com is ok, but domain.com/test is error " page not found" how to I access via domain.com/test ?
View 2 Replies View RelatedPlesk 12.x / Windows :: Change PHP 5.4 Version To All Subscriptions?
Jan 6, 2015I need to change to all subscriptions to php 5.4 version. How can I do at the same time to all subscriptions? I tray to change in the service plans but it's dont' run. We have more than 270 subscriptions, How do you change all the time?
View 8 Replies View RelatedWebhosting With Php, Java, Dotnet, Mssql, Mysql
May 6, 2008is there any hosting company/service available in this world that it allows to host websites developed in
php, java, dotnet, mssql, mysql
all in one account ?
if so please let me know that hosting provider details. (or) if anyone already using any hosting service and hosted your websites with the above said langauges.
Plesk 11.x / Windows :: How To Change Folder Location Of WordPress
Jan 2, 2015Microsoft Windows Server 2012 11.5.30 Update #49
I have several users using WordPress that has been installed using the Plesk panel. They want to change the directory that WordPress is installed to. I know if that is done that WordPress will no longer be able to be managed or updated using the Panel. Is there any way to change the folder structure so that this application can still be managed by Plesk?
Plesk 12.x / Windows :: Change Customer Name CNAME Through Batch
Nov 2, 2014I am trying to change the cname through a batch.. It is successfully done for English language but I want to use Arabic language. When I am using Arabic it appear like this "????".
View 1 Replies View RelatedPlesk 11.x / Windows :: PMM - Change Default Backup Location
Aug 15, 2013Plesk 11.5 (Windows Server 2008 R2)
I changed the dump location, but how do I change the default backup location on the destination server from:
C:Program Files (x86)ParallelsPleskPMM mp
To:
D: emp
Also, how do I change it on the source server as well? I have tons of space on the D drive, but only 200GB on the C drive.