Web Hosting Gallery
Quastion about server validation test
Last post Nov 17, 2010 02:17 AM by dharmendra_tij
Nov 11, 2010 10:27 AM|dharmendra_tij|LINK
To verify if my shared
server is configured correctly to act as a deployment target for Microsoft WebMatrix, I ran Server Validator 1.3 on it. Upon this, it has provided me with a detailed report, with suggestions to install several beta products. Owing to which, I have following
Report recommends some beta product viz
ASP.NET MVC 3 Beta and Product Microsoft Web Deploy 2.0. Here I request your suggestion if it is okay to install beta product on live shared server, as suggested in the report? and
Also it has recommended two php versions viz. PHP 5.2.14 and PHP 5.3.3. My shared server has PHP 5.2.13 installed on it. Can anyone suggest if it is necessary for me to install both of the PHP versions as suggested above, in order to my
server act as deployment target for Microsoft WebMatrix?
Nov 11, 2010 10:23 PM|simtan|LINK
This is a great question.
First, it's important to note that not everything ServerValidator marks as "Check Entry" is actually required as per the Spotlight requirements. You should check the
server requirements article to confirm that the components that we actually require are installed. The ServerValidator tool checks for extra items as a courtesy to inform you of what your server has installed.
ASP.NET MVC (1.0) is required, but MVC 2 and MVC 3 are not. Microsoft Web Deploy 2.0 is required, but as you noted it is currently in a
Beta form. Given this, it might be safer to first attempt fulfilling the requirements on a sandbox machine or staging server, before rolling out to production servers.
As for PHP, only PHP 5.2.14 is required. Only one version of PHP needs to be installed, but the ServerValidator will check for 5.3.3 as well in case you have it.
Hope this helps! Feel free to contact us with any further questions.
Nov 12, 2010 10:24 AM|dharmendra_tij|LINK
Although, I installed the required components using web PI 3.0, I am getting "Remot server contacted. Cannot access database", however I am able to make connection with database using management studio. Can any one help?
Nov 12, 2010 01:57 PM|simtan|LINK
Does your database server allow connections from only a limited subset of IP addresses or subnets? This may be a firewall issue.
Nov 13, 2010 04:18 AM|dharmendra_tij|LINK
Thanks for reply, simtan
I checked firewall and database settings. It seems correct. Moreover, I am able to make connection with remote database from WebMatrix. But only while publishing my database I am receiving "Remote server contacted. Cannot access database". I am using
below connection string:
Data Source=xxx.xxx.xxx.xxx,1533;Initial Catalog=mydatabse; User Id=myuser; Password=mypassword;
Could you please assist?
Nov 13, 2010 03:30 PM|panic_at_the_disco|LINK
Nov 15, 2010 05:23 AM|dharmendra_tij|LINK
Here is detailed steps that I performed.
1). Started WebMatrix.
2). Created PhotoGallery site from template.
3). Migrated it's default PhotoGallery.sdf database to local MSSQL server 2008 R2.
4). Entered following details in publishing settings.
Protocol: Web Deploy
User name: my user name
password: my password
Site name: my sitename
Destination URL: my destination url
Connection string: Data Source=xxx.xxx.xxx.xxx,1533;Initial Catalog=mydatabse; User Id=myuser; Password=mypassword;
5). Clicked Validation Connection button
I received "Remote server contacted. Cannot access database". Error.
Q- is the database server MS SQL or MySQL?
A- MS SQL
Q- Is it on the same server as IIS?
I have also tried using different MSSQL server but still I am receiving the same error. Please help.
Nov 15, 2010 01:22 PM|Yishai G.|LINK
Nov 16, 2010 08:43 PM|simtan|LINK
More information about getting FREB logs:
Nov 17, 2010 02:17 AM|dharmendra_tij|LINK
Thank you All For your time and assistant.
While this forum was down for couple of hours I could resolve the issue successfully. I can now deploy MSSQL and MySql databases to my remote server using webmatrix.
Once again Thank you All.