error for export excel/word for end users

sophiebei

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

garak

did set the permission with "grant" on sql for role "public" ?

Use [Your_DB]
go
Grant select  on dbo.tablename to public
GO

jannestig

This should help as well

There are some bugs related to this.

http://mibuso.net/forum/viewtopic.php?f ... w=previous

sophiebei

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?

thanks~

we would try again in nav 5.0

sophiebei

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

jannestig

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

ara3n

The link to the actual document on partner source is

https://mbs.microsoft.com/knowledgebase ... KSXPYWOPUO