Adding User To Brand New Company

Jonathan2708

Hi,

We have a Navision 4.00SP1 database (SQL 2000, Windows authentication) with 2 companies and everything has been working fine. We now want to add a 3rd company to the database so we did this under the Administrator user using File-->Company-->New. We then went to the first user and added them as a SUPER role to the new company - they also have an ALL role for all companies. The user then logged out of Navision and back in again but whenever they try to access anything in the new company they get the message 'You do not have permissions to the General Ledger Setup table'. When they exit Navision whilst in the new company they also get the message 'You do not have permissions to the User Setup table'. The user can still access the original 2 companies fine.

Is there some other procedure that needs to be done when adding users to a brand new company? By the way the Administrator user can access the new company fine. This may suggest a SQL permissions problem but normally when this is the case you get a SQL driver error message, not a native Navision error.

Any help appreciated,

Jonathan

Savatage

I know when I look at my license the # of companies I can have is 2 What is yours?

nunomaia

Theoretically new licenses should had unlimited companies

themave

Savatage wrote:

I know when I look at my license the # of companies I can have is 2 What is yours?

We too have company 2, but then right below is company unlimited 1


1,100 Company 2
1,140 Company - unlimited 1

I believe Microsoft changed licensing a while ago to allow unlimitied companies in the same database. oN the pricing worksheet it says it is included as part of the fondation layer

Unlimited Companies (Included in Foundation Layer)

themave

Make your superuser not be company specific, and see if he can then access the new company.

kriki

Is your superuser dbowner under SQL?
If not you need to do a Synchronize of the user.

Jonathan2708

Thanks for the replies. We have unlimited companies so that is not an issue. I was afraid we may have to resynchronise.

Jonathan