RE: SQL 2000 instance showing up as version6.5 after running fixre

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 18:36:26 GMT

sqlservr -c -sInstanceName

will start SQL Server from the command prompt. -s parameter is required only for named instances.

SQL Server Books Online explains all the options for sqlservr

You mentioned that SQL Server started from Services applet. Does the SQL Server resource come online from the Cluster Administrator?

Once it comes online, try connecting to it using Query Analyzer and run

select @@version

See what it results.

I am thinking it will return Microsoft SQL Server 2000 - 8.00.760. This will mean that you have SQL Server 2000 SP3 or 3a (based on version of ssnetlib.dll)

If that is the case then the issue may be Enterprise Manager related and follow the same steps that you would take to troubleshoot an Enterprise Manager issue.. Try
connecting to this instance of SQL Server using another Enterprise Manager to see if you get the same error.

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Relevant Pages

  • RE: cluster resource in resource group failed
    ... Keywords: Classic,Audit Failure ... SQL Server is terminating in response to a 'stop' request from Service ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 on Windows 2003 cluster - URGENT HELP
    ... The log files are plain-text human readable. ... >> Microsoft SQL Server MVP ... >>> do not come online even though I can see them in clusteradmin from ... >>> I feel would come online once SQL server resource comes online. ...
    (microsoft.public.sqlserver.clustering)
  • Failover fails after applying MS03-031 patch
    ... applied successfully SP3a to both nodes (Failover to second node still ... Ms03-031 cummulative patch. ... But when I initiate a "move group" in Cluster Admin, the SQL Server ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server service stopping mode on One Cluster Node
    ... Only SQL Server service and Agent gets failed and never comes online until ... other resources status is Online. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Starting SQL Server Resource Group failed
    ... server if that was the case then your cluster will always fail as this group ... The installation of the Virtual SQL Server 2005 went well, ... "All resources did not come online and therefore you will need to manually ... If I want to bring the Resource Group online, the SQL Server Starts, but a ...
    (microsoft.public.sqlserver.clustering)