Cannot query from enterprise manager
Posted on 2005-04-19
I am having some bother with Enterprise manager. Our SQL Server is Windows 2000 Server running SQL Server 2000 Sp 3a. I keep getting error messages when i try to execute a query from enterprise manager on my PC.
Everything was working fine up until yesterday. I could connect and query any of the tables within each database. Now when i try to view rows from a table it displays the following error:
'The query cannot be executed because some files are either missing or not registered. Run seetup again to make sure the required files are registered.'
I looked this up on the web and eventually came across Microsoft KB 315868:
'PRB: Query Can Not Be Executed in SQL Enterprise Manager Query Designer on Windows XP'
I followed this and re-registered the stated files but now when i try to view tables i get the following:
'Unknown Error 800401F9'
I have tried unistalling and re-installing but with no joy. I can query tables no problem from the Query Analyzer.
I am using a Windows XP SP1 to connect to the SQL Server with the latest MDAC version.
I don't understand why this would suddenly begin to happen when everything was working fine before.