First glance at SQL Server 2000-database connection

During this time, the student information management system was mainly implemented, so it is inevitable to deal with the database. I have just knocked on five database examples, and I still have a poor understanding of the database, for more information, see.

After installing SQL Server2000, you must first open the server and start the service: Start-allProgram-Microsoft SQL Server-service manager. After you open the Service Manager

 

Click the start button to start the service. The server name on the way is the name of the computer, not the login name. The server name is the same as the login name on different computers. You can change it in the computer properties, services are SQL Server, which are basically the same. If you use them frequently, we recommend that you check the following check boxes to set the service to start at startup.

After the service is started, we continue to open the "query analyzer" in the Service Manager.

 

Here we need to set the authentication method used for connection. I am a little puzzled here. In my tutorials, I usually select "SQL Server Authentication ", every time I select this option, the connection fails, and the first Windows authentication is used, I personally feel that both methods can only pass the identity authentication mark set by the database, as long as the name is attached to the database and then written right, it will be enough to go in, generally, regardless of the identity, if the permissions are insufficient, you can change the permissions in "Enterprise Manager" or add users.

After entering, click "file-open" and find your database file, whose suffix is. SQL, click "execute query" (green). After running, add the database to the Enterprise Manager, as shown in figure

 

 

You can find "Enterprise Manager" at the place where "query analyzer" is opened.

 

 

Expand and you will see the "Database" item. If the file you opened on the "query analyzer" is named "student. if SQL is used, double-click "table" and open all the sub-databases in your database. Right-click a sub-database, as shown in figure

 

 

Select "return all rows" to view the content in your database. After reading this, close it. After opening it, I want to add data to it. I don't know why I always report an error, if you want to add data randomly, what rules do you need to comply with? This is to be further studied.

However, sometimes I don't know why I did not find anything after I open the "Enterprise Manager" and expand the SQL server group after adding the database. I am not very clear about the reason, but I know how to solve it, click "operation"-"create SQL Server Registration" on the toolbar to register the SQL server.

Then, open "Control Panel-performance and maintenance (or system security win7)-management tools (or win7 Management)-Data Source (ODBC )", click Add in "file DSN,

 

 

Click "add" and select "SQL Server". In addition to the server name, select "local". The other steps should be customized. After testing the database, close the database, click the "Configure" button, and the other items will be used by default. In identity authentication, I still use window authentication to pass the authentication. The second item is still passable, but I don't know why, so I chose the first item, and remember to set your database as the default item. The test data can be completed successfully.

I don't know if I am out or another reason. Some teachers suggested that I use SQL of 08 or 13, but I was advised to use 2000 at the earliest, which means 2000 is classic, later, I heard that they are using "08". I am a beginner. Well, no matter how I have chosen 2000, let's start from 2000, I believe it will be easy to get started after the new version is changed.