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

Database Connection Issues [Answered]RSS

4 replies

Last post Apr 16, 2011 01:48 PM by yeditepebilgisayar

  • Database Connection Issues

    Dec 23, 2010 07:16 PM|simtan|LINK

    If you're having difficulties getting WebMatrix to connect to your databases, please check the following:


    For MySQL databases:

    Since MySQL is installed on the database server, which is different than the web server which runs the Web Deploy web server component, you’ll need to take a few extra steps to make sure Web Deploy can access the database server:

    1. Copy mysqldump.exe from an existing installation (e.g. from C:\Program Files\MySQL\MySQL Server 5.1\bin) to your web server in c:\mysqldump\mysqldump.exe
    2. On the web server, set a registry key (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\2\mysqldumppath) to string value == “c:\mysqldump\mysqldump.exe”)
      1. If your server is 64-bit, also create the same key under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\IIS Extensions\MSDeploy\2


    For SQL Server databases:

    • Have you installed “SQL Server Management Objects (SMO) 10.5” on the computer hosting SQL Server? Did you install the correct version for your architecture (x86/x64)?
    • In your Web Deploy delegation rule for provider dbFullSql, did you make the Path "Initial Catalog={userName}_db"? However, note this:
    • We recommend that you set Path Type to "Connection String" and Path to "Initial Catalog={userName}_db". For a user connecting with Windows account some_user, wmsvc will only allow connections to the database for connection strings that contain "Initial Catalog = some_user_db". For environments that allow users to name their own databases, this may not be feasible. In that case, you can set Path to "Server=", which will allow all connectios to proceed to the database layer. This is less secure since wmsvc will let all requests proceed to the database server, which is then solely responsible for security.
    • Are your users 'db_owner' on the SQL databases you create for them?


    In general:

    Are all the Web Deploy delegation rules set up correctly?

     

    Hope this helps!

     

    Simon Tan
    Program Manager
    Web Platform and Tools
  • Re: Database Connection Issues

    Dec 23, 2010 09:38 PM|HCamper|LINK

    simtan

    If you're having difficulties getting WebMatrix to connect to your databases, please check the following:


    For MySQL databases:

    Since MySQL is installed on the database server, which is different than the web server which runs the Web Deploy web server component, you’ll need to take a few extra steps to make sure Web Deploy can access the database server:

    1. Copy mysqldump.exe from an existing installation (e.g. from C:\Program Files\MySQL\MySQL Server 5.1\bin) to your web server in c:\mysqldump\mysqldump.exe
    2. On the web server, set a registry key (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\1\mysqldumppath) to string value == “c:\mysqldump\mysqldump.exe”)


    For SQL Server databases:

    Have you installed “SQL Server Management Objects (SMO) 10.5” ? Did you install the correct version for your architecture (x86/x64)?


    In general:

    Are all the Web Deploy delegation rules set up correctly?

    Hope this helps!

    I love the new Gallery Features.

    I do have a suggestion.

    It might be good to have a place in the Forum under Gallery Forum that lists where the Repositorys are located for

    Gallery installers.

     I noticed a problem when MySQL Server changed version the Repository location was changed.

     Web PI had the old link and of course returned a 404 error ( can not find file).

    Until the Web PI is updated the common Repository listing & location would serve as a way to resolve this problem.

    Its Just one way to save confusing users,

    Martin :)

    Windows and Linux work Together IT-Pros
    Community Member Award 2011
  • Re: Database Connection Issues

    Dec 24, 2010 12:28 AM|simtan|LINK

    Hello,

    Thank you for the feedback!

    Unfortunately, there is no single repository of installers, as WebPI pulls the installation packages from all over the web. You can, however, peek at where WebPI is getting its information via these XML feeds:

    https://go.microsoft.com/?linkid=9746552 <-- currently listing Beta 3 products

    https://www.microsoft.com/web/webpi/3.0/webproductlist.xml

     

    If you can parse these feeds, you can see where the installers come from.

     

    Simon Tan
    Program Manager
    Web Platform and Tools
  • Re: Database Connection Issues

    Dec 24, 2010 12:32 AM|HCamper|LINK

    simtan

    Hello,

    Thank you for the feedback!

    Unfortunately, there is no single repository of installers, as WebPI pulls the installation packages from all over the web. You can, however, peek at where WebPI is getting its information via these XML feeds:

    https://go.microsoft.com/?linkid=9746552 <-- currently listing Beta 3 products

    https://www.microsoft.com/web/webpi/3.0/webproductlist.xml

    If you can parse these feeds, you can see where the installers come from.

    Good information maybe you could post a Permalink to the feed and post to Forum.

    Martin :)

    Windows and Linux work Together IT-Pros
    Community Member Award 2011
  • Re: Database Connection Issues

    Apr 16, 2011 01:48 PM|yeditepebilgisayar|LINK

     was too descriptive :))