Re: application roles and strong passwords

Thanks Sue, I know that a better password would be preferred. But its
a difficult option for us.

Thanks for the tip on the sp_addapprole. It should get us through
this.

Ron


On Apr 16, 11:26 pm, Sue Hoegemeier <S...@xxxxxxxxxxxxx> wrote:
Yes...they should all be strong passwords. Using strong
passwords would be the first option.
If for some reason you can't and need time until you can use
strong passwords, One way around it is to use the old stored
procedures which are only there for backwards compatibility.
sp_addapprole, sp_approlepassword, etc.

-Sue

On 16 Apr 2007 18:15:02 -0700, rjvanzanten



<rvanz...@xxxxxxxxxxxxxxxxxxx> wrote:
Hi,
we are testing upgrading an application to run SQL 2005. One issue we
are having is that the one application role they have has a 'weak'
password. We are trying to change the password and it seem to be
inforcing the 'strong password policy from windows. I cannot see a way
around this. Do all application roles need strong passwords? Is there
any way around it?- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: Suggestions, plz, to get boot-drive up and running again?!?
    ... Note - there are two "Sue B"'s posting for help here. ... My sole internal hard drive failed; with repeated applications of chkdsk, I was able to regain a limited dos-view of the entire disk (via the "r" option when you boot winXP from the original install disc). ... Yet in spite of the fact that I can cruise through the entire disk now via crippled-DOS, I cannot boot into Windows (I get the msg "You can attempt to ... ...
    (microsoft.public.windowsxp.hardware)
  • Re: q re posted multi-boot/partition utilities recs
    ... Sue -- Which version of Partition Magic do you recommend? ... --I want to set up for Windows XP as main OS, ... are there any others that come to mind that might offer ...
    (microsoft.public.windowsxp.configuration_manage)
  • Re: "Your Copy of Windows Is Not Genuine" message popping up
    ... I finally downloaded and successfully ran the Windows Validation ... Tool from Microsoft and got the end message that I was running a valid copy of ... sue them and see where it gets you. ... If it were a crime to offend others, one would have a case to sue all ...
    (microsoft.public.windowsxp.general)
  • Re: Login failed for ServerGuest
    ... a Windows 2000 machine from my XP machine, it tries to log me in as ... For SQL ... although Windows Authentication is more secure than ... >> Thank you, Sue! ...
    (microsoft.public.sqlserver.connect)
  • Re: Vista licence: punishment for frequent upgraders?
    ... just unpleasant for American consumers who have to pay for windows. ... government hasn't responded appropriately. ... if they will sue again even after MS has released everything ... Subject: Vista licence: punishment for frequent upgraders? ...
    (alt.comp.hardware.pc-homebuilt)