MSSQLServerADHelper - Error Code -1073741724

[CatPlus]

Hello all:

I get all sorts of error with MSSQLServerADHelper which is stopped and I cannot get it started. Error has Event ID 100

Please help!

Mickey Shekdar

 

[mrdenny]

Is your SQL Server configured to be listed in Active Directory?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[CatPlus]

Hello Denny:

Yes... on a domain controller

Mickey

 

[mrdenny]

Being installed on a dc doesn't mean that SQL is configured to be listed in AD. In Enterprise Manager right click ont he server and go to properties on the active directory tab. If the Add button is available then SQL isn't configured to be listed in AD. The AD Helper service won't be running in this case.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[CatPlus]

Hi Denny:

Thanks for the input. The Add button is greyed out and I could refresh the attributes under the AD tab too!

If I attempt to start the service, error code -1073741724 pops up!

To resolve the issue, I removed SQL2000, removed all folders relating to SQL2000, removed all registry entries referencing SLQ2000, then re-installed SQL2000 and applied SP4.

SLQ2000 is running and I have also registered with databases hosted by other ISPs

MSSQLServerADHelper not starting does not in any ways affect my SQL function. However, I am trying to install an accounting packages that uses SQL2000 for its backend and install will just not happen!!

Does MSSQLServerADHelper have to do anyhting with that and is it even required for it to be runnings?

Please advise

Thanks
Mickey Shekdar

 

[mrdenny]

No the MSSQLServerADHelper service isn't needed for SQL to run. It is only used when SQL Server is registered within the Active Directory which is not required. (We don't have any of our SQL Servers registered in Active Directory).

Are you getting any SQL Specific errors from the Accounting Package's instller?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[CatPlus]

Hey Denny!

Thanks for your quick response Denny!!

SQL does not give me any specific error, but while installing the accounting package, I have noticed that a new category named 'CMSDenail' has been added

Here is a export of the event file I saved in text:

Any thoughts on this one?

Thanks
Mickey Shekdar



08/31/2005 8:44:29 AM CMSDenali_CMSLicenseService Information (1) 4 N/A S1 "Process ID472
License Server Stopped"

08/31/2005 8:44:29 AM CMSDenali_CMSLicenseService Information (1) 3 N/A S1 "Process ID472
License Server Stopping"

08/31/2005 8:44:28 AM CMSDenali_CMSLicenseService Error (2) 5 N/A S1 "Process ID472
<ROOT><MESSAGE>Cannot find table 0.</MESSAGE><SOURCE>System.Data</SOURCE><STACKTRACE> at System.Data.DataTableCollection.get_Item(Int32 index)
at CMSUtil.FRM_LicenseServer.get_Valid(stuServer p_stu)
at CMSLicenseService.cls_CMSLicenseService.OnStart(String[] args)</STACKTRACE><TARGETSITE>get_Item</TARGETSITE></ROOT>"

08/31/2005 8:44:28 AM CMSDenali_CMSLicenseService Error (2) 5 N/A S1 "Process ID472
<ROOT><MESSAGE>Cannot open database requested in login 'COMPANIES'. Login fails.
Login failed for user 'SA'.</MESSAGE><SOURCE>.Net SqlClient Data Provider</SOURCE><STACKTRACE> at System.Data.SqlClient.ConnectionPool.CreateConnection()
at System.Data.SqlClient.ConnectionPool.UserCreateRequest()
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&amp; isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean&amp; isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at CMSUtil.CLS_SQL.GetSQLData(String p_strSQL, stuSQLConnectionInfo&amp; p_ConInfo, DataResult&amp; p_result)</STACKTRACE><TARGETSITE>CreateConnection</TARGETSITE></ROOT>"

08/31/2005 8:44:19 AM CMSDenali_CMSLicenseService Information (1) 1 N/A S1 "Process ID472
License Server Starting"

08/30/2005 10:35:24 PM CMSDenali_CreateDB Shutdown Information (1) 2 N/A S1 "Process ID1884
CreateDB Shutdown"

08/30/2005 10:33:37 PM CMSDenali_CMSLicenseService Error (2) 5 N/A S1 "Process ID244
<ROOT><MESSAGE>Cannot open database requested in login 'COMPANIES'. Login fails.
Login failed for user 'SA'.</MESSAGE><SOURCE>.Net SqlClient Data Provider</SOURCE><STACKTRACE> at System.Data.SqlClient.ConnectionPool.CreateConnection()
at System.Data.SqlClient.ConnectionPool.UserCreateRequest()
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&amp; isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean&amp; isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at CMSUtil.CLS_SQL.GetSQLData(String p_strSQL, stuSQLConnectionInfo&amp; p_ConInfo, DataResult&amp; p_result)</STACKTRACE><TARGETSITE>CreateConnection</TARGETSITE></ROOT>"

08/30/2005 10:32:45 PM CMSDenali_CMSLicenseService Information (1) 4 N/A S1 "Process ID2816
License Server Stopped"

08/30/2005 10:32:45 PM CMSDenali_CMSLicenseService Information (1) 3 N/A S1 "Process ID2816
License Server Stopping"

08/30/2005 10:32:44 PM CMSDenali_CMSLicenseService Error (2) 5 N/A S1 "Process ID2816
<ROOT><MESSAGE>Cannot find table 0.</MESSAGE><SOURCE>System.Data</SOURCE><STACKTRACE> at System.Data.DataTableCollection.get_Item(Int32 index)
at CMSUtil.FRM_LicenseServer.get_Valid(stuServer p_stu)
at CMSLicenseService.cls_CMSLicenseService.OnStart(String[] args)</STACKTRACE><TARGETSITE>get_Item</TARGETSITE></ROOT>"

08/30/2005 10:32:44 PM CMSDenali_CMSLicenseService Error (2) 5 N/A S1 "Process ID2816
<ROOT><MESSAGE>Cannot open database requested in login 'COMPANIES'. Login fails.
Login failed for user 'SA'.</MESSAGE><SOURCE>.Net SqlClient Data Provider</SOURCE><STACKTRACE> at System.Data.SqlClient.ConnectionPool.CreateConnection()
at System.Data.SqlClient.ConnectionPool.UserCreateRequest()
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&amp; isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean&amp; isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at CMSUtil.CLS_SQL.GetSQLData(String p_strSQL, stuSQLConnectionInfo&amp; p_ConInfo, DataResult&amp; p_result)</STACKTRACE><TARGETSITE>CreateConnection</TARGETSITE></ROOT>"

08/30/2005 10:32:30 PM CMSDenali_CMSLicenseService Information (1) 1 N/A S1 "Process ID2816
License Server Starting"

08/30/2005 10:32:30 PM CMSDenali_InstallPrimaryDB Shutdown Information (1) 2 N/A S1 "Process ID1300
InstallPrimaryDB Shutdown"

 

[mrdenny]

It appears that it is looking for a database that isn't available on the SQL Server. It looks like it's looking for a database named "COMPANIES".

You've got to love those .NET error messages.

Give the vendor a call. Thier installed sucks.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)