Solution for SQL Server 2008 User NT AUTHORITY\IUSR Logon failure _mssql2008

User ' NT authority\iusr ' login failed.

In fact, either the username or password is incorrect, or the user is unable to log on to SQL Server 2008. A step-by-step analysis.

1, first ASP connection SQL Server 2008 database should have no problem.

Before I used a variety of methods, linked to the database, in fact, Links 2000 and 2005, 2008 no difference

It is to be noted that:
DataServer = "127.0.0.1"
DataServer = "(local)"
It's all available.

Connstr= "Driver={sql server};server=" "&dataserver&"; Uid= "&datauser&"; Pwd= "&databasepsw&";D atabase= "&databasename
Connstr= "Provider=sqloledb;data source= (local); uid=" &datauser& ";p wd=" &databasepsw& ";d atabase=" &databasename

2. In SQL Server Management Studio, as in SQL Server 2000, you need to create a login username first in the security > login name .

It's also important to note that when you create a new user

The Enforce password policy in SQL server2008, and there are times when logon failures occur.

Login failure and password policy is not much of a relationship, the password policy is how long your password must be, what constitutes such a limitation is to improve the security of the password

And then in to the specified database security user

3. When Must_change is on (on), the Check_policy and check_expiration options cannot be set to OFF (off)

SQL2008 Error: When Must_change is on, the Check_policy and check_expiration options cannot be set to OFF.

"Enforce password expiration" has been removed from database user management!
If the "Enforce Password policy" Hook also removed, the following error occurred!
When Must_change is on, you cannot set the Check_policy and Check_expiration options to OFF.

Under normal circumstances, the user: "Delete the Rebuild" on it. Do not trust the students can refer to the following methods, I have not tried.

Today encountered an error, a few days ago in SQL Server 2005, the new account today ASP connection is not connected, ASP display error as "* * * must modify login password * * *", but with Windows account into SQL Server 2005 Manager in the property way to modify the password is still invalid, suddenly found that the attribute that has a "Enforce password Policy" is selected by default, must be this caused.

SQL Server 2005 canceling the Enforce password policy error: 15128 workaround

Cancel "Enforce Password Policy" Click Confirm but eject error "* * * * * can not set check_policy and check_expiration option to OFF error 15128" Cancellation failure, depressed, Baidu, found that the solution is very little, and finally found a way to test through, The following are the specific steps.

1, into the SQL Server 2005 Manager-new query input "Alter login login with password= ' new password ';" "Change to your own corresponding login name and new password-execute.
2, and then open the login name of the property, cancel the "Enforce Password policy" hook-confirm, OK ~

Studied for half a day, had to use

ALTER Login Login with password= ' new password ';

Change the password of this account first!

This is to change the password of the login as SA, feel this option let login after login to change their password, I tried the bottom can not login Ah, is prompted to change the password just.

How do you set up your password in SQL Server by logging on to your Windows server account and then changing your password?

In fact, these problems are generally the case.