Friday, February 24, 2012
[Help]SQLServer Logon Failure ....
I have a SQL server which version is SQL Server 8.0 and I want to change
this server's windows logon password. But, when I did then restart sql
service, I get this error message :"SQL Server Logon Failure". Is there any
way to change this password?
Registration properties : Windows authentication
Authentication mode : SQL Server and Windows
Best Regards,
AresChange the service login info - check
http://www.techgroup21.com/subpage.asp?subnavID=114.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"ares" <aresATasia-minor.info> wrote in message
news:uRCSkJkxEHA.2580@.TK2MSFTNGP10.phx.gbl...
> Hi!
> I have a SQL server which version is SQL Server 8.0 and I want to change
> this server's windows logon password. But, when I did then restart sql
> service, I get this error message :"SQL Server Logon Failure". Is there
any
> way to change this password?
> Registration properties : Windows authentication
> Authentication mode : SQL Server and Windows
> Best Regards,
> Ares
>
>|||Thanks for your help.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OiePlJmxEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Change the service login info - check
> http://www.techgroup21.com/subpage.asp?subnavID=114.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "ares" <aresATasia-minor.info> wrote in message
> news:uRCSkJkxEHA.2580@.TK2MSFTNGP10.phx.gbl...
> any
>
[HELP]passwords
for example i will set the password as chicken
http://img515.imageshack.us/my.php?image=chickenqs6.gif
then i press ok and it seems like it works i open it right away and
http://img295.imageshack.us/my.php?image=notchickenao0.gif
^^clearly not chicken......
then,ontop of that when i open the login name is a query script its some 15 character password that everytime u open in script the code changes..
http://img401.imageshack.us/my.php?image=screenhunter04jan062317zu0.gif
any help would be greatly appreciated
this is the normal behaviour. u can not see or know the password once it is been set. What u get while scripting is only a arbitary value. This is for security purpose. By just counting the number of '*' you can not say that it is not Chicken. There is nothing to worry....
Madhu
|||is there a way i can make it set the password i want without encrypting it because i need that password to stay(example chicken) the same if not i cant use it