Windows 2003 sp1 sql server

Hi,

I just installed Win 2003 SP 1 and now I get this error on my sql server

the query cannot be executed because some files are either missing or not
registered

I’ve tried http://support.microsoft.com/defaul...kb;en-us;315868
but I can not register the dlls

I’ve reinstalled mdac 2.8
I dl component checker tool and it’s unknown



How can I fix this?

If I uninstall the service pack, that fixes the problem,  but I want to keep
the service pack :(

"André" wrote:

> Hi,
>
> I just installed Win 2003 SP 1 and now I get this error on my sql server
>
> the query cannot be executed because some files are either missing or not
> registered
>
> I’ve tried [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;315868[/url
]
> but I can not register the dlls
>
> I’ve reinstalled mdac 2.8
> I dl component checker tool and it’s unknown
>
>
>
> How can I fix this?
>

All I can say is do some research on the new SP. Personally I never apply a
SP till all the reviews are posted on credible sites. You just never know

"André" wrote:

> Hi,
>
> I just installed Win 2003 SP 1 and now I get this error on my sql server
>
> the query cannot be executed because some files are either missing or not
> registered
>
> I’ve tried [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;315868[/url
]
> but I can not register the dlls
>
> I’ve reinstalled mdac 2.8
> I dl component checker tool and it’s unknown
>
>
>
> How can I fix this?
>

Steve -
Which sites do you look at? Whose reviews?

BobT



"SteveA" wrote:

> All I can say is do some research on the new SP. Personally I never apply 
a
> SP till all the reviews are posted on credible sites. You just never know
>
> "André" wrote:
> 

Anyone from Microsoft read these post?  Don't they test the SP's?

It's got to be a simple fix.......

"BobT" wrote:

> Steve -
> Which sites do you look at? Whose reviews?
>
> BobT
>
>
>
> "SteveA" wrote:
> 

Hi

I have w2k3 SP1 installed on 4 servers and I don't have a problem at all.

SP1 brings with it an updated version of MDAC.

It this occurring on the SQL server or another server that is connecting to
a SQL Server?

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"André" <Andr@discussions.microsoft.com> wrote in message
news:04E56AF6-5DC1-4580-996B- FF348B0B6253@microso
ft.com...
> Anyone from Microsoft read these post?  Don't they test the SP's?
>
> It's got to be a simple fix.......
>
> "BobT" wrote:
> 

HI,

I only have SQL 2000 with sp 3a and the OS on this.  This is a production
server.

When I discovered this error, I went to our development server (at that time
did not have sp1 installed) and check to see if the right click on the table
and open all records/query to see if it worked, it did.  right after that, i
installed sp1 and rebooted, then check to see if it still worked, and it did
not.

I installed mdac 2.8 to see if that would fix the issue, then I tried to
register those dll's and I could not register them.  I then uninstalled the
sp, and then it worked again.

I did this at one time, so I now it’s the sp that is doing this.  I have n
ot
uninstall the sp on the production server yet.

I did notice one other thing, not sure if or how it is related,  before I
found out that the query tools do not work in sql server,  I when to the
computer management via right click on my computer, then manage and I get a
snap in error: snap-in failed to initialize name: event viewer extension
CLSID:{394c052e-b830-11d0-9a86-00c04fd8dbf7}

This is a pretty new server, less then one month.  Everything was working
great and the only thing that changed was the service pack.   I should try t
o
install the sp1 again on the development server to see if I get the same sna
p
in error…. Monday I guess

Please help with this issue

Andre

Now I also notice when I go to ODBC Administrator i get an error too. "the
ODBC resource DLL  (C:\windows\system32
\odbcint.dll) is a different version
than the administrator  (c:\windows\system32
\odbcad32.exe). You need to
reinstall the ODBC components to ensure proper operation.

All I can say DO NOT INSTALL SP1.

What ever this service pack did, it's not worth it.

Can anyone help?

"André" wrote:

> HI,
>
> I only have SQL 2000 with sp 3a and the OS on this.  This is a production
> server.
>
> When I discovered this error, I went to our development server (at that ti
me
> did not have sp1 installed) and check to see if the right click on the tab
le
> and open all records/query to see if it worked, it did.  right after that,
 i
> installed sp1 and rebooted, then check to see if it still worked, and it d
id
> not.
>
> I installed mdac 2.8 to see if that would fix the issue, then I tried to
> register those dll's and I could not register them.  I then uninstalled th
e
> sp, and then it worked again.
>
> I did this at one time, so I now it’s the sp that is doing this.  I have
 not
> uninstall the sp on the production server yet.
>
> I did notice one other thing, not sure if or how it is related,  before I
> found out that the query tools do not work in sql server,  I when to the
> computer management via right click on my computer, then manage and I get 
a
> snap in error: snap-in failed to initialize name: event viewer extension
> CLSID:{394c052e-b830-11d0-9a86-00c04fd8dbf7}
>
> This is a pretty new server, less then one month.  Everything was working
> great and the only thing that changed was the service pack.   I should try
 to
> install the sp1 again on the development server to see if I get the same s
nap
> in error…. Monday I guess
>
> Please help with this issue
>
> Andre
>

I guess I can assume that I will not get a response

"André" wrote:

> Now I also notice when I go to ODBC Administrator i get an error too. "the
> ODBC resource DLL  (C:\windows\system32
\odbcint.dll) is a different version
> than the administrator  (c:\windows\system32
\odbcad32.exe). You need to
> reinstall the ODBC components to ensure proper operation.
>
> All I can say DO NOT INSTALL SP1.
>
> What ever this service pack did, it's not worth it.
>
> Can anyone help?
>
> "André" wrote:
> 

Hi

Have you contacted Microsoft PSS and opened a case?

I have not had a single problem with w2k3 SP1. Have you been able to
reproduce it on other machines?

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"André" <Andr@discussions.microsoft.com> wrote in message
news:B84487E8-E40A-4DA5-B13E- 40619566641B@microso
ft.com...
>I guess I can assume that I will not get a response
>
> "André" wrote:
>