Sql (SQL Server 2005) 32-bit&64 bit

SQL (SQL Server 2005) 32-bit&64 bit official version is a new database software launched by Microsoft in 2005. The full name of the sql2005 data cool software is Microsoft SQL Server 2005. Although the version of the database software is constantly upgraded and more functions are derived, many programming users like it.

Introduction to sql (SQL Server 2005) software

The Microsoft SQL Server 2005 data engine is the core of the enterprise data management solution. In addition, Microsoft SQL Server 2005 combines analysis, reporting, integration, and notification capabilities. This enables your enterprise to build and deploy cost-effective BI solutions to help your team Dashboard、Web services And mobile devices push data applications to all areas of business.

Tight integration with Microsoft Visual Studio, Microsoft Office System, and new development kits, including Business Intelligence Development Studio, makes Microsoft SQL Server 2005 unique. Whether you are a developer, database administrator, information worker or decision maker, Microsoft SQL Server 2005 Can provide you with innovative solutions to help you benefit more from data.

SQL (SQL Server 2005) software features

NET Framework Host

XML technology

　　ADO. NET2.0 version

Enhanced security

Enhanced performance of Transact SQL

SQL Service Mediation

notification service

Web Services

Reporting Services

Full text search enhancements

SQL (SQL Server 2005) software features

Reporting Services

With SQL Server 2005, report service can provide report control, which can be released through Visual Studio 2005.

SQL Service Mediation

SQL service mediation will provide a distributed and asynchronous application framework for large-scale business applications.

NET Framework Host

With SQL Server 2005, developers can create database objects by using similar languages, such as Microsoft's Visual C #. net and Microsoft's Visual Basic. Developers will also be able to create two new objects -- user-defined classes and collections.

XML technology

Extensible Markup Language (a subset of standard generic markup language) is an important standard when using local networks and the Internet to walk data between different applications. SQL Server 2005 will support storing and querying XML files.

　　ADO. NET2.0 version

From new support for SQL classes to multiple active result sets (MARS), ADO in SQL Server 2005 NET will promote the access and manipulation of data sets to achieve greater scalability and flexibility.

Enhanced security

The new security mode in SQL Server 2005 separates users from objects, provides fine grainAccess access, and allows greater control over data access. In addition, all system tables will be implemented as views, giving greater control over database system objects.

Enhanced performance of Transact SQL

SQL Server 2005 provides new language functions for developing scalable database applications. These enhanced capabilities include error handling, recursive query, relational operators PIVOT, APPLY, ROW_NUMBER, and other data column ranking functions.

Introduction to SQL (SQL Server 2005) Functions

Based on the powerful functions of SQL Server 2000, SQL Server 2005 provides a complete data management and analysis solution, which will help organizations of different sizes:

1、 Build, deploy, and manage enterprise applications to make them more secure, scalable, and reliable.

2、 Reduce the complexity of developing and supporting database applications, and maximize IT productivity.

3、 It can share data among multiple platforms, applications and devices, making it easier to connect internal and external systems.

4、 Effectively control costs without sacrificing performance, availability, scalability, or security.

SQL (SQL Server 2005) Considerations

Some users indicated that they could not use it, which may be due to the server synchronization problem. You can download it here. They are all common server software.

Self made SQL 2005 32bit Enterprise Edition (WIN 2003)+Development Edition (WIN XP) are both simplified Chinese versions of 2CD

Only a few bootstrap files are added to the root directory. The original file has not been modified. The 32-bit Enterprise Edition and the Development Edition are integrated together. Both XP (SP2) and 2003 can be installed

In addition, there are problems with the attached installation. The most common problem is that the assembly cannot be installed and configured in the com+directory. Error: - 2146233087

SQL (SQL Server 2005) Installation Instructions

1. First, download the official version of SQL (SQL Server 2005) from the PC download network. After decompression, the directory inside is strange. However, splash. hta can be clicked to run, just like an exe executable.

2. Select the corresponding version according to the number of bits in your system, and then you will see the picture below. If VS has never been installed on your computer, or it has not been completely installed when installing VS, you should first install SQL Native The installation process of the client and SQL Native Client will not be shown here. It is very stupid. The only thing to note is that you should remember to select all components when you go to the installation step.

If VS has been completely installed on your computer, select "Server Components, Tools, Books Online and Samples" to install the core components of SQL Server:

3. In Win7x64 system, if you want to install SQL 2005, you will be given a compatibility warning immediately.

The configuration officially recommended by Microsoft is WIN2008+SQL2008+VS2008. WIN7 and WIN2008 have the same structure, that is, the relationship between WINXP and WIN2003 is the same. However, I don't think it is necessary to use such a high version of SQL2008. After all, SQL Server takes up far more resources than MYSQL. If you upgrade to a new version, your memory will be less.

At the same time, SQL2005 has no compatibility problem with Win7x64 at all. Some of them mean "if you say you don't like it, you like it, and if you say you don't want it, you want to"!

4. After that, the serious system configuration check completely explained everything, and its most suitable system, Win2003, passed without warning.

Someone said I was lying with my eyes wide open. Who didn't warn me? IIS and ASP NET is what ghost? c'mon! I don't need C # and ASP NET development, what are these two services doing? It doesn't work!

Students with obsessive-compulsive disorder can first open all IIS services and then install SQL2005 in Control Panel ->Programs and Functions ->Open or Close Windows, as shown in the figure below. You can install SQL2005 in the same way as Win2003. What is more wrong? No warning!

5. After that, click Next to select the "components to install". Be careful to install all the components to avoid playing SQL The reason why the server plays any function is that you haven't installed a component. In theory, only "database service" and "client component" can be installed, but I haven't tried. This space and memory will not be saved, and it will not save much.

In general, installing SQL Server is the same as installing MySQL. Don't change the path of [MySQL] MySQL Installation, Deployment and Graphical (click to open the link). Install the C disk just as the C disk, for fear of problems with different paths!

It is also important to note that you must go to "Advanced" and select "The entire function will be installed on the local disk", without regret~

6. After that, always click Next to go to the "Service Account". Remember to select "Use the built-in system account". You can easily access SQL Server first, and the rest of the permission management is easy to say.

The default "domain user" is related to the network neighbors in the LAN. We usually play SQL Server alone, so we choose the first one.

7. When you come to the "Authentication Mode", please select the "Mixed Mode" and set the login password of the sa account, which is the root account of other databases. A database must have a super administrator, and SQL Server is represented here. Remember the sa password. Don't forget it. Re installing and uninstalling SQL Server is a deadly trouble!

8. The later "Collation Settings" is in simplified Chinese by default, and there is no UTF-8 for you to choose from~

9. In theory, if you have not installed any version of VS, you can finish it by pressing the next step.

Sql (SQL Server 2005) 32-bit&64 bit update log

1. Fixed other bugs;

2. Optimized software compatibility

Recommended by editor: The official version of SQL Server 2005 combines analysis, reporting, integration and notification functions. This website also provides MySQL-Front Waiting for you to download.