Set Microsoft SQL Server Management studio express-use SQL to verify Logon (for example, Log On As A sa user)

Set Microsoft SQL Server Management studio Express
Use SQL to verify Logon (for example, Log On As A sa user)

Many users who use SQL Server 2005 express for the first time can use SQL to verify logon. For example, if an error occurs when using the SA account, the solution is as follows:

Environment:

Microsoft SQL Server Management studio express 9.00.2047.00

Microsoft Data Access Component (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)

Microsoft MSXML 2.6 3.0 4.0 5.0 6.0

Microsoft Internet Explorer 6.0.2900.2180

Microsoft. NET Framework 2.0.50727.42

Operating System 5.1.2600

Right-click the server and select "properties" from the menu ". In the following dialog box, select "SQL Server and Windows Authentication mode ".

Click "security" à "login name, and double-click the database username to change the logon attribute, for example, SA. The following dialog box is displayed, and select" status ", change it to the following format (you may need to set the SA password on the "General" page ).

So far, you can use SQL verification.