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 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 am running plesk 11 on windows 2008 vmware esxi 5 vps,
When I try access mssql.domain i have the following error:
Line 1: <object id="ConnectionString" class="ASPEnterpriseManager.ConnectionString" runat="Server" scope="Session" />
I created a mssql database. When I click on the weasmin link I go to a 404.Also when I log in as administrator and go to Tools & Settings >>>Database Servers >>>>>click on the .MSSQLSERVER2012 then webadmin it will open myLittleAdmin for SQ Server and I can see the datases.
View 4 Replies View RelatedMicrosoft Windows Server 2012 Panel version 11.5.30 Update #47
The Webadmin app does not install all the folders it needs to run correctly. I have downloaded and repaired the install as noted in [URL] ..... This did not repair the install. All the folders that are needed in the application directory in the vhosts folder are still missing. I have attached the install log.
I tried use mylittleadmin or asp.net manager and booth tools NOT working on my windows plesk.
I tried remove and install again but still not working.
Tried run PLesk Reconfigurator and still nothing.
After click webadmin its shows a security warning conform box as following on Firefox ...
Although this page is encrypted, the information you have entered is to be sent over an unencrypted connection and could easily be read by a third party.
Are you sure you want to continue sending this information?
And if click " OK" the page display " Server not found " error
[URL] ...
After Plesk panel upgrade to 12.x webadmin stopped working . It's showing following error
Code:
Server Error in '/' Application.
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. review the following URL and make sure that it is spelled correctly.
I recently upgraded from Plesk 11.5 to 12.0. I also just got an extra IPv4-address for my server (provider is Strato), unfortunately I have some problems with adding it to Plesk.
The IP should be assigned automatically through DHCP, but when I did a Reread IP in Plesk, nothing happened. I tried to manually add the IP, but then Plesk manually configured it and I lost the IPv4-connectivity (IPv6 kept working though).
Now when I want to remove the IP, I get the following error:
Is this a bug or a problem with my specific configuration?
I installed Plesk 12 on server, and deployed several websites.
If I tried to open ASP.NET Settings on websites & domains of any domain, I've got error:
Internal error: aspnetcfg failed: Version string portion was too short or too long. (Error code 1)
Message aspnetcfg failed: Version string portion was too short or too long. (Error code 1)
File Agent.php
Line 243
Type PleskUtilException
How can I fix this?
Every day we get a couple off Parallels.Diagnostics.RRD.RrdStorageProvider errors:
Parallels.Diagnostics.RRD.RrdStorageProvider - <log4net.Error>Exception during StringFormat: Input string was not in a correct format. <format>Update to database {0} has failed [{2:HH:mm:ss:ffff}]. {1}</format><args>{cpu-1.rrd, Parallels.Diagnostics.RRD.RrdException: Failed to update RRD database "C:Program Files (x86)ParallelsPleskvarhealthdatalocalhostcpu-1.rrd":ERROR: could not lock RRD
, 00:00:09.6084608}</args></log4net.Error>
Source: ParallelsHealthMonitor
We are running a Windows 2008 R2 Enterprise server with the latest Plesk 11.5.30 update 16.
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 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 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 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 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.
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
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 install wordPress and cant login to admin with this Address:
mydomain.com/wordpress_9/wp-login.php?redirect_to=http%3A%2F%2Fmydomain.com%2Fwordpress_9%2Fwp-admin%2F&reauth=1
And can't load
Show this error: The connection was reset
if i try this address can login > mydomain.com/wordpress_9/wp-login.php
I installed Plesk 12 on the Windows server 2012...
I just configured the plesk server to only allow ftps connections.
When I try to access with a ftp account on the server itself it works well, however when I try to access it from a client PC it get these errors :
(...)
Response: 200 Type set to I.
Command: PASV
Response: 227 Entering Passive Mode (XXX,XXX,XX,XX,XXX,XX).
Command: LIST
Response: 150 Opening BINARY mode data connection.
Error: The data connection could not be established: ECONNREFUSED - Connection refused by server
On the client PC I configured Filezilla in Passive mode with "Require explicit FTP over TLS".
Normally for the firewall only the port 21 is needed or am I wrong (with explicit FTP and passif configured)?
I'm trying to create a network connection from Windows (8.1) to my Plesk filesharing folder, which should be straight forward. For some strange reason my Windows desktop PC doesn't establish the connection but shows me an error message, saying that the provided folder is invalid (see attached images).
View 1 Replies View RelatedWINDOWS SERVER Plesk Panel version 12.0.18
Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
I cant connect to the Database WebAdmin. If I click the icon, i got an "File not found." in the opening tab. Back in Plesk I get the following:
ERROR: PlexkFatalException
Server id is undefined?
I even cant connect via ssh to the mysql part of my server. But the server is running and both of my two wordpress pages run smoothly. I know this page: [URL] .... – but as I sad, cant enter die mysql.
It seems something is wrong with the permissions. I'm on the point where I just want to reset everything database related. But how?
I'm looking for a Windows VPS provider that offers .NET2 and MSSQL?
View 0 Replies View RelatedI'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?
Any windows hosting provider with MSSQL database?
View 14 Replies View RelatedI'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).