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

Could not create Database when configure Scheduling server

5 Answers 133 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jutichai
Top achievements
Rank 1
Jutichai asked on 25 Jul 2013, 05:31 AM
Hello,

I try to create the database for Scheduling server but I got this error:

5 Answers, 1 is accepted

Sort by
0
Herb
Top achievements
Rank 1
answered on 26 Jul 2013, 12:29 PM
Jutichai,

I ran into this problem as well.  Check your eventlog for which user is trying to create the database and give that user permissions to create DB's.

Herb
0
Jutichai
Top achievements
Rank 1
answered on 29 Jul 2013, 02:22 AM
Got this error although I assign the permission to be dbcreator and db_owner

Error
0
Velin Koychev
Telerik team
answered on 29 Jul 2013, 07:15 AM
Hello,

@Herb - Thank you for sharing with us your experience! 

@Jutichai -  The error you are receiving means that your database administrator has not given you  the sufficient permission. Speak to your DBA to give you the appropriate permission. Please refer to the attached screenshots for Server Roles and User Mapping for your user and make sure you have the same settings applied. Then give a try with configuring your Scheduling Server following the steps from this article. 

If the scheduling service on a different machine than the SQL database server, you may need to enable the dbcreator role (see attached screen shot) on the SQL server for the user under which the scheduling service runs. Please find attached a screenshot of this setting in the SQL Server Management Studio.

Looking forward to hearing from you.

Regards,
Velin Koychev
Telerik
We've released our first-ever public Test Studio BETA! Download the BETA, install it,
and send us your feedback! Expires mid-August!
0
Jutichai
Top achievements
Rank 1
answered on 29 Jul 2013, 08:01 AM
I enabled but it's still not work
0
Velin Koychev
Telerik team
answered on 31 Jul 2013, 11:54 AM
Hello Jutichai,

I am sorry to hear that you are still experiencing this issue.

Once you've verified that the role is set, you should try to reconfigure your scheduling server. If you are still having issues, please reply with a screenshot of the Server Roles for the affected user and error in the scheduling server application. In SQL Management Studio you can access the server roles by right-clicking on the affected user, choosing properties and then Server Roles. 

Looking forward to hearing from you. 

Regards,
Velin Koychev
Telerik
We've released our first-ever public Test Studio BETA! Download the BETA, install it,
and send us your feedback! Expires mid-August!
Tags
General Discussions
Asked by
Jutichai
Top achievements
Rank 1
Answers by
Herb
Top achievements
Rank 1
Jutichai
Top achievements
Rank 1
Velin Koychev
Telerik team
Share this question
or