Home
%3CLINGO-SUB%20id%3D%22lingo-sub-953955%22%20slang%3D%22en-US%22%3EBulk%20Register%20with%20SQL%20VM%20Resource%20Provider%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-953955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EMany%20of%20you%20a%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ere%20running%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eworkloads%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20on%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fservices%2Fvirtual-machines%2Fsql-server%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ESQL%20Server%20on%20Azure%20Virtual%20Machines%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20(SQL%20VM)%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Etoday%20to%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eleverage%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ecloud%20agility%2C%20elasticity%20and%20scalability%20benefits.%20SQL%20VM%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Edifferentiates%20by%20allowing%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Efull%20control%20on%20the%20OS%2C%20VM%20size%2C%20storage%20subsystem%20and%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eoffering%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-server-iaas-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Efree%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emanageability%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eservices%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E.%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EIf%20you%20choose%20to%20self-install%20SQL%20Server%20on%20Azure%20Virtual%20Machines%20instead%20of%20choosing%20a%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-server-iaas-overview%23get-started-with-sql-vms%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Epreconfigured%20SQL%20Server%20image%20from%20Azure%20Marketplace%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20you%20should%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-register-with-rp%3Fbranch%3Dpr-en-us-80472%26amp%3Btabs%3Dazure-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Eregister%20with%20SQL%20VM%20Resource%20Provider%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20(SQL%20VM%20RP)%20for%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20cost%20savings%20with%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-ahb%3Ftabs%3Dazure-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Esimplified%20license%20management%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20and%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-server-iaas-overview%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Efree%20SQL%20Server%20manageability%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eservices%3C%2FSPAN%3E%20%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3Elike%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-automated-backup-v2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Eautomated%20backup%20%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-availability-group-cli%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Eautomated%20High%20Availability%20with%20Always%20On%20AG%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-automated-patching%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Eautomated%20patching%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20and%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ftechcommunity.microsoft.com%252Ft5%252FSQL-Server%252FAnnouncing-Performance-Optimized-Storage-Configuration-for-SQL%252Fba-p%252F891583%26amp%3Bdata%3D02%257C01%257CMine.Tokus%2540microsoft.com%257Cce9ee2c00f1b48f232f208d75818a216%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637074735128459609%26amp%3Bsdata%3D%252BZQrFbjvhgNMChoHVPYCTYs13YcTVS9xaON54yIfB60%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Eperformance%20optimized%20storage%20configuration%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%20%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EToday%2C%20w%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ee%20are%20enabling%20a%20new%20way%20of%20registering%20with%20SQL%20VM%20RP%20for%20customers%20running%20many%20SQL%20Server%20instances%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eon%20Azure%20VMs.%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-bulk-register-with-resource-provider%3Fbranch%3Dpr-en-us-92680%26amp%3Btabs%3Dazure-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EBulk%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Eregistering%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%20with%20SQL%20VM%20RP%3C%2FSPAN%3E%3C%2FA%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eis%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eusing%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sqlvirtualmachine%2F%3Fview%3Dazps-2.8.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Enew%20Azure%20power%20shell%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emodules%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20to%20automate%20registering%20with%20SQL%20VM%20RP%20for%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ea%20list%20of%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esubscription%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Es%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-bulk-register-with-resource-provider%23full-script%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EThe%20scrip%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Et%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20will%20iterate%20over%20all%20VM%E2%80%99s%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eowned%20by%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20the%20subscription%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20list%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eprovided%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eas%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Einput%20and%20execute%20register%20with%20SQL%20VM%20RP%20command%20for%20all.%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3EIf%20the%20VM%20is%20up%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Erunning%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWindows%20Server%202008%20R2%20and%20above%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eand%20had%20a%20SQL%20instance%2C%20then%20registration%20will%20be%20successful%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3EAll%20VMs%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ewill%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ebe%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eregistered%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Ein%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-register-with-resource-provider%3Fbranch%3Dpr-en-us-80472%26amp%3Btabs%3Dpowershell%23change-management-modes%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3ELightweight%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emanagement%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Emode%3C%2FSPAN%3E%3C%2FA%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Ewith%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20no%20impact%20to%20SQL%20Server%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Einstance%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20or%20the%20VM%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eresources%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3ET%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ehe%20lightweight%20agent%20will%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Es%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eimply%20verify%20the%20edition%20and%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eversion%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20of%20the%20instance%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%2C%20SQL%20server%20instance%20will%20not%20be%20restarted%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAt%20the%20end%20of%20execution%2C%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-bulk-register-with-resource-provider%23output-description%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Et%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ehe%20script%20will%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ereport%3C%2FSPAN%3E%20%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%20VM%E2%80%99s%20successfully%20registered%3B%20total%20VM%E2%80%99s%20found%2C%20failed%20registration%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Es%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20because%20the%20account%20did%20not%20have%20permission%2C%20VM%E2%80%99s%20that%20are%20skipped%20as%20the%20OS%20was%20not%20Windows%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eor%20VM%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20was%20not%20running%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThe%20account%20running%20the%20script%20should%20have%20%E2%80%9CVirtual%20Machine%20Contributor%2C%20Contributor%20or%20Owner%E2%80%9D%20permissions%20for%20the%20virtual%20machine%20being%20registered%20in%20one%20of%20the%20RBAC%20access%20levels.%3C%2FSPAN%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fbs-latn-ba%2Fpowershell%2Fazure%2Finstall-az-ps%3Fview%3Dazps-2.8.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3EInstall%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%20latest%20version%20of%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3EAz%20Module%20%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3Etoday%20and%20with%20a%20single%20command%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-bulk-register-with-resource-provider%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22none%22%3Ebulk%20register%20al%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3El%20VM%E2%80%99s%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20running%20SQL%20with%20SQL%20VM%20RP%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Et%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eo%20leverage%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSQL-Server%2FBenefit-from-Resource-Provider-registration-when-self-installing%2Fba-p%2F742794%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3Ethe%20free%20%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3Emanageability%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22none%22%3E%20services%20and%20optimize%20your%20return%20of%20investment%20on%20Azure%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FA%3E%3CSTRONG%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-953955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3EToday%2C%20w%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Ee%20are%20enabling%20a%20new%20way%20of%20registering%20with%20SQL%20VM%20RP%20for%20customers%20running%20many%20SQL%20Server%20instances%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Eon%20Azure%20VMs.%20%3C%2FSPAN%3E%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20underline%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvirtual-machines%2Fwindows%2Fsql%2Fvirtual-machines-windows-sql-bulk-register-with-resource-provider%3Fbranch%3Dpr-en-us-92680%26amp%3Btabs%3Dazure-portal%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%22%20data-contrast%3D%22none%22%3EBulk%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%22%20data-contrast%3D%22none%22%3Eregistering%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%22%20data-contrast%3D%22none%22%3E%20with%20SQL%20VM%20RP%3C%2FSPAN%3E%3C%2FA%3E%20%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Eis%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Eusing%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Ethe%20%3C%2FSPAN%3E%3CA%20style%3D%22background-color%3A%20transparent%3B%20box-sizing%3A%20border-box%3B%20color%3A%20%23146cac%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20underline%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Faz.sqlvirtualmachine%2F%3Fview%3Dazps-2.8.0%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%22%20data-contrast%3D%22none%22%3Enew%20Azure%20power%20shell%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20font-family%3A%20%26amp%3Bquot%3B%22%20data-contrast%3D%22none%22%3Emodules%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3E%20to%20automate%20registering%20with%20SQL%20VM%20RP%20for%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Ea%20list%20of%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Esubscription%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3Es%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-contrast%3D%22auto%22%3E.%3C%2FSPAN%3E%3CSPAN%20style%3D%22box-sizing%3A%20border-box%3B%20color%3A%20%23333333%3B%20font-family%3A%20%26amp%3Bquot%3B%20segoeui%26amp%3Bquot%3B%2C%26amp%3Bquot%3Blato%26amp%3Bquot%3B%2C%26amp%3Bquot%3Bhelvetica%20neue%26amp%3Bquot%3B%2Chelvetica%2Carial%2Csans-serif%3B%20font-size%3A%2016px%3B%20font-style%3A%20normal%3B%20font-variant%3A%20normal%3B%20font-weight%3A%20300%3B%20letter-spacing%3A%20normal%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%20data-ccp-props%3D%22%7B%26quot%3B201341983%26quot%3B%3A0%2C%26quot%3B335559739%26quot%3B%3A160%2C%26quot%3B335559740%26quot%3B%3A259%7D%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-953955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerAzureVM%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

Many of you are running workloads on SQL Server on Azure Virtual Machines (SQL VM) today to leverage cloud agility, elasticity and scalability benefits. SQL VM differentiates by allowing full control on the OS, VM size, storage subsystem and offering free manageability services.  

 

If you choose to self-install SQL Server on Azure Virtual Machines instead of choosing a preconfigured SQL Server image from Azure Marketplace, you should register with SQL VM Resource Provider (SQL VM RP) for cost savings with simplified license management and free SQL Server manageability services like automated backup , automated High Availability with Always On AG, automated patching and performance optimized storage configuration.  

 

Today, we are enabling a new way of registering with SQL VM RP for customers running many SQL Server instances on Azure VMs. Bulk registering with SQL VM RP is using the new Azure power shell modules to automate registering with SQL VM RP for a list of subscriptions. 

 

The script will iterate over all VM’s owned by the subscription list provided as input and execute register with SQL VM RP command for all. If the VM is uprunning Windows Server 2008 R2 and above and had a SQL instance, then registration will be successful. All VMs will be registered in Lightweight management mode with no impact to SQL Server instance or the VM resources. The lightweight agent will simply verify the edition and version of the instance, SQL server instance will not be restarted. 

At the end of execution, the script will report the VM’s successfully registered; total VM’s found, failed registrations because the account did not have permission, VM’s that are skipped as the OS was not Windows or VM was not running. 

 

The account running the script should have “Virtual Machine Contributor, Contributor or Owner” permissions for the virtual machine being registered in one of the RBAC access levels. 

 

Install the latest version of Az Module today and with a single command bulk register all VM’s running SQL with SQL VM RP to leverage the free manageability services and optimize your return of investment on Azure.