Sql server 2000 для windows 7 x64

Includes information about the latest SQL Server 2000 service pack.

Summary

Microsoft distributes bug fixes in service packs. Service packs keep a product current. Service packs include updates and may include system administration tools, drivers, and additional components, which are conveniently bundled for easy downloading. Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, as well as any new fixes. You do not need to install a previous service pack before you install the latest one. For example, you do not need to install SQL Server 2000 Service Pack 1 (SP1) before you install SQL Server 2000 Service Pack 2 (SP2).

The SQL Server 2000 service packs are listed in the following sections. Each service pack section contains the following items:

  • A link to download the service pack.

  • A link to the fix list that contains the list of issues that are fixed in the service pack.

  • A link to the ReadMe file for each service pack. The ReadMe file contains additional useful information about the service pack in plain-text format.

Microsoft SQL Server 2000 Service Pack 4

Release date: May 6, 2005

How to obtain

SQL Server 2000 Service Pack 4 (SP4) is available at the following Microsoft Web site:

Download
http://www.microsoft.com/download/details.aspx?FamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5

Fix list

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

888799 A list of the bugs that are fixed in SQL Server 2000 Service Pack 4

888800 A list of the bugs that are fixed in SQL Server 2000 Analysis Services Service Pack 4

Readme

There are four separate Readme files for SQL Server 2000 SP4:

  • ReadmeSql2k32asp4.htm: Service Pack 4 for Microsoft SQL Server 2000 Analysis Services

  • ReadmeSql2k32sp4.htm: Service Pack 4 for Microsoft SQL Server 2000 Database Components

  • ReadmeSql2k32desksp4.htm: Service Pack 4 for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)

  • ReadmeSql2k64sp4.htm: Service Pack 4 for Microsoft SQL Server 2000 (64-bit)

Readme addendum

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

884525 Additions to the SQL Server 2000 Service Pack 4 readme files

SQL Server 2000 Service Pack 3a

Release date: May 19, 2003

Note Because most changes introduced in SP3a are related to Setup, you do not need to apply SP3a to instances of SQL Server 2000 or MSDE 2000 that have already been upgraded to SP3.

If you have instances that have not yet been upgraded to SP3, however, you should always upgrade those instances directly to SP3a instead of SP3. If you have any copies of the SP3 download files that you were planning to use for future upgrades, you should delete those copies and instead use either the SP3a download files or the SP3a CD-ROM.

Applications that distribute and install MSDE 2000 should install SP3a instead of SP3. While you can apply SP3a to instances of SQL Server 2000 SP3 or MSDE 2000 SP3, doing so has little effect on those instances.

How to obtain

SQL Server 2000 Service Pack 3a (SP3a) is available at the following Microsoft Web site:

Download
http://www.microsoft.com/sql/prodinfo/previousversions/sp3.mspx

Fix list

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306908 List of bugs fixed by SQL Server 2000 service packs

Readme

Click here to view the SQL Server 2000 SP3a Readme

Readme addendum

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

816502 SQL Server 2000 Service Pack 3a Readme.htm additions

SQL Server 2000 Service Pack 3

Release date: January 17, 2003

How to obtain

SQL Server 2000 Service Pack 3 (SP3) is no longer available. Please install SP3a instead.

Fix list

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306908 List of bugs fixed by SQL Server 2000 service packs

Readme

If you have previously installed SP3, please see the Readme in your download package.

Readme addendum

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

330022 SQL Server 2000 Service Pack 3 Readme.htm additions

SQL Server 2000 Service Pack 2

Release date: November 30, 2001

Fix list

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

306908 List of bugs fixed by SQL Server 2000 service packs

Readme

889552 Description of Service Pack 2 for SQL Server 2000: November 9, 2001

SQL Server 2000 Service Pack 1

Release date: June 12, 2001

How to obtain

SQL Server 2000 Service Pack 1 (SP1) is no longer available.

Fix list

For more information about the problems that are fixed by SQL Server 2000 Service Pack 1, click the following article numbers to view the articles in the Microsoft Knowledge Base:

290212 List of bugs fixed in SQL Server 2000 Service Pack 1 (1 of 2)

300538 List of bugs fixed in SQL Server 2000 Service Pack 1 (2 of 2)

Readme

889553 Description of Service Pack 1 for SQL Server 2000: May 30, 2001

Comments about this or other Microsoft SQL Server Knowledge Base articles? Drop us a note at
SQLKB@Microsoft.com.

More Information

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005

321185 How to identify your SQL Server version and edition

If the resources that are listed in this section do not help you resolve the problem, or if you experience symptoms that differ from those that are described in this article, search the Microsoft Knowledge Base for more information. To search the Microsoft Knowledge Base, visit the following Microsoft Web site:

http://support.microsoft.comNext, type the text of the error message that you receive or a description of the problem in the search box.

Note If the problem is not resolved, unfortunately this content is unable to help you any further. So, you might want to ask someone for help, or you might want to visit the following Microsoft Web site:

