We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

Quastion about server validation test [Answered]RSS

9 replies

Last post Nov 17, 2010 02:17 AM by dharmendra_tij

  • Quastion about server validation test

    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 queries:

    (1)  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

    (2)  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?


  • Re: Quastion about server validation test

    Nov 11, 2010 10:23 PM|simtan|LINK

    Hello,

     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.

    Simon Tan
    Program Manager
    Web Platform and Tools
  • Re: Quastion about server validation test

    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?

     


  • Re: Quastion about server validation test

    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.

    Simon Tan
    Program Manager
    Web Platform and Tools
  • Re: Quastion about server validation test

    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?

     

  • Re: Quastion about server validation test

    Nov 13, 2010 03:30 PM|panic_at_the_disco|LINK

    Can you give detailed repro steps? E.g. started WebMatrix, created a site, etc. etc. Also ... is the database server MS SQL or MySQL? Is it on the same server as IIS?
  • Re: Quastion about server validation test

    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

    Server; myserverip

    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?

     Yes,

     I have also tried using different MSSQL server but still I am receiving the same error. Please help.

     

     

     

     

  • Re: Quastion about server validation test

    Nov 15, 2010 01:22 PM|Yishai G.|LINK

    Hey, Can you provide a few more details please 1. When you used Data source = xxx.xxx.xxx.xxx,1533. I'm assuming that's an IP address and port, did you try using the format: xxx.xxx.xxx.xxx:1533 2. Do you have SMO installed on the remote server 3. Did you try publishing and failed or is it just the server validation that fails. 4. If you have direct access to the remote server can you email the freb logs to me: yigalatz AT microsoft DOT com Thanks, Yishai
  • Simon Tan
    Program Manager
    Web Platform and Tools
  • Re: Quastion about server validation test

    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.


     

    <div style="background: none repeat scroll 0% 0% rgb(168, 236, 255) ! important; font-family: Arial ! important; font-size: 12px ! important; color: rgb(0, 0, 0) ! important; line-height: normal ! important; font-weight: normal ! important; vertical-align: middle ! important; left: 739px ! important; top: 70px ! important; visibility: visible ! important; display: inline ! important; border: 1px solid black ! important; width: auto; height: auto ! important; position: absolute ! important; -moz-border-radius: 5px 5px 5px 5px ! important; text-align: left ! important; z-index: 1410065406 ! important; padding: 2px ! important; margin: 0px ! important;" id="gmBFtt"><div style="background: none repeat scroll 0% 0% rgb(168, 236, 255) ! important; font-family: Arial ! important; font-size: 12px ! important; color: rgb(0, 0, 0) ! important; line-height: normal ! important; font-weight: normal ! important; vertical-align: middle ! important; border-bottom: 1px dotted black ! important; padding-bottom: 2px ! important; padding-top: 2px ! important;">Languagesen>hi GoogleDicCE</div><div style="display: none ! important; border-bottom: 1px dotted black ! important;"><input id="bfeditField" style="background: none repeat scroll 0% 0% rgb(168, 236, 255) ! important; font-family: Arial ! important; font-size: 12px ! important; color: rgb(0, 0, 0) ! important; line-height: normal ! important; font-weight: normal ! important; vertical-align: middle ! important; border: 0pt none ! important; margin: 1px ! important;"></div><div style="background: none repeat scroll 0% 0% rgb(168, 236, 255) ! important; font-family: Arial ! important; font-size: 12px ! important; color: rgb(0, 0, 0) ! important; line-height: normal ! important; font-weight: normal ! important; vertical-align: middle ! important; width: auto;"> चालू</div></div>