Post reply

Remember password is not remember on ever time

  • September 6, 2010 at 10:30 pm

    #225693

    Hi,

    I am using sql server 2008 client while connecting to server i have given the correct password and click on remember password option.But next time i click on connect with same user it throws error like 'login failed for the user.'.

    Any one know the resason please let me know.

    Thanks in anticipation.

  • September 7, 2010 at 12:09 am

    #1217122

    may be some one have revoked your access. please check with your administrator to check if your id still have access or not. 🙂

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • September 7, 2010 at 4:56 am

    #1217242

    Hi Vijayanj

    By default SQL Server does not allow you to save sa password. (Though check box to save password is enabled)

    Try to login as any other SQL user and save password it will work.

    - SAMJI
    If you marry one they will fight with you, If you marry 2 they will fight for you 🙂

  • September 7, 2010 at 6:38 am

    #1217277

    Hi Samji,

    Please dont post wrong information..SQL server Allows to save password for SA login by checking that option.

  • September 7, 2010 at 9:36 pm

    #1217699

    Hi Ratheesh,

    On which version of SQL server did you test this? In SQL 2008 you can not save sa password and MS has confirmed it as bug and they are likely to fix this in next releases.

    Please refer the below link

    http://connect.microsoft.com/SQLServer/feedback/details/124842/remember-password-option-is-not-remembered-in-registered-server-properties

    Nothing personal here please, refer your wrong posting on the below issue.

    http://qa.sqlservercentral.com/Forums/Topic977395-1550-1.aspx

    - SAMJI
    If you marry one they will fight with you, If you marry 2 they will fight for you 🙂

  • September 7, 2010 at 10:42 pm

    #1217713

    COOL_ICE (9/7/2010)

    Hi Ratheesh,

    On which version of SQL server did you test this? In SQL 2008 you can not save sa password and MS has confirmed it as bug and they are likely to fix this in next releases.

    Please refer the below link

    http://connect.microsoft.com/SQLServer/feedback/details/124842/remember-password-option-is-not-remembered-in-registered-server-properties%5B/quote%5D

    I tried in both SQL 2008 and 2008 R2 and I am able to save password without any issue.

    Nothing personal here please, refer your wrong posting on the below issue.

    http://qa.sqlservercentral.com/Forums/Topic977395-1550-1.aspx%5B/quote%5D

    Anyway thanks for the link and its for registered servers i think

    Regarding the post I am asking you whether u sure abt deleting an sql login from SQL Server 2008 while logged with the same log in(Please check I have clearly mentioned SQL login not windows and the post started with deleting an SQL login not windows)

  • September 8, 2010 at 12:06 am

    #1217734

    Hi Ratheesh,

    Post says, SQL login (SA) was disabled and he was not able to login using Windows Authentication since it is deleted by oversight (The way issue raised is bit confusing)

    Anyways, I want to put full stop to this argument 🙂

    - SAMJI
    If you marry one they will fight with you, If you marry 2 they will fight for you 🙂

  • September 8, 2010 at 2:30 am

    #1217777

    🙂

  • September 8, 2010 at 11:22 pm

    #1218368

    Hi,

    Thank you for your reply,As you per this issue,In my system( i am using sql server 2008 client) 'SA' user password is only the problem for remember password,But system able to remember other than 'SA' user.

    But for others system with same (sql server 2008 client) is able to remember 'SA' user password.

    Is this a problem with my system?If so any work arount for this issue?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply