Enterprise manager error in SQL 2000

Hi
Hope someone can help me as I am having major problems. I have seen this
before but none of the usual fixes seem to work.
Problem.
Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot
cycle, so I reinstalled Windows XP Pro. Note, after this I have had major
problems with PC still. e.g., I can't install SP1 or SP2. So I reinstalled
again with a Win XP SP1 disk. Still couldn't install SP2 'cos it says access
is denied, but I'll sort that latter, unless its the cause of this current
problem.
Anyway, I have MSSQL 2000 personal installed on this machine in multiple
instances. When I try to use Enterprise manager to read all rows from a
table, it gives the error:
"Provider cannot be found. It may not be properly installed"
I can access the data from within Query analyser on the PC ok. I can't use
EM on my machine to access data on a separate SQL server. But I can use EM
on another PC to access the tables on my PC, so I know that my database is
ok and that its the install on my PC.
Solutions Tried.
1) I have uninstalled all four instances of SQL on my PC and reinstalled
them and patched them all to SP4.
2) I have re installed MDAC 2.8. Still no Joy
3) I have tried to unregistered msdasql.dll but when I do so, I get the
message:
"DllUnregisterServer in msdasql.dll failed. Return code was : 0x80004005"
Of course I have checked that the services are running.
To me it sounds like an access rights problem though I can't see why as the
data is accessible. But maybe it is connected to some general problem. This
is getting a bit desperate now as I have been working on this all week. All
help is much appreciated.
Regards
Rowland CostinHave you tried reinstalling SQL 2000 client tools only and applied SP4 on
your PC afterwards?
"Rowland Costin" wrote:
> Hi
> Hope someone can help me as I am having major problems. I have seen this
> before but none of the usual fixes seem to work.
> Problem.
> Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot
> cycle, so I reinstalled Windows XP Pro. Note, after this I have had major
> problems with PC still. e.g., I can't install SP1 or SP2. So I reinstalled
> again with a Win XP SP1 disk. Still couldn't install SP2 'cos it says access
> is denied, but I'll sort that latter, unless its the cause of this current
> problem.
> Anyway, I have MSSQL 2000 personal installed on this machine in multiple
> instances. When I try to use Enterprise manager to read all rows from a
> table, it gives the error:
> "Provider cannot be found. It may not be properly installed"
> I can access the data from within Query analyser on the PC ok. I can't use
> EM on my machine to access data on a separate SQL server. But I can use EM
> on another PC to access the tables on my PC, so I know that my database is
> ok and that its the install on my PC.
> Solutions Tried.
> 1) I have uninstalled all four instances of SQL on my PC and reinstalled
> them and patched them all to SP4.
> 2) I have re installed MDAC 2.8. Still no Joy
> 3) I have tried to unregistered msdasql.dll but when I do so, I get the
> message:
> "DllUnregisterServer in msdasql.dll failed. Return code was : 0x80004005"
> Of course I have checked that the services are running.
> To me it sounds like an access rights problem though I can't see why as the
> data is accessible. But maybe it is connected to some general problem. This
> is getting a bit desperate now as I have been working on this all week. All
> help is much appreciated.
> Regards
> Rowland Costin
>
>|||Interesting. I'll give it a try.
Rowland
"Sassan Karai" <SassanKarai@.discussions.microsoft.com> wrote in message
news:FA4B322D-1343-4EA2-AD38-6A96AD15C590@.microsoft.com...
> Have you tried reinstalling SQL 2000 client tools only and applied SP4 on
> your PC afterwards?
> "Rowland Costin" wrote:
> > Hi
> >
> > Hope someone can help me as I am having major problems. I have seen this
> > before but none of the usual fixes seem to work.
> >
> > Problem.
> > Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot
> > cycle, so I reinstalled Windows XP Pro. Note, after this I have had
major
> > problems with PC still. e.g., I can't install SP1 or SP2. So I
reinstalled
> > again with a Win XP SP1 disk. Still couldn't install SP2 'cos it says
access
> > is denied, but I'll sort that latter, unless its the cause of this
current
> > problem.
> > Anyway, I have MSSQL 2000 personal installed on this machine in multiple
> > instances. When I try to use Enterprise manager to read all rows from a
> > table, it gives the error:
> >
> > "Provider cannot be found. It may not be properly installed"
> >
> > I can access the data from within Query analyser on the PC ok. I can't
use
> > EM on my machine to access data on a separate SQL server. But I can use
EM
> > on another PC to access the tables on my PC, so I know that my database
is
> > ok and that its the install on my PC.
> >
> > Solutions Tried.
> > 1) I have uninstalled all four instances of SQL on my PC and reinstalled
> > them and patched them all to SP4.
> > 2) I have re installed MDAC 2.8. Still no Joy
> >
> > 3) I have tried to unregistered msdasql.dll but when I do so, I get the
> > message:
> > "DllUnregisterServer in msdasql.dll failed. Return code was :
0x80004005"
> > Of course I have checked that the services are running.
> >
> > To me it sounds like an access rights problem though I can't see why as
the
> > data is accessible. But maybe it is connected to some general problem.
This
> > is getting a bit desperate now as I have been working on this all week.
All
> > help is much appreciated.
> >
> > Regards
> > Rowland Costin
> >
> >
> >|||Hi Sassan
I have tried this now, but still no joy. So I have reinstalled the operating
system from a Windows XP Pro SP2 disk, and I still have the same problem.
My application still works and retrieving data is no problem, so the issue
is definitely, how enterprise manager accesses the table.
Is there any way to uninstall the SQL provider then reinstall it, as just
uninstalling SQL doesn't seem to do the job.
Thanks
Rowland
"Sassan Karai" <SassanKarai@.discussions.microsoft.com> wrote in message
news:FA4B322D-1343-4EA2-AD38-6A96AD15C590@.microsoft.com...
> Have you tried reinstalling SQL 2000 client tools only and applied SP4 on
> your PC afterwards?
> "Rowland Costin" wrote:
>> Hi
>> Hope someone can help me as I am having major problems. I have seen this
>> before but none of the usual fixes seem to work.
>> Problem.
>> Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot
>> cycle, so I reinstalled Windows XP Pro. Note, after this I have had major
>> problems with PC still. e.g., I can't install SP1 or SP2. So I
>> reinstalled
>> again with a Win XP SP1 disk. Still couldn't install SP2 'cos it says
>> access
>> is denied, but I'll sort that latter, unless its the cause of this
>> current
>> problem.
>> Anyway, I have MSSQL 2000 personal installed on this machine in multiple
>> instances. When I try to use Enterprise manager to read all rows from a
>> table, it gives the error:
>> "Provider cannot be found. It may not be properly installed"
>> I can access the data from within Query analyser on the PC ok. I can't
>> use
>> EM on my machine to access data on a separate SQL server. But I can use
>> EM
>> on another PC to access the tables on my PC, so I know that my database
>> is
>> ok and that its the install on my PC.
>> Solutions Tried.
>> 1) I have uninstalled all four instances of SQL on my PC and reinstalled
>> them and patched them all to SP4.
>> 2) I have re installed MDAC 2.8. Still no Joy
>> 3) I have tried to unregistered msdasql.dll but when I do so, I get the
>> message:
>> "DllUnregisterServer in msdasql.dll failed. Return code was : 0x80004005"
>> Of course I have checked that the services are running.
>> To me it sounds like an access rights problem though I can't see why as
>> the
>> data is accessible. But maybe it is connected to some general problem.
>> This
>> is getting a bit desperate now as I have been working on this all week.
>> All
>> help is much appreciated.
>> Regards
>> Rowland Costin
>>|||Problem solved. Got bored with trying to solve the SQL problem so turned my
attention to the windows update failure problem.
It was a permissions issue with the registry. Good old Microsoft support
fixed it with a batch file that ran through the registry and corrected
things, though I had to install the resource kit first. This made available
a program subinacl.exe
I then ran the following batch file in the resource area where the subinacl
program was.
subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=administrators=f
subinacl /subkeyreg HKEY_CURRENT_USER /grant=administrators=f
subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=administrators=f
subinacl /subdirectories %SystemDrive% /grant=administrators=f
subinacl /subkeyreg HKEY_LOCAL_MACHINE /grant=systems=f
subinacl /subkeyreg HKEY_CURRENT_USER /grant=system=f
subinacl /subkeyreg HKEY_CLASSES_ROOT /grant=system=f
subinacl /subdirectories %SystemDrive% /grant=system=f
I beileve this granted full permissions to the administrator. This fixed
the windows update problem. Then when I tried the Enterprise manager again,
all was well. I therefore think that as I was using windows authentication
enterprise manager couldn't see the provider because it didn't have
permission. So a bit missleading.
Hope this may help anyone else with the same problem.
Nice one Microsoft.
Rowland
"Rowland Costin" <technical@.teamspiritsoftware.co.uk> wrote in message
news:e$C86dXLGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi Sassan
> I have tried this now, but still no joy. So I have reinstalled the
> operating system from a Windows XP Pro SP2 disk, and I still have the same
> problem.
> My application still works and retrieving data is no problem, so the issue
> is definitely, how enterprise manager accesses the table.
> Is there any way to uninstall the SQL provider then reinstall it, as just
> uninstalling SQL doesn't seem to do the job.
> Thanks
> Rowland
> "Sassan Karai" <SassanKarai@.discussions.microsoft.com> wrote in message
> news:FA4B322D-1343-4EA2-AD38-6A96AD15C590@.microsoft.com...
>> Have you tried reinstalling SQL 2000 client tools only and applied SP4 on
>> your PC afterwards?
>> "Rowland Costin" wrote:
>> Hi
>> Hope someone can help me as I am having major problems. I have seen this
>> before but none of the usual fixes seem to work.
>> Problem.
>> Had a serious crash on my Win XP Pro SP2 PC causing a permanent reboot
>> cycle, so I reinstalled Windows XP Pro. Note, after this I have had
>> major
>> problems with PC still. e.g., I can't install SP1 or SP2. So I
>> reinstalled
>> again with a Win XP SP1 disk. Still couldn't install SP2 'cos it says
>> access
>> is denied, but I'll sort that latter, unless its the cause of this
>> current
>> problem.
>> Anyway, I have MSSQL 2000 personal installed on this machine in multiple
>> instances. When I try to use Enterprise manager to read all rows from a
>> table, it gives the error:
>> "Provider cannot be found. It may not be properly installed"
>> I can access the data from within Query analyser on the PC ok. I can't
>> use
>> EM on my machine to access data on a separate SQL server. But I can use
>> EM
>> on another PC to access the tables on my PC, so I know that my database
>> is
>> ok and that its the install on my PC.
>> Solutions Tried.
>> 1) I have uninstalled all four instances of SQL on my PC and reinstalled
>> them and patched them all to SP4.
>> 2) I have re installed MDAC 2.8. Still no Joy
>> 3) I have tried to unregistered msdasql.dll but when I do so, I get the
>> message:
>> "DllUnregisterServer in msdasql.dll failed. Return code was :
>> 0x80004005"
>> Of course I have checked that the services are running.
>> To me it sounds like an access rights problem though I can't see why as
>> the
>> data is accessible. But maybe it is connected to some general problem.
>> This
>> is getting a bit desperate now as I have been working on this all week.
>> All
>> help is much appreciated.
>> Regards
>> Rowland Costin
>>
>