ADSM-L

Re: TDP SQL 2.2, Dr. Watson error

2002-02-26 07:42:59
Subject: Re: TDP SQL 2.2, Dr. Watson error
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Tue, 26 Feb 2002 07:40:56 -0500
> The B/A client works fine.  However when stating the TDP GUI, I get the
> initial window displayed and then real soon a Dr. Watson Application
error.
> Error in tdpsql.exe  Exception: access violation (0xc00000005),
> Address 78001562.  When I looked at Event viewer, the only additional
> info was Event ID 4097, and Address 78001562 (wcslen).  I have totally
> cleaned off the old Tivoli and resinstalled this again with same results.

David,

We have seen this when the SQL server name was "null'ed".
To check this issue the following T-SQL command:
      select @@servername
If it comes back with no name or "null", try the following:

1. From the QA (Query Analyzer) issue the system procedure command:
         sp_addserver 'servername',local
   where 'servername' is the server name if accessing a SQL Server default
   instance, and is servername\instancename if accessing a named instance.

2. Stop and restart the SQL Server instance.

3. From the QA issue:
      select @@servername
   You should see the servername you used in sp_addserver.

4. Retry the TDP-SQL operation.

If it still fails, please call IBM support.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"Celebrate we will. Life is short but sweet for certain..."  -- Dave
<Prev in Thread] Current Thread [Next in Thread>