.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

sp4 Sql server 2000 version issue

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

I have two sql servers one with version 2000.8.00.2050 and another with 2000.8.00.2055.

I want to upgrade 2050 to 2055. How can I do that.? I thought it is matter of sp4. so I installed a file [SQL2000-KB884525-SP4-x86-ENU.EXE] from

http://www.microsoft.com/downloads/en/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en.

But this makes no difference to version.

Do I need to apply some hotfixes?

Thanks!




View Complete Post


More Related Resource Links

My Site Issue: "The evaluation version of Microsoft Office SharePoint Server 2007 for this server ha

  

Hi Guys,

when i opened my site am getting following error, but moss 2007 server is Licensed Verison.

 

Thanks  Advanced.

 

 


microsoft management console issue in SQL Server 2000

  

Hi Team,

I have an issue starting the management console (enterprise manager), Installed SQL Server 2000 and when i try to open the enterprise manager got a pop-up Microsoft management console the selected file cannot be found.

more info installed using my username but am not the admin of the machine is this causing the issue, though i didn't face any issue in the installation and i haven't restarted the server after installation.

Any help would be greatly appreciated!!

Regards,

Eshwar.


SQL 2000 server has an issue after an unidentifed event and began running at a snails pace.

  

One of our SQL 2000 servers has an issue after an unidentifed event and began running at a snails pace.

     I know SQL 2000 is no longer supported.

We are running IIS on the same server and no connection can be made to the SQL server on the same machine.

     Microsoft OLE DB Provider for ODBC Drivers error '80004005'

     Specifed driver could not be loaded due to system error 5 (SQL Server).

A std query from outside the server works fine until a  Join is added then it runs forever.

A backup and restord did nothing as well as reindexing, shrinking and optimizing. 

After restoring the database on another SQL 2000 server we compared the speeds.

Bad server 4:22 minutes good server less then 1 second.

Any sugguestions??????  r.morrison@gerresheimer.com


ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found

  

Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this

ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found.

  

Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this

sql server 2000 vs 2005

  

i would like to ask what the difference between sql server 2000 and 2005 


Word Automation Issue in Windows Server 2008 Hosting

  

Hi,

The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.


With Regards,

Ashok



Team System: Team Foundation Server Version Control

  

In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007


Data Points: XML Features in SQL Server 2000

  

SQL ServerT 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.

John Papa

MSDN Magazine June 2005


OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

  

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003


Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000

  

SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003


Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to

  

Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of data from SQL Server 2000 and make the process of pushing data to your users a lot easier.

Alok Mehta and Daniel Williams

MSDN Magazine August 2002


SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000

  

XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002


SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web

  

Using XML for data access allows you to separate the data from the presentation, and promotes reuse, extensibility, and division of labor. XML also has a simplified data model, which promotes easier testing. This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

Scott Howlett and Darryl Jennings

MSDN Magazine January 2002


BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server 2000

  

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information. The sample app presented here uses updategrams to make the database updates. To accomplish this, the mapping and usage of updategrams is explained. In this example, BizTalk is used to illustrate the XML capabilities of SQL Server 2000.

Christian Thilmany

MSDN Magazine January 2002


SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices

  

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.

Paul Yao and David Durant

MSDN Magazine June 2001


Server Farms: Application Center 2000 Offers World-Class Scalability

  

Application Center 2000 simplifies the deployment of a Microsoft .NET-based application to clusters, which are shared-nothing, loosely coupled computers that appear as one virtual computer. This allows all the computers in Application Center 2000 clusters to provide the same service or Web application at the same time. This article explains network load balancing and component load balancing for COM+ components with Application Center 2000. Accessing the features of Application Center 2000 though the MMC snap-in interface and the command-line interface for batching administrative tasks is also covered.

Panos Kougiouris

MSDN Magazine May 2001


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend