Wednesday, October 21, 2015

Machine related configuration during SSRS DB creation

declare @p5 int
set @p5=NULL
exec AnnounceOrGetKey @MachineName=N'VMMSQL01',@InstanceName=N'SE',@InstallationID='1E40A75C-0BE4-4D7C-A0AC-F0746AC8BC9B',@PublicKey=0x0602000000A400005253413100080000010001008D3BDCD0EEC49331A789635C801D03D655D47209A1B950842F1E5A377C151DE87D85C93DF5CDA47F60F06B68D5713B9AFE8E6DC31FF473888C6DFEDE810D4339FD24349E274DF4DCF5295CC75E3DB1064E3F01B1DE49DB4196CA4B342941FD0AF273B11A575D7B3721460D07C56B30AB082E3C07A6F70FC789EF7C14AFB57D7B2B4E506FA5DE32B7586CF813A19D6AADCE36D341596E645840AB3489B7AE91A70E4E827CB160388DF97B76E2171D5D771D1099A9C40EE2E38359B2D369C4B554215368AA8C909327397E60310FFB900C0C7DDF23144B0F33DCA2AC51D12EBAC014419E1616DD2F3997660C95D9602312E97E5186CBD912659A6B9197ADC8AEF2,@NumAnnouncedServices=@p5 output
select @p5
go
exec SetKeysForInstallation @InstallationID='1E40A75C-0BE4-4D7C-A0AC-F0746AC8BC9B',@SymmetricKey=0x010200000366000000A40000237C083E606AE3E4B5D3D2A181B74FE287BB57603AEBC7BD9297020A42825D57304A6983D49EB729FF2A39CD0D86E87401FEA56CAE657C0446910771B23FCFE64B3FC08FD1DF6D547CDEDC3D1676B3D254532F363FABD395ECD93ECD6F202C4FD5DA060C6D4310402281834E41F112CAFF7DB05F90955652968F7E565E483675101DAFEE9E932C9425DFE58FB886FD3FC162B75892CAFD7EBF92D37D25CFB84530437541A014A88AA1D3F7D6DCB9CEF4A68902DBE88142D50A4ED0462B9095F8B1397EC2F3DD9BCF182A9ABDD943F4DE9DE4613EED31E10B2E17B73282973AD0F9048DCCB68C64DBE7B9D95B0D15750C948E6E4303BAE7BAD80B3937A5E4C298,@PublicKey=0x0602000000A400005253413100080000010001008D3BDCD0EEC49331A789635C801D03D655D47209A1B950842F1E5A377C151DE87D85C93DF5CDA47F60F06B68D5713B9AFE8E6DC31FF473888C6DFEDE810D4339FD24349E274DF4DCF5295CC75E3DB1064E3F01B1DE49DB4196CA4B342941FD0AF273B11A575D7B3721460D07C56B30AB082E3C07A6F70FC789EF7C14AFB57D7B2B4E506FA5DE32B7586CF813A19D6AADCE36D341596E645840AB3489B7AE91A70E4E827CB160388DF97B76E2171D5D771D1099A9C40EE2E38359B2D369C4B554215368AA8C909327397E60310FFB900C0C7DDF23144B0F33DCA2AC51D12EBAC014419E1616DD2F3997660C95D9602312E97E5186CBD912659A6B9197ADC8AEF2
go

exec GetMyRunningJobs @ComputerName=N'VMMSQL01',@JobType=1
go

image

image