Change Database Owner with SQL Server Management Studio

|
Saturday,12 July 2014 06 00 AM

What is the database owner? The database owner is a user that has permissions to perform all activities in a database. On a SQL server, database owners can be changed. Any user that has all the rights to connect to the SQL server can become the owner of any database. In this article I will give you a step by step guide on How to Change Database Owner with SQL Server Management Studio

1. Connect to your database using Microsoft SQL Server Management Studio.

connect to database sql arvixe asp tutorials windows hosting

2. In the object explorer, right click on the database that you want to change the owner and go to “Properties” menu:

database properties sql tutorials arvixe windows hosting

 

3. In the properties window, go to menu “Select a page -> Files”. Search or write the new owner. For the purposes of this example I will set “WspSqlAdmin” as an owner. Once you’re done, click on OK to save your changes:

changing or setting the new owner sql tutorials

sql database owner changed arvixe tutorials

4. And that’s it! The owner has been changed!

This concludes Change Database Owner with SQL Server Management Studio

Looking for quality ASP Web Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , , , , , , , , , , , , , | Posted under DotNet/Windows Hosting, MSSQL | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web
|
Personal Website

Leave a Reply

Your email address will not be published. Required fields are marked *