This is a migrated thread and some comments may be shown as answers.

"Database permission test failed."

5 Answers 65 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Daniel Corbett
Top achievements
Rank 1
Daniel Corbett asked on 27 Jul 2010, 05:16 PM
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

5 Answers, 1 is accepted

Sort by
0
David Harris
Telerik team
answered on 27 Jul 2010, 05:23 PM
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
0
Daniel Corbett
Top achievements
Rank 1
answered on 27 Jul 2010, 05:43 PM
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.
0
David Harris
Telerik team
answered on 27 Jul 2010, 05:47 PM
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
0
Daniel Corbett
Top achievements
Rank 1
answered on 27 Jul 2010, 06:24 PM
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
0
David Harris
Telerik team
answered on 27 Jul 2010, 08:32 PM
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
Tags
General Discussions
Asked by
Daniel Corbett
Top achievements
Rank 1
Answers by
David Harris
Telerik team
Daniel Corbett
Top achievements
Rank 1
Share this question
or