Microsoft KB Archive/330963

= PRB: 80040005 Error Message When You Start the Profile Service =

Article ID: 330963

Article Last Modified on 3/17/2003

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



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.



CAUSE
This error might occur if the database connection string is wrong or if the computer running SQL Server is not accessible.



RESOLUTION
 Verify that the connection string is pointing to the correct database. To do this, follow these steps:  Open Enterprise Manager. Locate your _Commerce database or Profiles database. Open the SourceDef table. Verify that the ConnStr values are correct. </li> Verify that the SQL Server service is running. To do this, follow these steps:  Double-click the MSSQLServer icon in the notification area.</li> Verify that the SQL Server service is running.</li></ol> </li> 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 HOWTO: Troubleshoot MS DTC Firewall Issues

</li></ol>

Additional query words: plutonium

Keywords: kbfix kbnofix kbprb kbpending KB330963

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.