SQL Server 2005 Installation configuration method graphics and text tutorials perfect compatibility Win7 all versions _mssql2005

Impression, the previous computer is not developed, their own programming experience, because of Microsoft SQL Server version of a large number of different versions of Windows must be installed in the appropriate version of SQL Server, or there may be a compatibility issue, install a Microsoft SQL Server is always very laborious, after loading it up, because Microsoft SQL Server also needs a lot of running resources, playing cards do not want to, finally Microsoft SQL Server left me with a difficult to digest image.

But it now seems that the SQL2005 version of Microsoft SQL Server is nothing at all in 4G, the contemporary era of low distribution.

At the same time the mouth of the goods said compatibility asked, in fact, the body is quite honest to be perfectly compatible with all versions of Win7. The problem is that you are not installing the wrong way.

I. Installation and configuration of SQL2005

1, first of all, the SQL2005 selected here is:cs_sql_2005_dev_all_dvd.iso,sql Server 2005 Development version (DVD) . because of copyright issues, there is no download, like Microsoft other software, a lot of search. After decompression, the inside of the directory is strange, but the Splash.hta is able to click on the run, as exe executable file.

2, according to the number of digits of your system, select the appropriate version, and then come to the picture below, if your computer has never been installed VS, or install vs when not fully installed, the first installation of SQL Native client,sql Native Client installation process is not shown here, Very brain-dead, the only thing to note is, go to the installation component of that step, remember the full selection.

If your computer has ever installed VS, select server components, tools, Books Online, and samples for installation of the SQL Server Core components:

3, in the win7x64 system, to install SQL2005 immediately give you a compatibility warning.

Microsoft's official recommended configuration is win2008+sql2008+vs2008,win7 and WIN2008 is the same structure, that is, WinXP and WIN2003 relationship. But personally feel no need to use such a high version of the SQL2008, after all, SQL Server occupies more resources than MySQL, you upgrade a version, your memory will be less.

At the same time, SQL2005 in win7x64 the slightest compatibility problem, there is also "mouth said do not like, that is like, Mouth said not, that is to" meaning!

4, after the formal system configuration check completely explained everything, and its most suitable system Win2003 all passed, no warning is the same.

Some people say that I, this is clearly open eyes lie, said who did not warn? What the hell is IIS and asp.net? Come on! I do not need to do the development of C # and ASP.net now, what do these two services do? Open, also can not use!

OCD students, you can first, as shown in the following figure, first in the Control Panel-> program and function-> turn on or off the Windows feature, the first of all IIS services open, and then install SQL2005, package you and Win2003 installation SQL2005, is more than a mistake? Not half a warning!

5, then always point to the next step, to select the component to install be sure to put all the components on, so that you don't have to play SQL Server to play what function because you have a component does not install problems, in theory, only "database services" and "Client components" can, but I did not try, this space , this memory will not be saved, the province will not save much.

In general, install SQL Server and install MySQL. "MySQL" MySQL installation, deployment and graphics (click to open the link) do not change the path, loaded C on the C disk, the fear of different paths out of the question!

Also need to pay attention, must enter "Advanced" inside Select "Entire function will install to local disk", do not leave regret ~

6, followed by the next step, go to the "service account" here, remember to choose "Use the built-in System account", you can easily access to SQL Server, the rest of the rights management all say.

The default "domain user" is to play with the Network neighborhood in the local area network, we usually play SQL Server on our own, so we choose the first one.

7, and came to the "authentication mode" here, pay attention to select "Mixed Mode", set up the sa account login password, is the other database root account, a database must have a super administrator, SQL Server is reflected here. This sa password must remember Ah, don't forget. Reloading and uninstalling SQL Server is a hell of a problem!

8, after the "Collation settings" default to Simplified Chinese on the line, there is no UTF-8 for you to choose ~

9, then theoretically, if you have not installed any version of VS, have been pressed the next step is completed. The core of SQL2005 is the SQL Server Management Studio in the Start menu.

If you've installed VS, you're not seeing this stuff. SQL Server Express was selected when installing VS, unfortunately, after SQL Server 2005 installation, you will not find the Management Studio management tool. The SQL2005 installer does not automatically overwrite the components that are already installed.

As a result, it was suggested that IIS must be done well before installing SQL Server to finally install the theory of Visual Studio.

In fact, who first who is not affected. The Start menu does not find SQL Server Management Studio, as long as it's on the website of Microsoft, http://www.microsoft.com/zh-cn/download/details.aspx?id= 8961, the free download of this component is good.

The only thing you need is, when downloading, notice that according to your system version, choose the appropriate installer.

After downloading, the next step on the line, loaded, will appear the Dragon SQL Server Management Studio.

Second, the simple use of SQL2005

1, open SQL Server Management Studio, directly to the default "Windows Authentication" logon, don't be silly very naïve, thought just installed, set up an SA account, select the authentication way to take this sa account login. That's not going to work! Close Test. Here SQL2005 can be used to authenticate logins, are some of their own established account, SA is not counted.

2, after login, the interface is as follows, right click on the database, select "New database." Like other databases, itself will bring a system database, which records a number of table information, is not moving, can only check.

3, when the new database, you fill in the database name directly point to determine.

Although it is clear that SQL Server allows you to choose the path of the database, however, according to the general custom of the large database, the storage location of the database is default, let the system manage well. Casually say, MySQL direct election is not your choice, to change the MySQL database storage path is very troublesome.

At the same time, after the database is established, it hangs in the SQL Server for other programs to call, is also the general custom of the large database. Do not feel like a normal file can be moved and removed.

Don't use Access as an alternative to the Non-mainstream database! Use MySQL, Oracle to analogy on it.

4, after the establishment of the test database, you can create a new query to play the following figure.

First use the following SQL, to build a classic can not be a classic user_info table it!

Use test;
CREATE TABLE [User_info] (
 [id] int PRIMARY key identity (1,1)- 
 -You can set the field from the Add column, note the type int,
 --Identity (initial value, How much each increase), here is a hint to build a 1-per-1 ID column
 [username] varchar,
 [password] varchar 
);

--involving system keywords, to use [] to indicate that this is not a system keyword, is a custom name
--Microsoft's database access and SQL Server do not automatically identify keywords
So, basically, it's OK to add [] to the table name, the column names, not the keywords.

SQL statements are common in different databases, but there are slightly different differences between them.

The above SQL statement, for example, shows the SQL Server's unique self-add column representation. Different from MySQL's auto_increment. At the same time, Microsoft's things, all the columns, table names should be expressed in [] to distinguish their various system reserved keywords, will not automatically identify!

Wonderful topic Sharing: SQL Server Installation Tutorial manual

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.