https://www.insidesql.org/blogs/andreaswolter/?disp=comments en-EU http://backend.userland.com/rss 60 Thu, 30 Nov 2017 20:25:08 +0000 andreaswolter [Member] c8392@https://www.insidesql.org/blogs/ Hi Michael, I saw that. And only today I found time to do the repro - successfully, indeed. See my complete answer at: http://andreas-wolter.com/en/sql-server-database-ownership-survey-results-recommendations https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8392 Thu, 30 Nov 2017 10:01:39 +0000 Michael [Visitor] c8391@https://www.insidesql.org/blogs/ Hi Andreas, I have reposted my post on your new blog and would be interested in your findings. https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8391 Sun, 12 Nov 2017 19:10:10 +0000 andreaswolter [Member] c8390@https://www.insidesql.org/blogs/ Hello Michael. First of all: My blog is now officially at http://andreas-wolter.com/en/blog/ You are welcome to post or even re-post your comment there. As of now to me this is very odd. Maybe I am missing something, but this is what you did: Create WindowsLogin (disabled in Domain) Alter database set authorization = thatLogin ->Login disappeared I have never seen that, but I will try a repro and get back to you, preferably on my new blog. Login disappeared I have never seen that, but I will try a repro and get back to you, preferably on my new blog.]]> https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8390 Wed, 08 Nov 2017 15:38:30 +0000 Michael [Visitor] c8389@https://www.insidesql.org/blogs/ Hi Andreas, thank you for a brilliant article. Can I ask, in your opinion, can you see an issue with the following scenario. We have created a domain account which is a member of Domain Users. It has Password Never Expires, User Cannot Change Password and Account is Disabled. I have created a new database with my SysAdmin account (which made me the owner) then changed the database owner with ALTER AUTHORIZATION ON DATABASE::[database_name] TO [new_Domain_account]; Now the owner of my new database is the Domain account that is actually disabled and when I check Logins on the SQL Instance it doesn't exist there..! Am I missing something as this seems to be secure but I can't believe that I haven't found any sort of reference to this approach on the Internet..! Thanks, Michael https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8389 Tue, 07 Feb 2017 23:09:57 +0000 andreaswolter [Member] c8385@https://www.insidesql.org/blogs/ PS: Here the link, just stumbled over it: http://markread.net/2014/05/04/how-to-change-the-owner-of-a-secondary-replica-database-to-sa/ https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8385 Sun, 26 Jun 2016 09:16:19 +0000 andreaswolter [Member] c8342@https://www.insidesql.org/blogs/ You are welcome. And for the other readers why not include a link to your article here. Sounds useful to me. So feel free to post the complete URL cheers Andreas https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8342 Sat, 25 Jun 2016 23:27:13 +0000 mfread [Member] c8341@https://www.insidesql.org/blogs/ Andreas, many thanks for such an insightful summary. I've linked your blog in my article how-to-change-the-owner-of-a-secondary-replica-database-to-sa so others may benefit from your article. Cheers, Mark https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8341 Mon, 01 Jun 2015 20:07:31 +0000 andreaswolter [Member] c8177@https://www.insidesql.org/blogs/ As an update for follow-up readers: Group Managed Service Accounts (GSMA) will be supported starting with SQL Server 2016 CTP2 based on Windows Server 2016 and Windows Server 2012 R2 which requires an Update (https://support.microsoft.com/en-us/kb/2998082) https://www.insidesql.org/blogs/andreaswolter/2014/06/sql-server-database-ownership-survey-results-recommendations#c8177