Forum Discussion

joshlabtech's avatar
joshlabtech
Copper Contributor
Aug 08, 2023

Error was unexpected: Invalid Object name..

Hi Community,
 
I have this error when I tried to switch to this server. Please advise how to resolve it.
 
/The following SQL Error was unexpected: Invalid Object name: UAT Test.dbo.access control statements could not be prepared./

 

Thank you!

  • LainRobertson's avatar
    LainRobertson
    Silver Contributor
    Aug 08, 2023

    joshlabtech 

     

    In addition to olafhelper's comment, I wonder if that object reference needs the final name enclosed in square brackets given it features a space in its name? (i.e. if that's literally what's being passed through to SQL)

     

    UAT_TEST.dbo.[Access Control]

     

    Cheers,

    Lain

    • joshlabtech's avatar
      joshlabtech
      Copper Contributor
      Aug 14, 2023
      Hi Lain,

      The problem is I didn't hardcode anything. Not sure if its related to the SQL unable to find the DB?

      Thank you
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Aug 08, 2023
    I see MS Dynamics NAV in the screenshot; couldn't it be more a app bug?

Resources