Plesk 11.x / Windows :: Copy Mssql Database In Panel
Feb 5, 2014
I 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."
View 7 Replies
ADVERTISEMENT
Sep 18, 2012
I 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 Related
Apr 22, 2013
I 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
View Related
Mar 28, 2015
12.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
View 6 Replies
View Related
Jun 23, 2014
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
View 3 Replies
View Related
May 7, 2008
Any windows hosting provider with MSSQL database?
View 14 Replies
View Related
Sep 6, 2013
The upgrade has an error when manage the users database.
PRODUCT, VERSION, VERSION OF MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
OS Microsoft Windows Server 2008 R2 Service Pack 1 x64
Panel version 11.5.30 Update #13, last updated at Sept 1, 2013 03:30 PM
PROBLEM DESCRIPTION
In a costumer panel have a one database MSSQL, and assign to this DB 3 users, but the tab option "Users" don't work fot his costumer and show this error:
Error Javascript:
TypeError: template is null
this.template = template.toString(); in protototype.js 8472831 (lÃnea 807)
ACTUAL RESULT
Error Javascript:
TypeError: template is null
this.template = template.toString(); in protototype.js 8472831 (lÃnea 807)
EXPECTED RESULT
Show users in the tab users for database.
View 2 Replies
View Related
Jul 7, 2015
Just updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...
View 5 Replies
View Related
Oct 7, 2008
In previous thread we made few manual transfer of our domains.
We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature.
All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
View 4 Replies
View Related
Dec 23, 2014
After the micro update, the database copy function started to hung even just for copying database with 4 tables with less than 10 rows of recrods. Although I followed the link below to remove the hung database copy and remove the unfinished database copied. URL....However, no successful database was copied at all even after the timeout was adjusted.
View 1 Replies
View Related
Apr 28, 2014
We 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?
View 3 Replies
View Related
Oct 3, 2014
I 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 ?
View 1 Replies
View Related
May 13, 2014
I 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.
View 1 Replies
View Related
Aug 9, 2014
I 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...
View 4 Replies
View Related
Apr 3, 2014
I 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.
View 1 Replies
View Related
Oct 21, 2013
I'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.
View 2 Replies
View Related
Jan 5, 2015
After 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.
View 5 Replies
View Related
Mar 1, 2013
I am doing migration of plesk 11 from one server to another server on both server version is same but after migration I cant find any service plan which is there on old server.how can i copy / migrate service plan from one serer to another server
View 4 Replies
View Related
Jan 21, 2015
I found out a easy way to update the Database name of a WP installation through phpmyadmin panel, However I can't seem to update or refresh the Parallels WP Settings with correct information. Is this a bug?
This is how to reproduce:
From phpMyAdmin select the database you want to select, in the tabs there's one called Operations, Go to the rename section.
Update the user privileges to the new Database name and remove the old privileges (save)
Then manually update the wp-config file which contains the 'Database name' (save)
Then goto Parallels Plesk > Websites & Domains> WordPress Installations > Change Settings
Here you should notice the Change Settings for the WordPress Installation still contains the old Database name.
Is there any way of updating this?
View 12 Replies
View Related
May 5, 2009
How 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 Related
Oct 4, 2009
We 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.
View 14 Replies
View Related
Jan 5, 2007
one 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 Related
Aug 6, 2013
I recently setup Plesk 11.0.9, and I want to setup SimpleDNS into my plesk panel. I installed SimpleDNS 5.2 on the server, and I followed the instructions in this post --> [URL] ...., but when I refresh the components page in the panel, I never have the Simple DNS.I setup port 8053 in SimpleDNS' HTTP API, I accept any ip address, I remove the firewall and Plesk can not see it.
View 2 Replies
View Related
Jun 20, 2013
I'm trying to rename a domain in my panel and keep getting the following error:
Code:
Error: Execute websrvmng --rename-vhost "--old-name=domainb.com" "--new-name=domaina.com" failed with error code 1: External component has thrown an exception. In IIS7NativeProvider module Exception type: System.Runtime.InteropServices.SEHException at _CxxThrowException(Void* , _s__ThrowInfo* ) at IIS7ApplicationPools.copy(IIS7ApplicationPools* , auto_ptr<IApplicationPool>* , basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >* srcName, basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >* dstName)
Running
Code:
websrvmng --rename-vhost "--old-name=domainb.com" "--new-name=domaina.com"
In the Windows command line gives the following error:
Code:
Cannot find domain by name 'domaina.com'
Haven't found many leads on the web as to what this might be.
View 2 Replies
View Related
Mar 26, 2014
how to enable AWStats for the domains on my server. In our old Panel (v9.5), I could go Domains > DOMAIN.TLD > Web Hosting Settings, and on that page there was an option to choose between Webalizer/AWStats/None. In version 11.5, I don't see that option.
When I look on the actual Windows server, I do see an AWStats directory along with a Webalizer directory in "C:Program Files (x86)ParallelsPleskAdditional", so I think it's installed...? AWStats comes along as part of the Plesk Panel license, right?
I can see the Webalizer stats when I browse to [URL] ...., but I'd much rather see AWStats.
View 2 Replies
View Related
Jan 30, 2013
I Have a WinServer 2008R2SP1 with plesk 11. I am able to access to PControl panel with https://localhost:8443 but not from outside the server (https://serverIP:8443)
The firewall if OK, allowing port 8443.
View 4 Replies
View Related
Feb 14, 2014
I tried to open Administration page for my Parallel Plesk Panel, but all the time it's show Loading and nothing happens. It's also not opening on the server trough https://localhost:8443 System redirect me to the address https://localhost:8443/sso/api.php?api=/ui and 10 minutes it's loading...
View 4 Replies
View Related
Oct 10, 2014
We are getting an error every time that i try to add a new IP on Plesk panel. I go to "Tool and settings" than "IP address", "Add ip address" on fields i already try to ip:
xx.xx.xx.xx/32
and
xx.xx.xx.xx/submask
every time that i click on OK, the button become loading an never finish....
View 7 Replies
View Related
Feb 17, 2014
Updates ran over the weekend and I can no longer login to the Plesk Panel. I'm getting the following PHP error: Fatal error: Call to undefined function get_gpc() in D:Plesadminhtdocsindex.php on line 3Click to expand...
View 1 Replies
View Related
May 14, 2013
I have Plesk and SmarterMail running on a server.SmarterMail is setup as 'require SMTP authentication before relaying' email (I think this is standard practice).I cannot get Plesk to send any emails, such as forgotten password reminders and notifications.Plesk tries to send but gets a "550 Authentication is required for relay" error... which is expected, because I can't find anywhere in Plesk to enter the authentication details for the email account being used to send (relay) the emails.
I don't want to setup a 'whitelist' or 'bypass relay authentication' for 127.0.0.1 as I have had a spam issue with this previously.where to enter the username / password details so Plesk Panel can authenticate and send it's emails?
View 5 Replies
View Related
