Shulou(Shulou.com)06/01 Report--

I. installation of SQL Server and SSMS

1. Installation of SQL

Download address: SQL Server.

You can enter the download address and choose Developer or Express.

SQL Server 2019 Developer is a full-featured, free version licensed to be used as a development and test database in non-production environments.

SQL Server 2019 Express is a free version of SQL Server that is ideal for the development and production of desktop, Web, and small server applications.

The basic installation is used by default.

Choose the installation path, the SQL is relatively large, so it is best not to put C disk. Then just wait for it to be installed.

2. Installation of SSMS

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure from SQL Server to Azure SQL databases. SSMS provides tools for configuring, monitoring, and managing SQL Server and database instances. Use SSMS to deploy, monitor, and upgrade data-tier components used by applications, as well as generate queries and scripts.

Use SSMS to query, design, and manage databases and data warehouses on your local computer or in the cloud, no matter where they are located.

Download address: SSMS

Next, you can install by default and choose your favorite directory to install.

Second, the connection of SQL Server

After installing SSMS, it will be such an interface when you open it. Next, show how to connect to the local SQL.

Server type: select the database engine server name: generally fill in the ip address, if the connection is local, it will display a host name by default, or use this. Or write localhost or 127.0.0.1, the easiest way to write a.. Authentication: there are two types, one is SQL Server authentication, the other is Windows authentication. Windows authentication: you don't need to fill in a user name or password, but there is a requirement that you log in to this computer. SQL Server authentication: this login method is generally used in development. You need an account password for a database.

However, it won't work when logging in with sa at first, so we have to choose to log in with Windows authentication to change some settings.

After logging in using Windows authentication, select Security-> login name in the user manager. Double-click to open sa.

If you don't know the password or forget it, you can set the login password here.

Select the status, as shown in the figure, change the setting to grant and enable

Right-click the server to select properties to open

Select security and change the server authentication mode to SQL Server and Windows authentication mode. To change this configuration, you need to restart SQL Server to take effect. It is easiest to restart the system, or right-click on this computer-> Administration-> Services and applications. Find SQL Server and right-click to restart.

Log in to the database with SQL Server authentication.

After selecting the new query, you can use the query statement of SQL to operate.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.