1 Reply by Graham Hawker

  • Graham Hawker
  • Veteran
  • Offline
  • Registered: 31-05-2006
  • Posts: 160

Re: NBN Exchange Addin Problem

We've had this reinstalled as we couldn't get things working.

We now get this message:

An internal exception occured in the nbn_exchange_addin in
Stored procedure nbn_exchange_create tables

The exception message is:
The Execute permission was denied on the object 'nbn_exchange_create_table', database 'NBNData', schema 'dbo'

This looks like a permission thing but the problem happens for us and also an ICT person with more significant permissions.

Graham Hawker
Thames Valley Environmental Records Centre

2 Reply by RobLarge

  • RobLarge
  • RobLarge
  • Veteran
  • Offline
  • From: Wiltshire
  • Registered: 15-07-2008
  • Posts: 812

Re: NBN Exchange Addin Problem

We had similar problems a few times especially with new stored procedures. Fixed by running the following command (in Management Studio)

GRANT EXECUTE ON nbn_exchange_create_tables TO PUBLIC

Basically you are granting execute permission to the stored procedure, for anyone not a specific user.

Hope that helps

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

RobLarge's Website

3 Reply by Graham Hawker

  • Graham Hawker
  • Veteran
  • Offline
  • Registered: 31-05-2006
  • Posts: 160

Re: NBN Exchange Addin Problem

Thanks Rob

Will give it a go.

Graham Hawker
Thames Valley Environmental Records Centre

4 Reply by Graham Hawker

  • Graham Hawker
  • Veteran
  • Offline
  • Registered: 31-05-2006
  • Posts: 160

Re: NBN Exchange Addin Problem

Just to report that we had to do a similar thing with all the permissions set by the exchange add in (as found in the sql query that comes with it) and that has solved the problem.

Thanks Rob for pointing us in the right direction.

Graham Hawker
Thames Valley Environmental Records Centre