SQL error

Discussion forum for Enterprise Edition.
Post Reply
brian.henry
Posts: 23
Joined: Tue Feb 21, 2006 6:15 am

SQL error

Post by brian.henry » Sat Sep 29, 2007 3:39 am

I just installed 3.0 on my server and I'm getting an SQL error in the Windows Event Log win I run the Diagnostic Report

This started after I used the provider Utility

Here's the errors

Windows Event Log Report
The following table outlines recent (with 7 days) significant MailEnable events written to the Windows Event Log.
Time Source Test Response Status
26 Sep 2007 17:55:52 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEHTTPS.EXE; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:52 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEIMAPS.exe; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:53 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MELSC.EXE; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:54 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEPOC.EXE; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:54 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEPOPS.EXE; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:54 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEMTA.EXE; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:54 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MERADMS.exe; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:55 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MESMTPC.EXE; Error: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEPOC.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEPOPS.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEMTA.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEIMAPS.exe; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEHTTPS.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MEPOPC.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MERADMS.exe; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail
26 Sep 2007 17:55:58 MailEnable MailEnable Database Provider error: 0,FAILURE: (SQLDriverConnect), Module: MESMTPC.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "MailEnable" requested by the login. The login failed. Fail

How do I fix this.

brian.henry
Posts: 23
Joined: Tue Feb 21, 2006 6:15 am

Help

Post by brian.henry » Tue Oct 02, 2007 1:22 am

Any one.

MailEnable
Site Admin
Posts: 4441
Joined: Tue Jun 25, 2002 3:03 am
Location: Melbourne, Victoria Australia

Post by MailEnable » Tue Oct 02, 2007 1:39 am

The error is most likely that the credentials specified for MailEnable to access the Database are being rejected by the server (or less likely, that the SQL server instance itself is not contactable).

Which version of SQL server are you using?

Have you browsed the SQL Server to see if the database itself has been created?

Perhaps use the SQL Server profiler to profile security audit events or check the windows event log to see if there are any reported access denied errors when connecting to SQL Server.
Regards, Andrew

brian.henry
Posts: 23
Joined: Tue Feb 21, 2006 6:15 am

SQL Error

Post by brian.henry » Tue Oct 02, 2007 2:20 am

Thanks for the reply I'm using SQLEXPRESS 2005 the MailEnable database was created and the tables have data in them. There are no errors in the windows event log

brian.henry
Posts: 23
Joined: Tue Feb 21, 2006 6:15 am

SQL Error

Post by brian.henry » Tue Oct 02, 2007 4:07 am

Sorry I did fiend access denied errors

Heres the Errors

10/1/2007 9:01:48 PM Ci Information CI Service 4137 N/A HOBOMAIL1 CI has started for catalog c:\inetpub\catalog.wci.
10/1/2007 9:01:47 PM Ci Information CI Service 4137 N/A HOBOMAIL1 CI has started for catalog c:\system volume information\catalog.wci.
10/1/2007 9:01:46 PM Ci Information CI Service 4137 N/A HOBOMAIL1 CI has started for catalog c:\fpse_search\catalog.wci.
10/1/2007 8:57:54 PM MSSQL$SQLEXPRESS Information (2) 17401 N/A HOBOMAIL1 Server resumed execution after being idle 170 seconds: user activity awakened the server. This is an informational message only. No user action is required.
10/1/2007 8:54:34 PM TroxoLiveUpdate Information None 0 N/A HOBOMAIL1 The description for Event ID ( 0 ) in Source ( TroxoLiveUpdate ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Service started.
10/1/2007 8:54:33 PM MESMTPCS Information None 1 N/A HOBOMAIL1 "General: (MailEnable SMTP Service error: 0) ME-I0144: Service Completed Loading Agents
"
10/1/2007 8:54:33 PM MERADMS Information None 1 N/A HOBOMAIL1 "General: (MERADMS error: 203) Service Completed Loading Agents
"
10/1/2007 8:54:33 PM MEPOPS Information None 1 N/A HOBOMAIL1 "General: (MailEnable POP3 Service error: 0) Service Started
"
10/1/2007 8:54:32 PM MEHTTPS Information None 1 N/A HOBOMAIL1 "General: (MailEnable HTTPMail Service error: 0) Service Completed Loading Agents
"
10/1/2007 8:54:32 PM MEIMAPS Information None 1 N/A HOBOMAIL1 "General: (MEIMAPS error: 0) Service Completed Loading Agents
"
10/1/2007 8:54:32 PM MSSQL$SQLEXPRESS Information (2) 17137 N/A HOBOMAIL1 Starting up database 'MailEnable'.
10/1/2007 8:54:32 PM Perflib Warning None 2003 N/A HOBOMAIL1 "The configuration information of the performance library ""C:\WINDOWS\system32\perfts.dll"" for the ""TermService"" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted."
10/1/2007 8:54:31 PM Perflib Warning None 2003 N/A HOBOMAIL1 "The configuration information of the performance library ""C:\WINDOWS\system32\aspperf.dll"" for the ""ASP"" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted."
10/1/2007 8:54:31 PM SSCollect Information None 0 N/A HOBOMAIL1 Service started successfully.
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Information (2) 9688 N/A HOBOMAIL1 Service Broker manager has started.
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Information (2) 9666 N/A HOBOMAIL1 The Database Mirroring protocol transport is disabled or not configured.
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Information (2) 9666 N/A HOBOMAIL1 The Service Broker protocol transport is disabled or not configured.
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Information (2) 3408 N/A HOBOMAIL1 Recovery is complete. This is an informational message only. No user action is required.
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MEPOPC.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database ""MailEnable"" requested by the login. The login failed.
."
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MEMTA.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database ""MailEnable"" requested by the login. The login failed.
."
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MERADMS.exe; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database ""MailEnable"" requested by the login. The login failed.
."
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MEPOC.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database ""MailEnable"" requested by the login. The login failed.
."
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MEPOPS.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database ""MailEnable"" requested by the login. The login failed.
."
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MESMTPC.EXE; Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database ""MailEnable"" requested by the login. The login failed.
."
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MSSQL$SQLEXPRESS Failure Audit (4) 18456 N/A HOBOMAIL1 Login failed for user 'sa'. [CLIENT: 10.0.10.2]
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MEHTTPS.EXE; Error: [Microsoft][ODBC SQL Server Driver]Timeout expired
."
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MEIMAPS.exe; Error: [Microsoft][ODBC SQL Server Driver]Timeout expired
."
10/1/2007 8:54:30 PM MailEnable Error None 10000 N/A HOBOMAIL1 "The description for Event ID ( 10000 ) in Source ( MailEnable ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: MailEnable Database Provider error: 0, FAILURE: (SQLDriverConnect), Module: MELSC.EXE; Error: [Microsoft][ODBC SQL Server Driver]Timeout expired
."
10/1/2007 8:54:29 PM MSSQL$SQLEXPRESS Information (2) 17137 N/A HOBOMAIL1 Starting up database 'tempdb'.
10/1/2007 8:54:29 PM MSSQL$SQLEXPRESS Information (2) 17126 N/A HOBOMAIL1 SQL Server is now ready for client connections. This is an informational message; no user action is required.

Post Reply