"Database permission test failed."

6 posts, 0 answers
  1. Daniel Corbett
    Daniel Corbett avatar
    24 posts
    Member since:
    Jun 2009

    Posted 27 Jul 2010 Link to this post

    I am trying to install the community edition on my server with SQL Server 2008.   But it fails this database permission test.

    The user DOES have permission to create and alter databases, but the Telerik installer is saying otherwise.

    Thanks in advance for your help!

       - Daniel
  2. David Harris
    Admin
    David Harris avatar
    1 posts

    Posted 27 Jul 2010 Link to this post

    Hello Daniel,

    Our installer is using the provided credentials and attempting to make calls to the database and simply returning the result from the database. Our checks are for CREATE, ALTER, and then DELETE of the created database.

    Kind regards,
    David Harris
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Daniel Corbett
    Daniel Corbett avatar
    24 posts
    Member since:
    Jun 2009

    Posted 27 Jul 2010 Link to this post

    The account I am using is the same one I am logged in as, and I can successfully CREATE, ALTER and DELETE a database...   Is there a log somewhere of what errors it's encountering?  [ I did find a problem where the default place databases were created was on a volume which is compressed, after changing the default, it works fine ].  The database permission test still fails, though.
  4. David Harris
    Admin
    David Harris avatar
    1 posts

    Posted 27 Jul 2010 Link to this post

    Hello Daniel,

    You can run the installer from command line which will log all actions to a file. Please try the following:

    msiexec /i [Installer Path] /L*v c:\teampulseLog.txt


    Regards,
    David Harris
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Daniel Corbett
    Daniel Corbett avatar
    24 posts
    Member since:
    Jun 2009

    Posted 27 Jul 2010 Link to this post

    Actually, that wasn't useful, there are no details in the log as to what caused it not to succeed..

    I had to run the SQL Server Profiler, and when I ran those commands in SQL Server Management Studio, I realized that the default place for it to create databases was changed in the configuration, but not the running copy.   Restarting SQL Server, and it worked fine.

    So this is a bit of feedback, to capture the error messages, when the test fails, and share them with the user doing the install.   The failure may not be a permissions issue at all, as it was in my case.

       - Daniel
  6. David Harris
    Admin
    David Harris avatar
    1 posts

    Posted 27 Jul 2010 Link to this post

    Hi Daniel,

    Glad to see you got past the error! Thanks for the feedback, I have logged it and we will look into improving our logging and error messages as we enhance the installer.

    Regards,
    David Harris
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top