Great Plains 8 ODBC Error (45)

160 pts.
Tags:
Database
Great Plains
ODBC
SQL Server errors
This just started today, Great Plains has been working for a good time now. I get first error message when logging on " A get/change first operation on table 'tablename' (45)." And then when you click on More Info... it says "[Microsoft][ODBC SQL Server Driver][SQL Server]Database'Databasename' is already open and can only have one user at a time." I don't know where to look to fix this I've searched google and tried their help booklet that came with Great Plains. Thanks for any replies.
ASKED: April 7, 2008  1:47 PM
UPDATED: April 7, 2008  2:40 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Answering my own question, but

Called M$ support and this is the solution

Log into the SQL server, go to Enterprise Manger,

Find the database associated ‘Databasename’ > Right click on it > Click on Properties

Once Properties is open click on the Options Tab

From the Options tab, Uncheck the Restrict Access, click apply and click Ok.

Done

-

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following