http://support.microsoft.com/contactus

Need more help?

A database server from Microsoft. It was originally based on Sybase SQL Server, and the first versions were for OS/2. It was available as a standalone product and also as a part of Microsoft BackOffice Server.

  • Remove From My Forums
  • Question

  •  I need to install SQL Server 2000 on a Windows 7 machine.  When I start the install I get a message «SQL Server 2000 is incompatible with this versions.  For more information contact Microsoft.»  I searched the forums but did not find
    anything about this situation.  Does anyone have any information? And before anyone asks I need to install this version because that is what the customer is using and I need to duplicate their databases.


    Edward R. Joell MCSD MCDBA

    • Moved by

      Wednesday, January 12, 2011 3:20 PM
      Installation question (From:SQL Server Database Engine)

Answers

    • Edited by
      BalmukundMicrosoft employee
      Wednesday, January 12, 2011 2:16 AM
      typo
    • Marked as answer by
      joeller
      Thursday, January 13, 2011 2:00 PM

What is the Microsoft SQL Server 2000?

The Microsoft SQL Server is a database that is relational and it is developed by Microsoft itself. It is a database server that has the primary function of storing as well as retrieving data as it is requested by the applications of the other software. Dozens of editions of the Microsoft SQL Server have been marketed by Microsoft and this aims at different audiences and it is suitable for workloads that are ranging from small single-machine to large internet-facing applications. Since long, approximately in the year 2002, Microsoft knew the importance of having a powerful database that will be reliable at the same time, and it was released as the Microsoft SQL 2002, which is the oldest incarnation of the program. The fact is that this program can support a lot of users. The Microsoft SQL Server 2002 protects the users and permits them to add passwords to their servers. Unfortunately, there are some drawbacks because it is difficult to install and it is a resource that is heavy especially for the computers that are old and this program is made ideal for this purpose. The Microsoft SQL Server allows the creation of clustered as well non clustered indexes for the users which help in speeding up the access to the data with the use of the index pointers. The Microsoft SQL Server had the same workload as the MSDE but it has no database limit of size. It supports the logical processor of the 256 and it has unlimited virtual memory and it is available with stream Insight Premium edition. The Microsoft SQL Server supports data types such as the Integer, Float, Text, Varchar Char, and Decimal.  The Microsoft SQL Server provides a control mechanism that I very similar to the multi-version control of concurrency and it is used in the databases. This mechanism allows the rows to be created whenever there is a new update.

Microsoft SQL Server 2000 Great Features:

New data types are added like the BIGIT, SQL_VARIANT, and the Table in the Microsoft SQL Server 2002.

The Microsoft SQL Server supports the XML.

Internet Integration:  This server 2000 programming is integrated and modeled with the Windows DNA architecture for the purpose of developing the applications of the Web and the great part is that the SQL Server 2000 supports the feature of the English Query as well as the Microsoft Search Service in order to place a user-friendly query and a powerful search that is capable in the Web applications.

Scalability and its Availability: In this case, the database can be used in platforms across from laptop computers that run in Microsoft Windows 98 through large servers that run Microsoft Windows 2000 edition of the Data Center. The Microsoft SQL Server 2000 edition of the Enterprise supports attributes like the extensive memory support views and the servers that let the scale to the performance which is demanded from the other wanted web sites.

Data Warehousing: Tools to extract as well as analyze data for online processing is included in the SQL Server 2000.

Enterprise-Level Database Characteristic: The SQL Server supports the necessary attributes for the demanding information for the environment. The integrity of the data is then protected and the overheads of the many users are reduced. The keeping of the copies is permitted with the help of the replications. The replications of a set of data can be multiple, disconnected users, and the mobiles and can make them work continuously and autonomously and can then be merged with their modifications and be back to the publishers.

Ease of installation: The Microsoft SQL Server has a few sets of developing and administrative tools that allow the improvement and development upon the process of managing, deploying, and of course installing. The SQL Server 2000 is supporting the standard-based programming which is integrated with the Windows DNA and makes the best use of the SQL Server Database. These great features permit the users to deliver the SQL Server applications that the users will be able to implement with minimum installation and the administrative.

Click on the below link to download the Microsoft SQL Server 2000 All Editions with CRACK & License Keys NOW!

  • Remove From My Forums
  • Вопрос

  • День добрый.

    Попытаюсь описать свою проблему.

    Раньше я использовал MS SQLQ 2000 на Windows XP Pro SP2 для работы с базами для 1С предприятия 7.7

    Принцип конекта 1С требовал, обязательно, что б владельцем базы был ‘SA’. Все работало.

    Решил попробывать Windows 7. Установил сборку 7100 Ultimate.

    В режиме совместимости с Windows XP SP2 поставил и MSSQL 2000 и 1С Предприятие 7.7

    Сама 1С (не в режиме SQL) работает вполне нормально. Но при попытке воспользоватся MSSQL сервером получаю выгребаю ошибки.

    При попытке подключится к базе поручаю ошибку см.картинку

    как бы перебороть это, если, конечно, это вообще лечится…

    Заренее благодарен.

