I have a problem that is driving me insane; or close to anyway.
I have a setup with an SQL server running a Dynamic NAV 2009 (they are using classic client). I have made a model in Excel and I need to read some information directly in the SQL database and also write in a couple of new Navision tables, that I have created; so no writing to ledger tables or anything.
The problem is, if I create a SQL user, it is removed the next time I synchronize the users from Navision. So we created a domain user in Navision and this user was given the correct read and write access in SSMS afterwards. I am unable to use this domain user as a way of access the SQL database, because Excel are only able to use the current windows login; not an alternative.
As I see it, the only way is to create a SQL user that has the required access and find a way for it not to be removed every time I synchronize. Or is there another way I just do not know about?
Hope you can help and have a good weekend.