User Access Setup

[esanchezInDC]

Hello there,

We updated our GP to version 8.00g73 but after doing so I noticed that I'm having problems in creating users accounts. I can create a user account OK but when I try to set their User Access and select what companies they can see/get into I get an "Error message 1919 doesn't exist". I checked SQL Enterprise and the account is there. The user can login into GP but can't select any company as the screen comes up blank. Any others having a similar issue? What steps do I need to take to correct and fix this problem? Thanks so much for guiding me...

Regards,

Eli

 

[esanchezInDC]

This is how I got this issue "solved"

ISSUE

When you try to grant access for a user to a new company, you may receive the following error message:

The stored procedure smUsrCmpny AccssChck AccssCHG returned the following results: DBMS:15023, Great Plains:0.

RESOLUTION

1. Start Great Plains, and then log in as the sa user.
2. Click Tools, point to Setup, point to System, click SQL Options, clear both boxes, and then click OK.
3. Click Tools, point to Setup, point to System, click User Access, click to highlight the user, clear the box for the company you are trying to grant access to, and then click OK.
4. At the server that is running Microsoft SQL Server, in Enterprise Manager, expand Databases, expand the company database, and then click Users. Right-click the user and then click Delete.
5. In Great Plains, click Tools, point to Setup, point to System, click SQL Options, and then click to mark both boxes.
6. Click Tools, point to Setup, point to System, click User Access, click to highlight the user, click to mark the box for the company you are trying to grant access to, and then click OK.