SQL Server 2005 database creation and login user graphic tutorial

This document describes how to create a database and a logon user in SQL Server 2005.

Create an SQL Server 2005 database

As shown in the figure: click create database to pop up. In the following window, create a database.

Enter the corresponding data as shown in the figure. You can configure the database name without making any guesses. The owner can select the default one, we can also choose to set the size and growth space of database files and log files, as well as the storage path of the database, but you can also use the default.

Create a MSSQL2005 login account

Expand security in the left-side menu-select a login name and right-click to create a new login name

Note: Instead of selecting security in the database, you should choose server security. Fill in the login name and SQL Server authentication password as shown in the following figure. Check the force password policy and select the created database by default.

Map users by selecting user ing items on the menu.

Step 3: Grant the login name access and related permissions to select the database, find the security-user in the database, right-click the user, and choose Properties to set permissions.

 

 

In this way, you can use the newly created SQL server login account to manage the newly created database.

The user who created the database cannot log on to sql2005.

The customer has a computer for SQL 2005 Express. I don't know the sa password. I can open the database through windows authentication.
After creating a user name, I quit windows authentication. When you use your username to log on, SQL 2005 always rejects logon and prompts Untrusted Links.
Why?

Reply:

Change the verification mode from "windows only" to "windows and slqserver"

The first mode is "Windows only". This mode only allows users with trusted Windows NT accounts to log on. It is the default security mode of SQL Server and a safer option, the prerequisite for a user to log on to SQL Server is that the user logs on to the Windows operating system using the Windows NT Domain account.
The other is the "SQL and Windows user authentication" mode, which is to create a login user in SQL Server, all Windows-based users only need to use this SQL account to perform standard SQL logon.

1. You should first change it to "SQL and Windows user authentication" hybrid logon mode.
2. Log on with the sa or administrator account, add a user, Grant corresponding permissions, and then use this user to log on

Sql2005 how to create a separate login account for a database

Suppose there is a database Database. How can I create a new login name and only log on to this database? And sa cannot log on to db? For details, thank you.

Answer:

Sa cannot log on to the user database. ms SQL Server cannot be used because SQL Server cannot delete the sa account.
If you really want to implement this function, please consider using Sybase SQL Server 11 or Sybase ASE 12.5, which allows the user account to delete the SA account, of course, at your own risk, for example, you need an account to inherit SA permissions and complete SA work.
In addition, because SQL Server is developed based on Sybase SQL Server, it is similar to Microsoft SQL Server in management and easy to use.