Ответы

  • Собственно все заработало в режиме совместимосит.

    Проблемма была в том, что пользователь SA — пользователь MSSQL. а авторизация стояла Windows.

    Но все равно, без замены штабных (Windows 7) dll для драйверов ODBC заставить его работать не получалось.

    Спасибо за ответ.

    • Помечено в качестве ответа

      4 сентября 2009 г. 9:15

I have SQL server 2000 dev edition. But it isn’t compatible with my new win7 pro 64 bit computer. Is there a free version of 2000 that I can install on my 64 bit pc for development?

As I understand it, I can restore a 2000 database to sql server 2008. But I wont be able to restore the database back to the 2000 server after making any changes in 2008.

asked Mar 6, 2010 at 17:20

Ronnie Overby's user avatar

Ronnie OverbyRonnie Overby

44.6k73 gold badges265 silver badges345 bronze badges

3

The free version of sql server 2000 is called «MSDE». I haven’t tried it, but I don’t think it works with windows 7. If it does work with Windows 7, you’ll have to make sure you run the installer as administrator, and remember that being logged in to the administrator account isn’t enough to ensure that happens anymore.

Otherwise, you’ll have to update to at least sql server 2005. Both sql server 2005 and sql server 2008 have express editions with licenses that do permit production use if that’s any help. If that doesn’t work you’ll need to install sql server 2000 on a separate machine (even a vm would do) and use newer sql server management studio software to connect to it.

answered Mar 6, 2010 at 17:30

Joel Coehoorn's user avatar

Joel CoehoornJoel Coehoorn

391k111 gold badges561 silver badges789 bronze badges

You could use a virtual pc or equivalent with an older OS image on it. I use Virtualbox, it’s free and I am very happy with it. I always keep on my home server a compressed Virtualbox image of XP with Sql Server for emergencies.

answered Mar 6, 2010 at 17:35

iDevlop's user avatar

step1

1-Enter gpedit.msc into the start menu and hit Enter.

2-Now navigate to User ConfigurationAdministrative TemplatesWindows ComponentsApplication Compatibility. Then on the left side under Setting double click on Turn off Compatibility Assistant.

3-Now click on Enabled then click on Apply and OK then close out of Local Group Policy Editor.

step2
go to services and disable Program Compatibility Assistant Service

step3
restart the pc

step4
go to SQL installation folder and choose edition .

Then run setup.bat

step5
please install sql 2000 sp4 when the installation is done.
NB do not run autorun.exe bc you will get error.

IT WILL WORK BC IT IS WORKING ON MY W7 MACHINE
Talley
Raleigh,NC
talleyouro@hotmail.com
«The light will always dominate the darkness»

answered Aug 29, 2011 at 5:14

Talley's user avatar

TalleyTalley

5615 silver badges6 bronze badges

В данной статье приводится алгоритм установки 1С 7.7 для развертки базы на SQL Server 2000 на операционной системе Windows Server 2008R2 x64 Автор статьи: Дух1984 | Редакторы:
Последняя редакция №7 от 06.05.15 | История
URL: http://kb.mista.ru/article.php?id=943

Ключевые слова: 1C, 7.7, SQL, Server, 2000, 2008R2

Пошаговая инструкция:

(!) Все операции необходимо производить под пользователем «Администратор»!

1. Устанавливаем Windows Server 2008R2 x64

2. Устанавливаем SQL Server 2000 Standart Edition (при установке может ругаться, но впихиваем

насильно)

3. Устанавливаем 1С 7.7 релиз 27

4. Меняем владельца каталогов C:WindowsSystem32 и C:WindowsSysWOW64 на пользователя

«Администратор» (при замене владельца ставим галку «Заменить владельца подконтейнеров и объектов»).

5. В данных каталогах в окне свойств на закладке «Безопасность» обязательно добавляем в список

пользователя «Администратор» и выставляем ему полный доступ.

6. Находим в обоих каталогах файлы sqlsrv32.dll, sqlsrv32.rll, odbcbcp.dll и также как и в

предыдущем пункте для каждого из этих файлов меняем владельца и добавляем «Администратора» с полными

правами.

7. Находим компьютер, на котором установлена Windows XP x86 берем файлы sqlsrv32.dll,

sqlsrv32.rll, odbcbcp.dll из каталога C:WindowsSystem32

8. Заменяем данными файлами существующие в нашей операционной системе файлы (для которых мы сменили

владельца) в обоих (!!!) каталогах: C:WindowsSystem32 и C:WindowsSysWOW64

После данных шагов обычным способом создаются базы данных в SQL формате.

Понравилась статья? Поделить с друзьями:
  • Sql plus скачать для windows 10
  • Sql native client скачать windows 10
  • Sql native client windows 7 x64
  • Sql manager скачать для windows 10
  • Sql lite скачать для windows 10