Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 27.01.2015, 18:11   #1  
Blog bot is offline
Blog bot
23,355 / 790 (73) +++++++
Регистрация: 28.10.2006
Axilicious:Permission denied in database ‘TempDB’

Today, opening the Global address book form presented me this nice error: Permission denied in database ‘TempDB’. And this is not the first time this one surfaced, but most of the online solutions are not entirely correct. So let’s explain this one.

Doing an online search will show you that the reason of this is simple, the AOS has no permission in the TempDB as the error states. But why? Well, the first important thing you need to keep in mind is that the TempDB database is recreated when the SQL Server is restarted. Thus, something will need to reapply the needed permissions for the AOS after a restart. Most online solutions show you how to apply these permissions, others even schedule a T-SQL command to run periodically to do so!! But this is not how this is intended to work.

When installing an AOS, the installer will create stored procedures in the Master database to set the needed permissions on the TempDB. These procedures are called by the AOS when SQL has been restarted and appropriate permissions are missing. And this is where the problem mostly comes from. When the account running the AOS service has been altered, these stored procedures haven’t and they still have the old AOS user account. This means, when they are called to grant permissions to the TempDB, they do so for the wrong AOS account!


Altering these to contain the correct AOS user account will solve the issue in case of a SQL reboot.

Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
KB 3023315"User is not authorized to insert a record in table 'SYSDATABASELOG'. Request denied. Cannot create a record in Database log (SysDataBaseLog)" error when adding a record through Application Integration Framework (AIF) for a non-ad Vadik DAX: База знаний и проекты 0 13.01.2015 15:54
A default full-text catalog does not exist in database 'MicrosoftDynamicsAX' or user does not have permission to perform this action. lvan DAX: Администрирование 7 18.10.2013 20:38
axinthefield: Database Mirroring with Dynamics AX Blog bot DAX Blogs 1 20.01.2011 10:54
emeadaxsupport: Checking Database entries after restoring a Microsoft Dynamics 2009 SQL Database to another Domain or Environment Blog bot DAX Blogs 0 18.02.2010 23:05
Microsoft Dynamics CRM Team Blog: Auditing Report Execution using the ReportServer Database Blog bot Dynamics CRM: Blogs 0 19.11.2008 20:05
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 19:06.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.