Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / September 2005

Tip: Looking for answers? Try searching our database.

MDAC 2.7 in Windows NT Cluster with SQL 7.0

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andrew Caldwell - 14 Sep 2005 11:43 GMT
Hope fully there is someone who has done a similar stupid thing!  We have got
ourselves into a bit of trouble when MDAC 2.7 was accidentally (?) installed
onto our Windows NT Cluster wich still runs  SQL 7.0.  
The result was that the SQL Agent stopped working.  However the 2
applications that access the database running on the same cluster are all
working 100% and all client application accessing the database are working
correctly.

The solution offered by Microsoft in KB 820754 is that we should either:
- uncluster SQL
- re-install the sytem from scratch
- Install SQL 2000
Neither of these options are very appealing at this point as the system is
due for a major upgrade to Windows 2003/SQL 2000 in the near future (2-6
month)
Has anyone had a similar problem and how was the problem solved ?  What risk
would we have if we continued to run like this and just removed the SQL Agent
resource.  Currently we use the SQL Agent to schedule a few database
maintenace tasks which could easily be done manually.

Signature

Andrew

Anthony Thomas - 15 Sep 2005 06:14 GMT
You could try to use the MDAC rollback functionality to recover the 2.5
installation.  You could also try to reinstall 2.5.  Otherwise, you are
pretty much as how the KC describes it, leave it alone and do without or do
some sort of rebuild.

Sincerely,

Anthony Thomas

Hope fully there is someone who has done a similar stupid thing!  We have
got
ourselves into a bit of trouble when MDAC 2.7 was accidentally (?) installed
onto our Windows NT Cluster wich still runs  SQL 7.0.
The result was that the SQL Agent stopped working.  However the 2
applications that access the database running on the same cluster are all
working 100% and all client application accessing the database are working
correctly.

The solution offered by Microsoft in KB 820754 is that we should either:
- uncluster SQL
- re-install the sytem from scratch
- Install SQL 2000
Neither of these options are very appealing at this point as the system is
due for a major upgrade to Windows 2003/SQL 2000 in the near future (2-6
month)
Has anyone had a similar problem and how was the problem solved ?  What risk
would we have if we continued to run like this and just removed the SQL
Agent
resource.  Currently we use the SQL Agent to schedule a few database
maintenace tasks which could easily be done manually.

Signature

Andrew

Andrew Caldwell - 23 Sep 2005 14:36 GMT
Thanks

We found a way to rollback the MDAC to 2.5 which seems to have worked.

Andrew
Signature

Andrew

> You could try to use the MDAC rollback functionality to recover the 2.5
> installation.  You could also try to reinstall 2.5.  Otherwise, you are
[quoted text clipped - 26 lines]
> resource.  Currently we use the SQL Agent to schedule a few database
> maintenace tasks which could easily be done manually.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.