none
sql security question??

Answers

  • You cannot know, but you you can reset the pass with new one
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Stephanie Lv Tuesday, May 24, 2011 7:05 AM
    Tuesday, May 17, 2011 11:28 AM

All replies

  • You cannot know, but you you can reset the pass with new one
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by Stephanie Lv Tuesday, May 24, 2011 7:05 AM
    Tuesday, May 17, 2011 11:28 AM
  • Please return the output of the query:

    SELECT DB_NAME(database_id) AS DatabaseName, * FROM sys.dm_database_encryption_keys


    בברכה, יובל סיני, יועץ טכנולוגיות, אתר אינטרנט: http://www.ben-shushan.net
    Tuesday, May 17, 2011 11:36 AM
  • Yuval shalom

    I am not sure how your query can help him... it could return empty set as well... There is NO way in SQL Server recover 'sa' password (perhaps any third party tools)


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, May 17, 2011 11:52 AM
  • There is no way to retrieve the sa password. You can reset it as Uri said.
    Cheers!! Kalps
    Wednesday, May 18, 2011 4:54 AM