18456 sql server authentication

$_}It involves several parameters that need to be configured:1, the root directory path of the batch file2. This script supports two kinds of authentication methods: User authentication Windows authentication, as needed to determineThe implementation completion report is as follows:Of course, the most important thing is, if the execution process, a script error

Post a translation FAQ (if I can write this level ...), This step is almost applicable to the most common SQL connection problems. FAQ: Check for SQL connection errors. Q: I have encountered many SQL connection errors. Is there a wizard to solve the connection problems? A: basically, when you cannot connect to your SQL

server uses the "Windows only" authentication method, so you cannot use SQLServer login account (such as SA) to connect. The solution is as follows:　　1. Use the enterprise manager on the server side and select "use Windows Authentication" to connect to SQL

the word "Before" (Before Upgrade) must be corrected Before the SQL Server can be upgraded. 5. Enter the Instance name. Enter an Instance name or select an instance from the drop-down list to select an existing instance. 6. Select the authentication type: Windows authentication or

installed and then reports as an error status. 4. In the report, the State in which the word "before" (pre-upgrade) is in the in-fix (when fixed) column must be corrected before you can continue to upgrade SQL Server. 5. Enter the instance name. If you enter an instance name or select an instance from the Drop-down list, you can select an existing instance. 6. Select

Many people SQL is not standardized, resulting in a variety of problems or long time, the password to forget, how to do? Re-installed?Inverse days take a few more common things, the first is a variety of settings of the problem: (my home is a simple version, you develop the best Enterprise version) 1, first you see your Server service open? method One:win+r-->services.msc--> Select SQLExpress (instance name

select Browse file. In the dialog window for select data destination (Choose a destination), select Microsoft OLE DB Provider for SQL Server. Select the database server again and click the authentication mode you want. In the dialog window for specify table backup or query (specify table copy or query), click Copy T

, select the authentication mode. There are two options, namely, Windows Authentication mode or Mixed mode (Windows and SQL Server Authentication). In Windows Authentication mode, only Windows accounts can have permission to log o

above checks, the cause of Error 1 can basically be ruled out. Next we will describe in detail how to solve Error 2. When you try to use sa in the query analyzer to connect to SQL Server, or use sa in the Enterprise Manager to create a new SQL Server registration, you will often encounter the error message 2. This err