DB Master Key - Sql Server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TimHop12
    New Member
    • Nov 2006
    • 24

    DB Master Key - Sql Server

    This is not working with me on SQL Server 2005:


    Code:
    use XDataBase
    CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'
    go
    However it was given on MS site:
    CREATE MASTER KEY (Transact-SQL) creates a database master key in the database.


    Please advice. Thanks.
  • deepuv04
    Recognized Expert New Member
    • Nov 2007
    • 227

    #2
    actually the password must be > 8 chars and contain upper/lower case and numeric/ Non-alphanumeric characters.

    Password = 'password' is used having exactly 8 chars,
    i think this may causing the problem

    Comment

    Working...