WebDeployment task failed. Make sure the database connect...and that you have appropriate permission

Discussion in 'Databases' started by Sayeed Rahman, Mar 25, 2015.

  1. Sayeed Rahman

    Sayeed Rahman

    Hi:

    I am having trouble deploying my webapp. I get the following error:

    Web deployment task failed.((2015-03-25 2:25:02 PM) An error occurred when the request was processed on the remote computer.)

    Make sure the database connection string for the server is correct and that you have appropriate permission to access the database.
    (Web Deploy Provider is "dbFullSql").

    Error details:
    (2015-03-25 2:25:02 PM) An error occurred when the request was processed on the remote computer.
    Attempted to perform an unauthorized operation. dbFullSql http://go.microsoft.com/fwlink/?LinkId=178034

    This Microsoft link ( https://support.microsoft.com/en-us/kb/2023855 ) states the following cuase:

    The problem occurs because the user has not been granted permissions to perform the action for the specified provider. The server administrator has to determine the provider and user that are affected, the permissions that are necessary (for example, Read or Write), and the path that is being used.

    If such is the case, can someone please look into the permission issue so that I can deploy my site?

    Many thanks,
    Sayeed
     
    Sayeed Rahman, Mar 25, 2015
    #1
  2. Elshadriel

    Elshadriel Winhost Staff

    Hi Sayeed,

    I'm afraid we don't support database publishing through Web Deploy. You can use Web Deploy to publish your web files and then restore your database by following these instructions.

    First, create the database:

    1) Log into the Winhost Control Panel at https://cp.Winhost.com
    2) Click on the Sites tab.
    3) Click on the link of the domain of the site you want to manage.
    4) Click on the MS SQL Manager button.
    5) Click on the Add button.
    6) Select the database version in the drop down list, name the database, set the quota, and then click on the Create button.

    Next, make a backup copy of your database locally using SQL Server Management Studio and then upload the .bak file to your hosting account.

    To restore the database:

    1) Click on the Manage link next to database you just created.
    2) Click on the Restore link.
    3) Click on the Browse link.
    4) Find and highlight the .bak file that you uploaded and click on the Select buton.
    5) Click on the Restore Backup button to initiate the restore and allow it to complete.
     
    Last edited by a moderator: Oct 14, 2015
    Elshadriel, Mar 25, 2015
    #2
    Michael likes this.
  3. Sayeed Rahman

    Sayeed Rahman

    Thanks a lot Elshadriel. It works now.:)
     
    Sayeed Rahman, Mar 26, 2015
    #3
    Michael and Elshadriel like this.

Share This Page