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 already have MSSQL 2005 on my server, one my the client requested us to install MSSQL express and they want to use the FOC version.
Can I run MSSQL server + MSSQL server express concurrently? Anybody can give me guidelines how to install it?
Do I need to uninstall MSSQL or it would be as easy as installing MSSQL express on top of MSSQL server.
I have MSSQL 2005 running on the W2k server, can i install SQL Server Express on top of it w/o causing any disruption to other services including MSSQL.
View 2 Replies View Related12.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
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.
I`ve just got a new Windows 2003 Web Edition box and now I`m going to install a database server on that.
MSSQL 2005 license would costs 270$/mo for me, So thats not possible to use it because of its price.
I`m not sure if MSSQL Express 2005 or MSDE (which are free) can handle all requirements of ASP.NET programmers or not.
Is there any limitations for major scripts on those? or will those make any doubts for programmers?
Please share your experiences and suggestions.
* I`m going to install "Hosting Controller" on that box.
I have one customer installed with plesk 11.5 + power pack integrated with mssql 2008 express on his server.But now client want to install Mssql 2008 web edition. Is this possible to replace the express edition with web in plesk panel?
View 1 Replies View RelatedI 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 RelatedI 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 RelatedI 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."
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 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 ?
When making backup, I get this error:
Warning: server "server"
Unable to backup server Site Builder content[Error in execute ''"C:Program Files (x86)ParallelsPlesksbutilsbru.php" --backup --log=stdout --target=server_settings --file="C:Program Files (x86)ParallelsPleskPrivateTemp mp34720.tmp"':
# Error: Cannot execute query to database. #
I was trying to get Active Sync running on my Windows Server 2008 R2 to be able to sync calenders, adress-books etc. with my mobile without success. With a Linux Server ot seems to be "easy" changeable like posted here: [URL]...
Need getting Active Sync running on my Windows machine? According to the steps in the mentioned post, I failed very early
1. check
2. I changed the following files: =>
"C:inetpubvhostswebmailhordeconfigconf.php"
"C:ParallelsPleskWebmailhordehordeconfigconf.php"
"C:ParallelsPleskWebmailhordehordeconfigconf.php.plesk"
with the values: =>
$conf['auth']['admins'] = array(my mail account);
$conf['activesync']['enabled'] = true;
$conf['activesync']['version'] = '14.1';
3. Rewrite:
here the "problems" start, as of course I don't have the nginx option the question is, where to place the rewrite-rules best?
4. check
5. don't know what to do here, if it even is a problem with the max connections to the imap server?
6. I can restart the mailenable service ?
7. as I have admin rights in horde now, I could do step 7!
That's it? I can't use the active sync features ...
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.
Code:
Error: Unable to reconfigure web server. websrvmng failed: Site MailEnable WebMail does not exist at IIS7WebSites::get() In IIS7NativeProvider module Exception type: System.Exception at IIS7WebSites.get(IIS7WebSites* , auto_ptr* , Int64 id, basic_string,std::allocator >* idnName)
Windows Server 2012
Plesk 11.0.9 Update #62
Note: Recently migrated from Plesk 9.2
Trying to set Default Site for a Dedicated IP Address.
I go to Subscription, then to domain > Change Hosting Settings, select dedicated IP address and OK, works fine. Site goes to Default Plesk Page.
Go to Tools & Settings, IP Addresses > Select the dedicated IP address I set above. Change Default Site to site above. Click Ok.
I get the error message above and nothing changes.
I looked on my IIS Server and MailEnable's Webmail is installed under the Default Website.
I have another Dedicated IP on this server and it has a default site on it working properly, but it was set up on the old site and it was configured as part of the Migration using Migration Manager.
I tried deleting the IP address and adding it back in. That didn't change anything. I also tried running: "%plesk_bin%websrvmng.exe" –reconfigure-webmail since that came up under someone else's issue when searching the web and that .exe is what's throwing the error.
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.
We are trying to use a configure settings for an external SMTP server within Plesk (Windows 2008 R2 Plesk 12) but are receiving the following error message:
Error: Unable to encode IDN email address 'username': email address is invalid
We are trying to use a username for SMTP authentication as we do not have the option of using an email address with our current SMTP relay provider.
Is there any way around this so that we can use a username rather than an email address?
When using a remote MSSQL server, the Webadmin link fails to load in a redirect loop.
Is there any way to change this link or disable it?
I can't add subscriptions, not even for the administrator account, comes up with:
Error: Filename: ?C:inetpubvhostsmygclive.comhttpdocsweb.config
Error: The configuration section 'system.webServer/rewrite/rules' cannot be read because it is missing a section declaration In module Exception type: System.Runtime.InteropServices.COM
[Code] .....
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
View 6 Replies View RelatedI installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies View RelatedI have enabled mail for himivest.com and can access my eMail via Opera Mail as a download.
However, I cannot access webmail. Typing "[uRL] ...." into the address bar of my browser (Chrome) results in the message "No input file specified."
I believe this is a PHP setup error. I have tried disabling / enabling PHP support for himivest (in accordance with [URL] .... ) but this had no effect.
What must I do to enable webmail?
Lately whenever i try to connect to my Plesk Panel, I get Firefox's "Unable to connect" error and with Internet Explorer I get "Cannot display web page". I disabled all addons, still couldn't connect. Checked my Firewall, still nothing. I pinged the IP and got 51ms. My site is still up. And I just dont know what's wrong.
View 2 Replies View RelatedUnable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
I had used Panel version 11.5.30. I unable to access Hosting Services / Domains !
You can see this picture show about this case !
I don't know why this Panel error ???
I've upgraded to 11, but when I try and apply updates, I'm getting
WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.
I've followed the directions in the KB mentioned, but haven't had any luck yet.
This is the most instable Plesk version. I use the new Plesk 11.5, but really this is the most suck Plesk version
Web Deploy used to work and now it is not working. I use Web Matrix and when I try to connect, this is the error message:
UNABLE TO ESTABLISH CONNECTION
I'm trying to upload backup ms sql server file. But the Control panel tells me error: "Error: copy_file failed: filemng cp failed:"
View 4 Replies View RelatedI'm receiving the following error whenever I try to edit any hosting settings
Unable to determine preferred php handler id
I've found the article for this on the Linux KB (which states to raise a support ticket) but nothing on Windows.
I am running Windows Server 2012 R2 with Plesk 12.0.18