error for export excel/word for end users

sophiebeisophiebei Member Posts: 5
hi all

we created a Windows Login in Navision, and synchronize all security.

while enduser(means not super) want to export excel from NAV,the error shows as follows:

"The following SQL sever errors occurred while accessing the Default Style Sheet Table

229,"4200"[Micosoft][ODBC SQL Sever Driver][SQL Sever]THE SELECT permission was denied on the object "User Default Style Sheet",database"xx",shcema"dbo"

we tried to add tabledata enven table about 20000xx"User Default Style Sheet"in role "all",synchronize it again and could not export also.

BTW,we have met this problem befor in sql2000 and add missing table in sql ,it successed

but in sql 2005/NAV5.0 it could not be solved


  • garakgarak Member Posts: 3,263
    did set the permission with "grant" on sql for role "public" ?
    Use [Your_DB]
    Grant select  on dbo.tablename to public
    Do you make it right, it works too!
  • jannestigjannestig Member Posts: 999
    This should help as well

    There are some bugs related to this. ... w=previous
  • sophiebeisophiebei Member Posts: 5
    in fact

    i have serch some articles and have a rough answer is "bug"

    oh my god! is that means i could sovle it untilss upgade to NAV 5.1?


    we would try again in nav 5.0
  • sophiebeisophiebei Member Posts: 5
    say more about it

    we solved this problem in sql2000 by add table"user default style sheet" for user

    but why it crazy in sql2005 :(
  • jannestigjannestig Member Posts: 999
    Well since Microsoft say " undocumented incident" for the resolution, I can't really give more then a guess

    It works in 2000 because the use of Schemas wasn't introduced until 2005 in SQL, If the bug was in the schema i imagine the table works in 2000 becuase it no longer is dependant upon the schema to run
  • ara3nara3n Member Posts: 9,253
    The link to the actual document on partner source is ... KSXPYWOPUO
    Ahmed Rashed Amini
    Independent Consultant/Developer

Sign In or Register to comment.