SQL Server 2000 install fails on queries but not other operations 
Author Message
 SQL Server 2000 install fails on queries but not other operations

This is

I am trying to install SQL Server on Windows 2000 Professional SP1.  I am using
Windows Authentication (no domain controller).  

The installation only worked partially, possibly due to a problem with ADO:
1.  I can use the enterprise manager to create tables, inspect the structure of
tables, configure security, build stored procedures, etc, but CANNOT query the
database.  When I query a database table, I get the message: "The query cannot be
executed because some files are missing or not registered."
2.  I can successfully create an Access project that references an old database,
but when I do I cannot see any tables or queries in the database (reason:  
connection dropped).  When I test the connection during creation, the connection
tests OK.  (BTW, I DID install the Access 2000/SQL Server 2000 Migration patch).
3.  Curiously, I can use the Query Analyzer to successfully evaluate queries on
any table in the database.
4.  SQLdiag does not seem to return any obvious problems.

My thought is that ADO or ODBC is broken because SQL Server does seem to work via
the Query Analyzer.  Unfortunately reinstallation of MDAC doesn't fix the problem.

Does anyone have any insight into this problem?  

Mark



Fri, 11 Jul 2003 16:08:29 GMT
 SQL Server 2000 install fails on queries but not other operations

Hi Mark,

It does sound like you had a bad install of SQL 2000.  Unfortunately, my
reccomendation is that you completely uninstall and reinstall SQL Server,
and pay close attention to any problems that come up during the reinstall.  
These errors are very significant, and can point the way to what is causing
the installation to have problems in the first place.  But as it stands
now, that is probably the only way you are going to be able to resolve the
problems you are experiencing as a result of the previously failed
installation.

Hope that helps!

Jon Burchel



Sat, 12 Jul 2003 10:39:32 GMT
 SQL Server 2000 install fails on queries but not other operations
Sorry Mark but Jon Burchel's advise should be taken.  MDAC is installed
first as part of the SQL 2K installation
so 'broken ODBC' is not your problem.  When you do reinstall try using just
standard security first.


Quote:
> Hi Mark,

> It does sound like you had a bad install of SQL 2000.  Unfortunately, my
> reccomendation is that you completely uninstall and reinstall SQL Server,
> and pay close attention to any problems that come up during the reinstall.
> These errors are very significant, and can point the way to what is
causing
> the installation to have problems in the first place.  But as it stands
> now, that is probably the only way you are going to be able to resolve the
> problems you are experiencing as a result of the previously failed
> installation.

> Hope that helps!

> Jon Burchel



Sat, 12 Jul 2003 20:17:43 GMT
 SQL Server 2000 install fails on queries but not other operations
Hi Mike,

You can uninstall and reinstall MDAC on your system by using the /D option
with Component checker.  It will ask you for the redistributable of MDAC
that you would like to use to reinstall, so make sure you have it handy
when you do the uninstall.  It is available, as you may know, at
http://www.microsoft.com/data.

Good luck!

Jon Burchel



Mon, 14 Jul 2003 12:34:21 GMT
 SQL Server 2000 install fails on queries but not other operations

TIA,

I am experiencing a problem with the initialization of the Help Center using Windows
ME.  I isolated the problem to my MDAC installation.  I ran the MDAC Component Checker
and found a mixed installation of MDAC 25 and MDAC 2.5 SP1. There are 13 files that
are out of sync and seven registry keys that are missing.

To complicate matters a bit further,  I also have Windows 2000 installed on my C drive
(dual boot).  The MDAC configuration is almost correct for  MDAC 2.5 SP1.  There are
three files that are out of sync.

Now for the $64K question.  How can I re-install MDAC 2.5 SP1?  Is there a switch
setting to override the following error message:

     "Microsoft Data Access Components 2.5 is already installed on the version of
     windows that you are running....."

Hopefully, the procedure will be the same for WIndows ME and Windows 2000.

Thanks,
Mike Volikas



Mon, 14 Jul 2003 10:03:24 GMT
 SQL Server 2000 install fails on queries but not other operations
...The problem ended up being a broken ADO DLL (msado15.dll or similar
name).  ...discovered the problem with a small VB program and HandleEx.
SQL 2000 reinstall did not fix the problem, nor did a reinstall of ADO 2.6.

I fixed the problem by installing 2.6 on a {*filter*} machine and copying (and
registering) the DLL that I needed.
Is there a "force" reinstall option for MDAC?

Mark


Quote:
> Sorry Mark but Jon Burchel's advise should be taken.  MDAC is installed
> first as part of the SQL 2K installation
> so 'broken ODBC' is not your problem.  When you do reinstall try using
just
> standard security first.



> > Hi Mark,

> > It does sound like you had a bad install of SQL 2000.  Unfortunately, my
> > reccomendation is that you completely uninstall and reinstall SQL
Server,
> > and pay close attention to any problems that come up during the
reinstall.
> > These errors are very significant, and can point the way to what is
> causing
> > the installation to have problems in the first place.  But as it stands
> > now, that is probably the only way you are going to be able to resolve
the
> > problems you are experiencing as a result of the previously failed
> > installation.

> > Hope that helps!

> > Jon Burchel



Thu, 17 Jul 2003 13:53:16 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. SQL Server 2000 install fails on queries but not other operations

2. SQL Server 2000 installed - Enterprise Manager will not run - Snap-in failed to initialise (MMC)

3. Install MS SQL Server 2000 on Window 2000 Server Failed

4. Fail to install the SQL 2000 on Advanced Server 2000

5. SQL Server 2000 Install Error - pending file operations

6. SQL Server 7 install fails on Windows 2000 Server

7. SQL Server 2000 SP3 fails to install on Windows Server 2003

8. SQL 2000 Install Error: SQL Server configuration failed

9. Sql 2000 Install Error: Sql Server configuration failed

10. Install SQL Server 7.0 when SQL Server 2000 is installed

11. SELECT INTO #Temp in SP fails on some servers not others

12. SQL Server 2000 install fails


 
Powered by phpBB® Forum Software