Viewing 15 posts - 4,081 through 4,095 (of 9,244 total)
All detailed here[/url] and here[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 4:46 pm
Jai-SQL DBA (6/10/2013)
------ --------------
masterEncrypted by SMK
namepvt_key_encryption_type_descissuer_namesubject
---- ---------------------------- ----------- ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 4:40 pm
Ok so have a stab, what can you learn from the results?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 10:07 am
What do the following queries return?
selectname
, CASE is_master_key_encrypted_by_server
WHEN 0 THEN 'Encrypted by password only'
WHEN 1 THEN 'Encrypted by SMK'
END AS KeyEncBySrvr
from sys.databases
where name = 'master'
selectname
, pvt_key_encryption_type_desc
, issuer_name
, [subject]
from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 9:06 am
A typical create master key command
USE master
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'
A typical create certificate command
USE master
CREATE CERTIFICATE MyServerCert WITH SUBJECT = 'My DEK Certificate'
A typical create database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 7:47 am
The database master key is independant of the certificate. The master DMk is merely used to protect the private key while the cert is stored on the SQL server.
The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 6:58 am
My 3 part guide is a good source, they're linked below
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 6:29 am
Vlad-207446 (6/10/2013)
I don't get it.
Read my article it will expalin in more detail.
Vlad-207446 (6/10/2013)
stop...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 6:24 am
in asynchronous mode the only way to perform a failover between partners is to use the following
ALTER DATABASE [somedb] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
As Lynn says, data could be lost so a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 4:49 am
detailed here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 4:43 am
rajborntodare (6/7/2013)
"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"
Open the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 4:27 am
See my article[/url] here on SSC for more detailed info.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2013 at 12:09 am
Check the share "testing_backup". On the properties go to the share permissions tab and set permission for sql service accounts for both instances (if not the same).
Then go to security...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2013 at 12:00 am
Deque (6/6/2013)
Of course, that requirement is one of the major reasons why BizTalk Server gets it's own instance in our environment.
If an app logon absolutely requires sysadmin for support purposes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2013 at 10:17 pm
Also once you have installed an instance name as a clustered instance you cannot install a stand alone instance of the same name into any node in the cluster, whether...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 5, 2013 at 1:44 pm
Viewing 15 posts - 4,081 through 4,095 (of 9,244 total)