Skip to main content
Inspiring
November 18, 2008
Question

MS Sql server 2005 - Sa account locked out

  • November 18, 2008
  • 2 replies
  • 1626 views
hi Folks,

I'm trying to register a new datasource in cfadmin but I get the following error, can anyone help?

Thankyou

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.
This topic has been closed for replies.

2 replies

Inspiring
November 18, 2008
A quick google search turns up a number of suggestions. Though using the "sa" account is not recommended.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=306429&SiteID=1
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=967970&SiteID=1
Inspiring
November 18, 2008
matthisco wrote:
> hi Folks,
>
> I'm trying to register a new datasource in cfadmin but I get the following
> error, can anyone help?
>
> Thankyou
>
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login
> failed for user 'sa' because the account is currently locked out. The system
> administrator can unlock it.
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver][SQLServer]Login failed for user 'sa' because the account is currently
> locked out. The system administrator can unlock it.

http://www.google.com/search?hl=en&client=safari&rls=en&q=Login+failed+for+user+%27sa%27+because+the+account+is+currently+&btnG=Search

==>

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=306429&SiteID=1

Please use google first.

--
Mack