?
Solved

Microsoft Dynamics CRM - Event ID Error 319

Posted on 2009-02-17
3
Medium Priority
?
884 Views
Last Modified: 2012-05-06
Event Type:      Error
Event Source:      eConnect OutGoing Service 9.0
Event Category:      None
Event ID:      919
Date:            2/12/2009
Time:            11:56:29 AM
User:            N/A
Computer:      SQLSERVER01
Description:
.Net SqlClient Data Provider
Cannot open database requested in login 'TWO'. Login fails.
Login failed for user 'SQLSERVER01\Administrator'.
System.Data.SqlClient.SqlException: Cannot open database requested in login 'TWO'. Login fails.
Login failed for user 'SQLSERVER01\Administrator'.
   at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
   at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   at System.Data.SqlClient.SqlConnection.Open()
   at ExecuteCompanyRequest.PopulateArrayLists()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
Comment
Question by:alcoahd
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
crm_info earned 1500 total points
ID: 23665118
It appears that this is an issue with the econnector to handle integration between Microsoft CRM and Great Plains.  One thing you may want to try is to make sure that the user who is using the eConnect outgoing service and who owns the GP message queue is a Domain Administrator.  These kinds of errors arise frequently when a user has inadequate permissions.

There are some articles about this type of issue available in the Microsoft KB.  However, I am not permitted to share that information publicly.  If you are a Microsoft customer, or you are working with a Microsoft Partner, then you should be able to get access to the Microsoft KB (mbs.microsoft.com/knowledgebase) to search for more information.  

If those don't work, I'm not sure that we can do much else ... but someone else may be able to give you a hand if you can share some more information, such as:
* Is this a new install of CRM?  GP?  Both?
* Which versions?
* How is your infrastructure configured?
* How is BizTalk setup?

0
 
LVL 1

Author Comment

by:alcoahd
ID: 23669739
GP is installed, and the version of eConnect is 9.0 as well as GP 9.0.


I will get more information on the infrastructure and how BizTalk is setup.
0
 
LVL 10

Assisted Solution

by:crm_info
crm_info earned 1500 total points
ID: 23670426
Test the above recommendation for running appropriate services as Domain Controller to see if that remedies your problem.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part III
Loops Section Overview
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question