Plesk 11.x / Windows :: Regional Settings And MSSQL Collation
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
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
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
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 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
Jul 31, 2014
Problem:
- I make changes to the PHP settings but they don't seem to take effect. I even had tried making the changes in the php.ini file, but some of the changes here don't take effect either. I have found similiar posts, but resolutions that work. I have restarted the IIS service after the changes, but this did not change the results I see in phpinfo();.
Examples of Changes Not Taking Effect:
- I changed "error_log" in PHP Settings. phpinfo showed no value for error_log. I changed error_log in php.ini and the change took effect for both local and global.
- memory_limit is set to 128M in php.ini. It shows as 32M for local and 128M for global with phpinfo(). No matter what I change this to (some value, "-1", default) in 'PHP Settings', the value does not change for local.
- The same problem with 'memory_limit' also occurs for post_max_size.
- PHP 5.2 and 5.4 are installed. If I change the version under the 'General' tab, it stays as 5.2.17 in phpinfo().
- I have changed the error_log setting in php.ini and 'PHP Settings', but still nothing is logged in the error_log file with safe_mode on or off (set to local directory). There is a note out there saying that with PHP 5.2, safe_mode on will not write to file.
- I have performed IIS Restarts, but this did not make any settings take effect.
- I also have tried changing PHP settings under the 'general' and "PHP Settings' tab, both under the website area and the advanced options->Website Scripting and Security. So the 'website' settings would be specific for the website and under 'Website Scripting and Security' would be for the webspace. Changing in either location does not make a difference.
Other Note
- I discovered this, because a client was getting a 501 when performing a post, which also sent an email. If he attached a file larger than 7MB to his form, the code would fail with a 501 error. After investigating, the "To" field was blank if a person attached a file larger than 7MB. Defnitely seems to be a memory issue. But since no log file, nor will my settings take effect, I have not been able to resolve this.
PLESK Version
- 11.0.9 Update #62 on Windows 2008 and IIS is the web server.
View 1 Replies
View Related
Jun 24, 2013
It looks like a change was made to the firewall settings (I think this was done by .net microsoft patch).I have manually added mysql-nt to the firewall ruleset, and this has allowed MySql to talk to the application. (Wordpress websites are now working)I still get the same error when i try to log in to the control panel.
ERROR: PleskMainDBException
MySQL server has gone away
0: common_func.php3:637
reconnect()
1: common_func.php3:600
db_connect()
2: auth.php3:134
Is there a list of firewall rules that need to be in place to allow Plesk to work?
View 6 Replies
View Related
May 3, 2013
I wanted to select I want PHP 5.4 instead of 5.3 and to disable AWStats for the domain. This is what I got :-(
Error: Unable to reconfigure Web server: websrvmng failed: Filename: Error: Cannot add duplicate collection entry of type 'add' with unique key attribute 'name' set to 'Perl-CGI-pl' In module Exception type: System.Runtime.InteropServices.COMException at Microsoft.Web.Administration.Interop.IAppHostElementCollection.AddElement(IAppHostElement pElement, Int32 cPosition) at Microsoft.Web.Administration.ConfigurationElementCollectionBase`1.Add(T element) at HandlerCollection.AddRange(List`1 ) at IIS7Handlers.enable(IIS7Handlers* , set<enum IHandlers::HandlerType,std::less<enum IHandlers::HandlerType>,std::allocator<enum IHandlers::HandlerType> >* types, Boolean disableOther)
View 3 Replies
View Related
Oct 9, 2013
Incoming mail on several devices with various operating systems gives me no trouble at all. However I can not find the right settings for outgoing mail for Thunderbird 24.0.
For incoming mail I noticed I had to submit mail.<name>.be and port 143, no authentication and non-encrypted password. And it works.
For outgoing mail server I've tried a lot of options:
mail.<name>.be, all ports tested, all authentication options, and with both encrypted or non-encrypted passwords, in every combination of these settings.
smtp.<name>.be , all ports tested, all authentication options, and with both encrypted or non-encrypted passwords, in every combination of these settings.
<name>.be, all ports tested, all authentication options, and with both encrypted or non-encrypted passwords, in every combination of these settings.
View 2 Replies
View Related
Aug 10, 2013
I tried to configure windows live mail for an email account. Domain is hosted on a windows Plesk server. Incoming mail is working but unable to send outgoing mails.
Subject 'xxxxxxxxxxxxxxx'
Server Error: 503
Server Response: 503 This mail server requires authentication when attempting to send to a non-local e-mail address. Please check your mail client settings or contact your administrator to verify that the domain or address is defined for this server.
Server: 'xxxxxxxxx.tld'
Windows Live Mail Error ID: 0x800CCC79
Protocol: SMTP
Port: 25
Secure(SSL): No
View 2 Replies
View Related
Feb 2, 2014
Current Version Installed :Parallels Plesk Panel 11.5.30 Update #31
Problem: When username have @ like : myuser@mydomain.com
Steps : When configure the setting all go right (test to validate setting is ok too) , but when Scheduled Backup Settings using Personal FTP Repository cannot connect for server because the url use 2 @ like error message below.
Error Message :
Cannot parse output file 'ftp://bk@mydomain.com@mydomain.com/' [Invalid URI: Can not parse the hostname.]
View 1 Replies
View Related
Oct 9, 2013
We have set up a site for a customer anyone goes to view the sites an a default authentication pop up appears, and the only way to view the website is to type in the customers Cpanel Login details.
I've checked the IUSR, IWPD permissions and they are correct. and check the authentication modules and level in IIS and they seems to be correct.
Is there away to set a customers permissions to the default settings?
View 1 Replies
View Related
Apr 6, 2015
i have a problem with my plesk 12 Installation on a Windows Server 2012 R2 Standard machine.
When I select a Website and want to change the php settings for that page it wont apply the new settings.
I placed a phpinfo() file in the Folder of that Website to test that. The weird thing is when i change the memory_limt value it is visible on the phpinfo() but when i change post_max_size or upload_max_filesize nothing changes.
[URL] .....
View 1 Replies
View Related
Oct 10, 2014
When I try to reset the Personal FTP Repository setting in Backup Manager, I get "Transport error: unable to list directory: Curl error: Failure when receiving data from the peer"
I've read a solution to this issue for Plesk for Linux, but not for Windows. I have my FTP server setup for FTPS (require explicit FTP over TLS) and when I put the correct information in each box, I get this error. In the meantime, the current settings (for standard FTP) are incorrect.
Obviously the most important this is to correct the Transport and Curl errors, but if I'm unable to do so, how do you clear the current setting? There doesn't seem to be a way to do it...
View 2 Replies
View Related
Dec 22, 2014
After a server migration, some critical Plesk settings were not copied across, even though the option to backup/restore panel configuration was used. e.g.
skeleton (vhosts.skel folder)
php.ini (Program Files (x86)ParallelsPleskAdditionalPleskPHP5* folder)
Default site (vhostsdefault folder)
health config (Program Files (x86)ParallelsPleskadminconfcustom-health-config.xml)
Additional Administrator accounts
Is there a way to get these things to backup and restore that I am doing wrong?
Are there other important settings/data that I have missed from that list? I am still paying to keep the old server in case I discover something else!
Using Plesk Backup & Restore for disaster recovery will lose these settings unless they take extra steps. e.g. I now have a simple batch file that copies these files to a private folder on one of the domains before the daily backup kicks in.
View 1 Replies
View Related
Jul 3, 2014
OSMicrosoft Windows Server 2008 R2 Service Pack 1
Panel version11.5.30 Update #47
We have a few hosting plans setup with different "allowances" for each.The website permissions allow basic html and PHP.In Windows Advanced: The website settings allow for html, php, asp and asp.net
When we change a Basic Hosting plan to Windows Advanced using "Change Plan", it will reassign the subscription/domain to use the new plan, but it will not add-on the extra features in Hosting Settings.
View 1 Replies
View Related
Jan 7, 2015
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?
View 2 Replies
View Related
May 20, 2007
I'm looking for a Windows VPS provider that offers .NET2 and MSSQL?
View 0 Replies
View Related
Mar 9, 2009
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?
View 0 Replies
View Related
May 7, 2008
Any windows hosting provider with MSSQL database?
View 14 Replies
View Related
Jun 4, 2008
I've got MSSQL 2005 Enterprise running on Windows 2003 Standard R2 x64. The server has 12GB RAM.
Now, I've been trying to find some way to monitor how much RAM MSSQL takes up, but found two conflicting things.
One source says that MSSQL 2005 Enterprise can only use up to 4GB RAM on Windows Standard R2 x64. Another says Microsoft changed this to 32GB for Windows Standard R2 x64 only (i.e. not x86).
Could anyone confirm either of these? I'd find out myself if I knew how I could see how much it's using (it only shows 90mb in taskmanager).
View 4 Replies
View Related
Aug 4, 2008
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.
View 5 Replies
View Related
Sep 15, 2007
For some reason i cant read anything written in Russian language in my database thru Phpmyadmin.
I guess it has something to do with connection/database collation char sets but which one exactly ?
My current Phpmyadmin char sets are
character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/local/mysql-5.0.x-freebsd6.x-i386/share/mysql/charsets/
collation connection utf8_unicode_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci
View 3 Replies
View Related
Jun 20, 2007
I have problem with my mysql server. If i install a web application ( IPB, VBB ... ) set mysql collation in utf8_general_ci so have problem with font of my board.
Now is the question : how can i set the mysql collation from utf8_general_ci to latin1_swedish_ci ? So, after, if i start to install a web application, was the collation in latin1_swedish_ci by default.
Dedicated Server, full root access
Mysql 4.1.13
Suse 10
View 3 Replies
View Related
Nov 12, 2013
want enable mssql_connect on php
plesk panel 11.0.9
centos
I want enable mssql_connect for php.
View 2 Replies
View Related
