Plesk 11.x / Windows :: Delete Inactive MSSQL Remote Server
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.
My Parallels Plesk Panle 11.0.9 (Windows 2008 r2) would not allow me to remove an old IP address. I've tried using PP Reconfigurator but encountered a problem:
1. I open PP Reconfigurator and click "Change Server IP Addresses" 2. Under IP addresses I see 2 addresses 3. I check the one that is no longer active 4. I select "Existing Address", however NO existing addresses are displayed.
Is there a way to remove this old inactive address somehow. I should say that we have 2 domains on that server. Both domains are associated with the active IP address.
The funny thing is that when using PP Reconfigurator we see that the inactive IP is still associated with one of the two domains (this is not true). In short PP Reconfigurator displays DOMAIN 1 and DOMAIN 2 associated with the active IP; while DOMAIN 1 also associated with the inactive IP.
Problem is that we can't upgrade our panel because the upgrade application considers our server to be associated still with the old inactive IP address and can't find the necessary ports for that old IP.
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...
I have installed Plesk Panel in a Windows 2008 R2 server but i need to use an EmailEnable Sever installed on another Windows 2008 R2 Server. Is it possible to manage that?
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.
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.
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:
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?
I'm using Plesk 12.0.18 version with Windows 2012. I need to backup files to remote ftp server. Remote server configuration is Windows 2012 with IIS server. It works with ftp clients very well.
But, i have a problem about Personel FTP Repository. I open Personal FTP Repository Settings and write all boxes with true information about remote ftp server but it says "Transport error: unable to list directory: Curl error: Login denied".
Ftp server works fine with ftp clients and cpanel backups.
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.
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.
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.
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
I had a Problem with my FTP-Backup space, so PLESK couldn't do the daily backups that I configured. The problem with the ftp backup is solved. The backups are running again but there are still many large temporary files in a plesk folder.
Can I just delete them, or is this a bad idea?
The folder: C:Program Files (x86)ParallelsPleskPrivateTemp
I have noticed that i never install any program on my Server and my files of Web only 5 GB and Windows take 15 GB (My Hard Disk Usage 30 GB). Now my disk space available 1.7 GB. But when i go to check in the Recycler folder. There many files are taking up huge amounts of space, some are in excess of 10 GB . So could i deleting these files? How can I automatically delete contents of Recycler folder?
After we update to plesk 12. We are not able to access file manager inside plesk.
Its giving this error : check attachment,
Also when we tries to delete a domain we can't its giving this error message : Failed to parse response. Reason: Failed to read data from stream Process output:
It seems some permission issue. I already executed plesk configutor and permission fix tool but the issue remains.
We have the Windows version of Plesk 11.5 installed. I've removed the "Management of access to the server over Remote Desktop" but two of my sites (there's only 4 so far) still have the remote desktop button available if you log into the user account and switch to those two domains. Switching to the other two doesn't display the icon. I'm not sure if there's another place where it gets turned on/off as I've tested creating a new subscription with the "Management of access to the server over Remote Desktop" ticked and it's not giving me the desktop icon there.
to install a server for data sharing. My user want a Windows server with remote desktop to write, edit and share document.
The server will host 5 users. one admin and 4 users. each user will have there own account and folder. The user will update word files and save it directly on the server. The admin will have access to each directory (like a fileserver).
I want your recommandation for the share, the OS and the upgradability
I am having a VPS and tried to use RDC from home and it i working. But from my office I couldn't since it looks like RDC is blocked when connecting to out of LAN.
I have tried with the support to change the ports couple of times but still didn't work.
I tried: GoToMyPC, IRemotePC etc. But I believe these 3rd part software doesn’t work in Windows 2003 Server.
how to overcome RDC problem or web service or web service that can work on Windows 2003 Server for RDC?
i installed wampserver on my remote windows VPS.i opened port 80.after that i try to connect it by typing "h t t p : / / remotelink" on my local machine browser.but i can not connect.
I've been paying $160 a month for a dedicated server that runs my web application and my mssql 2008 database.
Due to the economic times, I've been searching for a cheaper alternative... This gets me thinking... Wouldn't this be a good business plan for VPS companies?
Include 4-5 databases on a extreme, high-performance MSSQL server for all windows vps.
I know there are current setups like this, but no host really emphasizes the power of their mssql server. If they show how their db server is extremely fast, customers would be less likely to try and run their own express version on the vps. Thereby decreasing ram/cpu load on the vps, and increasing the overall efficiency of the dedicated server running the vps'.
Are there any hosts that currently market like this? If not, why don't you?
