A get/change first operation

(0) Share

Report

Posted on by Community Member

Currently, for some reason when trying to log into Great Plains I am getting an error saying "A get/change first operation on table 'coProcess' failed accessing SQL data".

If you click okay it takes you to the login screen. You log back in and it says the maximum number of users is allowed even though no one is logged in.

I then get an "SQL Error: 916 [Microsoft][SQL Server Native Client 10.0] SQL Server] The server principal "username" is not able to access the database "databasename" under the current security context.

Can someone help me here? It is SQL 2008 R2 on a Windows Server 2008 R2

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (0)

Report

RE: A get/change first operation

Hi,

Check the below link:

support.microsoft.com/.../850997

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: A get/change first operation

Unfortunately I have already done that and I get the same issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: A get/change first operation

Did you check the SQL Management Studio for the corresponding user was assigned to the company database as a member of the DYNGRP role?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: A get/change first operation

User already has that role and is in the group

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: A get/change first operation

Have you tried the following steps provided in the below link?

www.experts-exchange.com/.../Q_24496163.html

Was this reply helpful? Yes No
Suggested answer

Justin Sutton on at

Like (0)

Report

RE: A get/change first operation

Hello Chadatergos,

I would recommend checking out KB 871700

871700 Get/change first operation on table coprocess (45)" error message
http://support.microsoft.com/kb/871700/EN-US

I would suspect that clearing out the coprocess error will likely resolve the second error message.

Please let me know if you have any additional questions on this.

Justin Sutton

------------------------------------------------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------------------------------------------------

**This posting is provided 'AS IS' with no warranties and confers no rights.**

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: A get/change first operation

Hi!

I have a problem like you, but in my case Dynamics show me only this:

A get/change first operation on table 'coProcess' (45)

You know something about this for solve?

thanks so much

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: A get/change first operation

Hi EIL,

Could you please try changing to DEFAULTUSER? Take a look at the image below.

Was this reply helpful? Yes No