May 22, 2008 at 8:07 am
Hi
I'm trying to connect to my SQL 2005 db from a visual studio 2005 application using a connection string. The method I use to connect to an SQL 2000 db works but when I try it with an SQL 2005 database I get the following error from the application:
Server Error in '/PoliciesProcedures' Application.
--------------------------------------------------------------------------------
Login failed for user 'PoliciesProceduresUser'. Reason: The password of the account must be changed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'PoliciesProceduresUser'. Reason: The password of the account must be changed.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: Login failed for user 'PoliciesProceduresUser'. Reason: The password of the account must be changed.]
Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack) +899
PoliciesProceduresPresentation.NEASLoginSecure.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2379; ASP.NET Version:1.1.4322.2379
May 22, 2008 at 9:54 am
Just a guess, since I don't have an app ready to test this with, but sounds like the SQL login has "Enforce Password Policy" and "User must change password at next login" enabled.
"Got no time for the jibba jabba!"
-B.A. Baracus
May 27, 2008 at 1:20 am
Yes that was the case, I did not know it was the default setting, many thanks:)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply