Viewing 15 posts - 3,376 through 3,390 (of 9,244 total)
Jake Shelton (4/10/2014)
if memory serves, without the 2K5 step, the hashing will fail as it has changed base algorithm between 2000 and 2005.
Step not required. The algorithm between 2008 and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 1:32 pm
Jake Shelton (4/10/2014)
My question is whether I need to move the logins to a 2k5 box as an interim step before relocating again to 2008.
No you don't and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2014 at 6:14 am
defyant_2004 (4/8/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 3:01 pm
The database is encrypted a page at a time and on a large database can take some time. The database is still available for normal access, however maintenance is disabled...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:56 pm
Try this
SET NOCOUNT ON
DECLARE @sql NVARCHAR(MAX)
SET @sql = ''
SELECT @sql =
'--======================================================================================' + CHAR(10) +
'--==== IMPORTANT: Before executing these scripts check the details to ensure they ===='...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:54 pm
is the schedule enabled?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:48 pm
sourav_1002001 (4/9/2014)
"Cannot show requested dialog.
Additional information:
Cannot show...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:38 pm
as detailed here
Transparent Data Encryption
The following operations are not allowed during initial database encryption, key change, or database decryption:
•Dropping a file from a filegroup in the database
•Dropping the database
•Taking the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:35 pm
The filestream group is just create on a location on an NTFS volume, there's no reason why you can't use mounted volumes. Have a read through this[/url] for info on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:24 pm
Jake Shelton (4/9/2014)
Is this feasible via the SSIS Transfer Logins task?? I've read a lot of articles talking about doing this scriptually instead, now I'd far rather have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 5:40 am
The login Amtpl is already mapped to a different database user. Use the following to identify the logins current database user account
use [yourdb]
selectd.name as DBUsername
, s.name as Loginname
from sys.database_principals d
inner...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 5:34 am
No, the cluster service should be left as is. The issue is because the Cluster Name object does not have permission to create Virtual Computer Objects. Either pre stage them...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2014 at 9:20 am
dajonx (4/7/2014)
- The cluster identity '2012CLUSTER$' has Create Computer Objects permissions. By default all computer objects are created in the same container...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2014 at 5:30 am
free_mascot (4/6/2014)
From the security and connectivity perspective it would be good to keep sql servers on domain.
Not necessarily, security can still be implemented effectively on workgroup computers, it's just harder...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2014 at 5:24 am
DKG-967908 (4/7/2014)
1. But what the Microsoft best practice says about this.
2. If we consider from security point of view - SQL server should be on domain...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2014 at 9:48 am
Viewing 15 posts - 3,376 through 3,390 (of 9,244 total)