Login failed for SA account

Ok, Im going crazy now - I had this working a w ago
Im using the SA account authentication to my test.aspx page. It was working
fine but now I get
Login failed for user 'sa'.
I had no password set on this account by default - how can I check someone
has not changed this password and revert this back to a blank password?
Your help as always is appreciated.
Paul.use Query Analyser to login and test/check.
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Paul King" <kin0363k@.hotmail.com> wrote in message
news:OeOWer5XEHA.2388@.TK2MSFTNGP11.phx.gbl...
> Ok, Im going crazy now - I had this working a w ago
> Im using the SA account authentication to my test.aspx page. It was
working
> fine but now I get
> Login failed for user 'sa'.
> I had no password set on this account by default - how can I check someone
> has not changed this password and revert this back to a blank password?
> Your help as always is appreciated.
> Paul.
>
Can you login using SQL Management Console?
George
My Site - Body Jewelry
"Paul King" <kin0363k@.hotmail.com> wrote in message news:OeOWer5XEHA.2388@.TK
2MSFTNGP11.phx.gbl...
Ok, Im going crazy now - I had this working a w ago
Im using the SA account authentication to my test.aspx page. It was working
fine but now I get
Login failed for user 'sa'.
I had no password set on this account by default - how can I check someone
has not changed this password and revert this back to a blank password?
Your help as always is appreciated.
Paul.
Ok thanks - tried to access the SQL server using the SA account and somebody
has changed the password - how do I reset this back to <blank>?
Regards
Paul.
"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:edlAq05XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> use Query Analyser to login and test/check.
> --
> Curt Christianson
> Owner/Lead Developer, DF-Software
> Site: http://www.Darkfalz.com
> Blog: http://blog.Darkfalz.com
>
> "Paul King" <kin0363k@.hotmail.com> wrote in message
> news:OeOWer5XEHA.2388@.TK2MSFTNGP11.phx.gbl...
> working
someone
>
1. Ask the somebody what they changed it to.
2. If you don't want people messing with the SA account, don't leave it
blank and don't give out the password.
3. Why the heck are you using the SA account to begin with?
Bob Lehmann
"Paul King" <kin0363k@.hotmail.com> wrote in message
news:uo$c645XEHA.400@.TK2MSFTNGP10.phx.gbl...
> Ok thanks - tried to access the SQL server using the SA account and
somebody
> has changed the password - how do I reset this back to <blank>?
> Regards
> Paul.
> "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> news:edlAq05XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> someone
password?
>
most likely, you dont.
Try SQL Administrator, right click, set password
But if the SA account is locked out you are SOL most likely.
Reinstall.
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Paul King" <kin0363k@.hotmail.com> wrote in message
news:uo$c645XEHA.400@.TK2MSFTNGP10.phx.gbl...
> Ok thanks - tried to access the SQL server using the SA account and
somebody
> has changed the password - how do I reset this back to <blank>?
> Regards
> Paul.
> "Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
> news:edlAq05XEHA.2868@.TK2MSFTNGP09.phx.gbl...
> someone
password?
>