Sql Server Error while accessing Navision table

zoltero
zoltero Member Posts: 7
edited 2006-11-13 in NAV/Navision Classic Client
Can any please help with this. :-k

When using Windows Authentication we get Sql Server Error while we accessing some tables in Nav. W1 40 SP2 with Sql Server 2005.

When log in as Database Server Authentication this error does not occur.

Get following message:
1088,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "name.dbo.table" because it does not exist or you do not have permissions.

SQL:
SET IDENTITY_INSERT "name.dbo.table" ON

Comments

  • Buba
    Buba Member Posts: 24
    In fact I've seen the same error with Nav version 4.0.2.22979 and Sql-Server 2005 both 32 and 64bit. Seems like you have to drop Windows login :bug: :evil:
  • zoltero
    zoltero Member Posts: 7
    Really happy for your answer.. :-s
    But I need to solve this problem..
    Please any :lol:
  • DenSter
    DenSter Member Posts: 8,307
    Ask your solution center for the latest update. There are some issues with security that have been resolved by new executables and dll's.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Waldo
    Waldo Member Posts: 3,412
    Try a complete backup restore.
    Try a complete security synchronisation.

    Just a guess...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kine
    kine Member Posts: 12,562
    Yes, best solution is to update your client to newest version.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • zoltero
    zoltero Member Posts: 7
    Hi have now tried to backup and restore. I am also using the last hotfix of the kernel. All this did not help. ](*,)
    - Still more searching needs.
  • Waldo
    Waldo Member Posts: 3,412
    Tried a complete security synchronisation?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kine
    kine Member Posts: 12,562
    zoltero wrote:
    Hi have now tried to backup and restore. I am also using the last hotfix of the kernel. All this did not help. ](*,)
    - Still more searching needs.

    What do you mean with the "last hotfix of the kernel"?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Buba
    Buba Member Posts: 24
    I have tried both the restore/backup and completly re-synchronizing options without any luck :( I will now try to use the release SP3 xp_ndo to check if this will help :?: [-o<
  • kine
    kine Member Posts: 12,562
    I recommend to use the SP3 clients too.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Waldo
    Waldo Member Posts: 3,412
    Definitally ... although they are not everywhere available yet. :cry:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Buba
    Buba Member Posts: 24
    Well the SP3 xp_ndo.dll did not solve this problem. :evil: Neither did a clean SP3 client :evil: So this must be a programming issue as far as I can see. I'll check with the programmer and tried to run a maximum test of the database to check if there is something there :?:
  • zoltero
    zoltero Member Posts: 7
    We have found a work around for this problem. :whistle: \:D/
    Every users have to be defined as SysAdmin in Sql 2005.
    - Dissadvantage is that users get to much rights to the database. :-$
  • kine
    kine Member Posts: 12,562
    I never had problem with SQL 2005 with the rigths. We are using the base rights as with SQL 2005 without problems (SP2 Update 1). Users are not members of the server role or haven't any extended permissions on the database. Strange.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • TonyH
    TonyH Member Posts: 223
    Have you tried playing with the Logins Schemas?
  • Buba
    Buba Member Posts: 24
    No! Tell me how... :?:

Categories