installation + performance problems | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

installation + performance problems

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
What is the service pack on XP & SQL? 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.
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
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.
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.
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 />
Are you dabase owner? Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
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
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.
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.
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.
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
Para nada, Saludos Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
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
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.
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
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.
hi,
at the moment, this is running on a standalone dev machine. yogi
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.
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.
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
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.
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
Check: http://support.microsoft.com/default.aspx?scid=kb;en-us;310813 HTH Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
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
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
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.
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.
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
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.
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 />
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
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.
]]>