Post reply

PASSWORD

  • July 23, 2009 at 12:57 pm

    #208441

    Some one can help me " How to get database login name and password

    bcoz someone change athentication

  • July 23, 2009 at 1:42 pm

    #1029250

    Login names are easy. Query sys.sql_logins. Passwords, on the other hand, are stored hashed within the master database and are not queryable.

    Can you explain your problem in more detail?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2009 at 5:31 am

    #1029569

    Unless you've changed the default security on the machine (a good idea to do), you should be able to access the instance by being added to the local admin group on the server.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 24, 2009 at 6:05 am

    #1029583

    True as long as the OS isn't Vista or Server 2008. In both of those, builtin\admins no longer gets added as sysadmin. Also the case on all SQL 2008 installations.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2009 at 6:12 am

    #1029591

    Oh, right. I keep forgetting the MS finally got smart. I'm so used to having to pull that access...

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • July 24, 2009 at 6:18 am

    #1029596

    I keep running into people who have SQL 2005 on Vista, somehow missed the provisioning tool that launches at the end of the SP2 installation and then can't log into the SQL Server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 6 (of 6 total)

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