SQL Server Performance

installation + performance problems

Discussion in 'General DBA Questions' started by yogi, Sep 3, 2004.

  1. yogi New Member

    Hi,

    OS: win XP
    sqlVersion: sql2k

    I've been round the block with this problem.
    Originally when I tried to add a new database diagram in EM, I got the error
    <"library not registered">

    I initially thought that it might be a problem with a cryatal reports version 8 install, so I ran the following .exe:
    scr8_webregfix.exe

    I have also:
    1) uninstalled and re-installed sql2k
    2) installed the latest version of mdac

    Now, in EM, when I try to create a new database diagram, I get the error:

    <error>
    an unexpected error occurred during this operation
    [MS design tools] class not registered.
    <error>

    I get the following error in the sqlstp

    <error>
    Process Exit Code: (-2147312566) Error loading type library/DLL.
    <error>

    I can of course provide more details and event log info and registry info, and I'd like to step back to the beginning to get to the root of the problem.

    Any suggestions?
    Cheers,

    yogi









  2. satya Moderator

  3. yogi New Member

    hi Satya,

    1)XP is SP1

    I ran the following query to get the sql SP:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    it returned:
    8.00.194 RTM Developer Edition

    Does this mean that it doesn't have a service pack?
    Should I install sp3A immediately?

    Cheers,
    yogi
  4. Luis Martin Moderator

    Yes, you have no sp on SQL server. I recommend to install sp3 an try again.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  5. satya Moderator

    SP3a ASAP in order to ensure all the bugs were fixed, may be the one you're getting.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. yogi New Member

    usted manda <img src='/community/emoticons/emotion-1.gif' alt=':)' /> <br /><br />Ok, now I have the following:<br /><br /><br />product version: 8.00.760 (SP3)<br /><br />I rebooted, but the error persists.<br />Any suggestions on my next step?<br /><br />ta, <br />yogi<br /><br />
  7. Luis Martin Moderator

    Are you dabase owner?



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  8. yogi New Member

    hi,

    The sql service is logged on as "local system account".
    I can confirm that the 3 users of this database have the "db_owner" database role.
    Is this what you mean?

    Also, I CAN create sprocs thru EM, but I get the same old error when I try to create tables (when logged in as the SAME user who can successfully create sprocs)

    <error>
    an unexpected error occurred during this operation
    [MS design tools] class not registered.
    <error>

    Does this shed any light?

    cheers,
    yogi
  9. Luis Martin Moderator

    How about if you login as sa?



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  10. yogi New Member

    hi Luis,
    embarassingly enough, I can't see how to login as sa.
    I go to "all tasks" but can't see an option to do this.
    Do I have to use a sproc in QA inorder to log out then log in as QA?

    sorry to ask.
  11. Luis Martin Moderator

    Ok. Use SQL Server Tools, Query Analyzer and when ask about server, connect usign sa.
    Once in QA, try to create one table to know is issue persist.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  12. yogi New Member

    hi Luis,
    I tried to log in theu QA as "sa" with a blank password.It did not let me in :-(
    Unfortunately, I had to leave the office for the weekend.I'll have to wait till monday.
    asi que, hasta lunes, si no te molesta?

    cheers,
    yogi
  13. Luis Martin Moderator

    Para nada,

    Saludos

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  14. yogi New Member

    Hi,

    Apparently I can:
    1) log in thru QA as "sa"
    2) Create a table using T-sql.

    So, I can only assume that there is a problem with the tools in enterprise manager.
    As I said before, I have:
    1) uninstalled
    2) re-installed many times.

    I still get the saem error when I try to create a new table in EM:

    <error>
    an unexpected error occurred during this operation
    [MS design tools] class not registered.
    <error>

    I checked the event logs, both BEFORE and AFTER this error, but nothing.

    I've no idea what I should do next.
    Can anyone comment, I'd really appreciate it.

    cheers,
    yogi
  15. satya Moderator

    Any possibility of reinstalling XP with latest service pack and client tools as well.
    Try from another machine also to confirm the status.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  16. yogi New Member

    Hi Satya, <br /><br />AFAIK, unless I use remote software, I can't access the GUI tools in EM that is running on my machine via another machine on the network.(Maybe I misunderstand you?)<br /><br />I was hoping that I wouldn't have to re-install the OS.At the moment, I can still use sql server to an extent.I'm under a bit of pressure here, So I'll try to re-intall the OS nearer the end of the week.<br /><br />ta for sticking with this thread <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />yogi
  17. satya Moderator

    Confirm whether you're getting this unexpected error on your client machine or on the server?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  18. yogi New Member

    hi,
    at the moment, this is running on a standalone dev machine.

    yogi
  19. satya Moderator

    CHeck whether you're getting this error or similar one on any other part of SQL Enterprise Manager. My whole contention is to say about tools/.Dlls mismatch on this box.

    If its a dev.box then I don't think its hard to do it from scratch.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  20. Adriaan New Member

    We've been seeing this type of problem when the server to which you're trying to connect, and the workstation from which you're working, do not have the same SQL Server Service Pack applied. Remember that EM and QA are also covered by the SPs.
  21. yogi New Member

    hi,

    Satya<< CHeck whether you're getting this error or similar one on any other part of SQL Enterprise Manager.>>

    yogi<< yes, I get errors when I try to create database diagrams and tables in EM, but not when I try to create store procedures.

    I am working thru another article that asks me to use regSvr.

    http://web.ask.com/redir?bpg=http:/...se.ms/archive83-2003-12-112702.html&qte=0&o=0

    ..essentially, the person is asked to run regSvr on the following dll's:

    dtspkg.dll
    dtsui.dll
    msdasql.dll 'I get an error
    oledb32.dll 'I get an error


    I noticed the following things:
    1)There were MULTIPLE instances of both msdasql.dll and oledb32.dll on my machine.
    2) I got an error when running regsvr on these dlls.

    <error>
    “loadLibrary (“msdasql.dll” failed – the specified module could not be found
    “loadLibrary (“oledb32.dll” failed – the specified module could not be found
    <error>

    Does this mean the the 2 erroneous dlls are not in the correct location/ maybe there are conflicts due to muliple instances.

    Does the above informnation help?

    cheers,
    yogi








  22. Luis Martin Moderator

    600 miles from home, via dial up, be carefully with XP SP2. I have a Microsoft document (4 pages) with software does not work include Microsoft.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  23. yogi New Member

    Hiya,
    I downloaded fileMon and replicated the error.
    I believe that this is the most relevant section:

    <errorSection>
    MMC.EXE:3660QUERY INFORMATIONC:program FilesCommon FilesMicrosoft SharedMSDesigners982057MSDT70UI.DLLPATH NOT FOUNDAttributes: Error

    MMC.EXE:3660QUERY INFORMATIONC:program FilesCommon FilesMicrosoft SharedMSDesigners982057MSDT70UI.DLLPATH NOT FOUNDAttributes: Error

    MMC.EXE:3660QUERY INFORMATIONC:program FilesCommon FilesMicrosoft SharedMSDesigners98Resources2057MSDT70UI.DLLPATH NOT FOUNDAttributes: Error

    MMC.EXE:3660QUERY INFORMATIONC:program FilesCommon FilesMicrosoft SharedMSDesigners98Resources2057MSDT70UI.DLLPATH NOT FOUNDAttributes: Error

    MMC.EXE:3660QUERY INFORMATIONC:program FilesCommon FilesMicrosoft SharedMSDesigners981033MSDT70UI.DLLPATH NOT FOUNDAttributes: Error

    MMC.EXE:3660QUERY INFORMATIONC:program FilesCommon FilesMicrosoft SharedMSDesigners981033MSDT70UI.DLLPATH NOT FOUNDAttributes: Error
    <errorSection>

    Does this shed any light?

    yogi
  24. Luis Martin Moderator

  25. yogi New Member

    hiya, <br />I tried that but I got a multitude of errors.<br />I have to leave the office just now, but will try tomorrow (as I can't replicate at home :-(<br /><br />many thanks for everyone's patience[<img src='/community/emoticons/emotion-3.gif' alt=':eek:' />)]<br />yogi
  26. yogi New Member

    morning,
    Here is a list of the (unexpected) errors that I got when I followed this KB article:

    <url>
    http://support.microsoft.com/default.aspx?scid=kb;en-us;310813
    <url>

    <errors>
    DllRegisterServer in msdt70.dll failed.
    Return code was: 0x80004005

    DllRegisterServer in mdt2db.dll failed.
    Return code was: 0x80002801c

    DllRegisterServer in mdt2dd.dll failed.
    Return code was: 0x80004005

    DllRegisterServer in mdt2dbns.dll failed.
    Return code was: 0x80002801c


    Mdt2gkor.dll was loaded, but the DllRegisterServer entry point was not found, this file cannot be registered.

    DllRegisterServer in mdt2fw.dll failed.
    Return code was: 0x80002801c

    Mdt3g.dll was loaded, but the DllRegisterServer entry point was not found, this file cannot be registered.

    Mdw9x70.dll was loaded, but the DllRegisterServer entry point was not found, this file cannot be registered.

    DllRegisterServer in mdt2df.dll failed.
    Return code was: 0x80002801c

    Mdt2g.dll was loaded, but the DllRegisterServer entry point was not found, this file cannot be registered.

    Mdt2dfx.dll was loaded, but the DllRegisterServer entry point was not found, this file cannot be registered.
    <errors>

    Should I just bite the bullet and reformat my whole machine?

    cheers,
    yogi
  27. satya Moderator

    I believe the whole point of errors are circulated towards OS and as a last resort try to perform from scratch.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  28. Luis Martin Moderator

    Some times is better (in times term, money too) to install from the beginning.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  29. yogi New Member

    hi folks,
    Looks like that's what I'll have to do.Thanks for taking the time, I really appreciated it.
    Hopefully that will resove it.

    cheers,
    yogi
  30. Luis Martin Moderator

    I you did without re-install, please share with us.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  31. yogi New Member

    Hi Luis<br />Of course I will <img src='/community/emoticons/emotion-1.gif' alt=':)' /> <br />but I think that re-install is the only way that I'll solve it.Either way, I'll let the list know what I did.<br /><br />te lo agradezco a vos<br /><br />yogi<br /><br /><br />
  32. yogi New Member

    hi folks, <br />I re-installed XP and sqlServer.All going well for the moment.I didn't get any further clues as to the original cause.Oh well, I learned a lot along the way.<br /><br />many thanks <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /> yogi
  33. satya Moderator

    I appreciate for coming back with your workaround, that helps for others.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page