Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in SQL Server only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Today's Posts
Member List
Calendar
Home
Forum
Topic
SQL Server
DB Master Key - Sql Server
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
TimHop12
New Member
Join Date:
Nov 2006
Posts:
24
#1
DB Master Key - Sql Server
Nov 16 '07, 01:58 AM
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) - SQL Server
http://msdn2.microsoft.com/en-us/library/ms174382.aspx
CREATE MASTER KEY (Transact-SQL) creates a database master key in the database.
Please advice. Thanks.
deepuv04
Recognized Expert
New Member
Join Date:
Nov 2007
Posts:
227
#2
Nov 16 '07, 09:04 AM
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
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment