Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
PRB: 80040005 Error Message When You Start the Profile Service
| Article ID | : | 330963 |
| Last Review | : | March 17, 2003 |
| Revision | : | 2.1 |
This article was previously published under Q330963
SYMPTOMS
When you start the Commerce Server profile service, you may receive the following error message:
Microsoft OLE DB Provider for SQL Server error '80040005'
[DBNETLIB][ConnectionOpen (Connect()).]
SQL Server does not exist or access denied.
Back to the top
CAUSE
This error might occur if the database connection string is wrong or if the computer running SQL Server is not accessible.
Back to the top
RESOLUTION
| 1. | Verify that the connection string is pointing to the correct database. To do this, follow these steps:| a. | Open Enterprise Manager. | | b. | Locate your SITE_Commerce database or Profiles database. | | c. | Open the SourceDef table. | | d. | Verify that the ConnStr values are correct. |
|
| 2. | Verify that the SQL Server service is running. To do this, follow these steps:| a. | Double-click the MSSQLServer icon in the notification area. | | b. | Verify that the SQL Server service is running. |
|
| 3. | Verify that all required ports are open on any firewall or switch between the computer running Commerce Server and the computer running SQL Server. For additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
306843 (http://kbalertz.com/Feedback.aspx?kbNumber=306843/EN-US/) HOWTO: Troubleshoot MS DTC Firewall Issues
|
Back to the top
APPLIES TO
| • | Microsoft Commerce Server 2002 Standard Edition |
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please
