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 2006

Tip: Looking for answers? Try searching our database.

Ent Mgr. does not show databases after OS upgrade

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jetski - 24 Sep 2006 08:46 GMT
Hi
My configuration is Windows 2000 Adv. server SP4 and two istances of SQL
2000 sP3.
I just updated the OS from sp3 to SP4 last night and now when i open Ent.
Mgr from any desktop or console pc and when opening the Database folder on
node2 comes up with no items " i don't see any databases", and in Management
i don't see the jobs or what's runnig or what's not.
Didn't know wherwe to post this on sql group or the cluster group,can some
one shed some light on this issue is it a known issue when upgrading the os
to sp4 or is there any thing i need to reconfigure to make it work.
since it has been less than 24 hours on the upgrade i cam across seeing once
or twice and not most of the other time ???
Thanks and regards
Layth
Rodney R. Fournier [MVP] - 24 Sep 2006 18:41 GMT
Upgrades are never your friend. Nuke and pave my friend. Then restore the
DB's from backup!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Hi
> My configuration is Windows 2000 Adv. server SP4 and two istances of SQL
[quoted text clipped - 13 lines]
> Thanks and regards
> Layth
Hilary Cotter - 24 Sep 2006 22:47 GMT
do they show up through isqlw/Query Analyzer?

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi
> My configuration is Windows 2000 Adv. server SP4 and two istances of SQL
[quoted text clipped - 13 lines]
> Thanks and regards
> Layth
jetski - 25 Sep 2006 07:51 GMT
Thanks Hilary and Rodney
We've fixed it
http://www.mcse.ms/archive83-2005-5-1490199.html
and
http://groups.google.co.nz/group/microsoft.public.sqlserver.server/browse_thread
/thread/34a17fbf83c6d800/09f7325c72d4553f?lnk=st&q=odbc+sqlstate%3A+22003+error+
220%3A+arithmetic+overflow+error&rnum=2&hl=en#09f7325c72d4553f


We had 4 offline databases ready to be deleted sometime in the future,
brought them back online and all is sweet,
Thanks also to sql services
www.sqlservices.com

regards
Layth

> do they show up through isqlw/Query Analyzer?
>
[quoted text clipped - 15 lines]
> > Thanks and regards
> > Layth
Richard Fong - 25 Sep 2006 22:23 GMT
> Thanks Hilary and Rodney
> We've fixed it
[quoted text clipped - 29 lines]
> > > Thanks and regards
> > > Layth
Richard Fong - 25 Sep 2006 22:35 GMT
Hi Layth,

Just in case anybody else has this problem.  Here is some more info on it.

The problem exists after the Windows SP4 install as it somehow corrupts the
database version in sysdatabases.
To fix this and determine if you have the same problem, execute the
following statement in master with Query Analyzer:

PROBLEM
==========
select * from sysdatabases

This should return something like (the value may differ):

Microsoft SQL-DMO (ODBC SQLState: 22003)
Error 220: Arithmetic overflow error for that data type smallint, value=32826.
Arithmetic overflow error for data type smallint, value=32826.
The statement has been terminated.

CAUSE
==========
An offline database had a version value of 32826 (or whatever you value is)
in the "version"
field, which is too large for a smallint datatype column in the
sysdatabases table.

RESOLUTION
============
It will fall over when it when it gets to the database with the incorrect
"version" and will NOT
show you the name of the database, so you will need to know the actual
name of the database.   Keep in mind you CAN see the list of databases in
QA, but NOT the
problem database, so it's NOT the next one in the list when you run
the select query.
Once you identify your culprit. Run the Alter
database statement to set the database back online:
"ALTER DATABASE databasename SET ONLINE".

That should fix it.

Cheers
Richard

> Thanks Hilary and Rodney
> We've fixed it
[quoted text clipped - 29 lines]
> > > Thanks and regards
> > > Layth
 
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.