Shulou(Shulou.com)05/31 Report--

This article is about how to change SQL Server 2005. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Server

Authentication mode of 2005 (self-created) author: xiaoluoshan

One | explanation

Every time you connect to SQL, you use a statement like "UID=;PWD=", that is, an empty user name with an empty password. I know what it is, but I don't know why. I would like to ask, where is the user name and password corresponding to the UID=;PWD= statement modified?

There is also an option when configuring a data source using ODBC (choose one of the two), and the master will give you some advice:

How should SQL verify the authenticity of logging in to ID?

1. Use the windows NT authentication of the network ID (w).

two。 SQL authentication with login ID and password entered by the user

If 1.windows logs in, it is verified locally.

2 if you log in in mixed mode, you will define your user name and password.

When using ADO to connect to the SQL database, there is also an option to choose one of the two. The master will give you some advice:

Enter the information to log in to the server:

1. Use Windows NT to integrate security settings

2. Use the specified user name and password

1 is equivalent to

Windows mode login

2 is equivalent to mixed mode landing

You can choose either of the two verification methods. The difference is windows.

NT authentication can only connect to local databases, while SQL authentication can connect to any database.

Second, the problem (this is sun, the problems encountered by yourself are the solutions below)

Question: why do you choose to use the SQL authentication of login ID and password entered by the user to prompt you that the connection failed SQLState'28000'?

My system account is Administrator. I don't have a password.

Solution: change the user authentication mode to mixed authentication

Modify SQL

Server 2005 express is a mixed authentication mode

(the problem that the sa account cannot be logged in)

SQL Server 2005 express is installed with Windows authentication by default. If you want to change it to Windows and SQL,

The mixed mode of the two.

III. Concrete steps

Install MS SQL

Server 2005, the default is Windows authentication mode, at first do not know how to change to SQL Server and Windows mixed authentication mode, had to reinstall, and then choose mixed mode, later found that after the original installation can be modified, and very convenient, Khan …

The first step is to open SQL Server Management Studio, log in to the SQL Server 2005 server with Windows authentication mode, right-click on the server name on the left, and select Properties.

The second step is to select the Security page.

The third step is to change the "server authentication" to "SQL Server and Windows authentication modes" and click OK to save the changes.

Step 4, in the list of servers on the left, select the "login name" directory and set the sa user login password.

Thank you for reading! This is the end of this article on "how to change SQL Server 2005". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.