Solved

sa password

Posted on 2011-03-21
2
412 Views
Last Modified: 2012-05-11
Hei!
       i have 2 questions

1. Many DB do not have a owner ("NULL") that i can change by "exec sp_changedbowner 'sa'"

will this cause problems?

2.  question 2 is closely connected to my first question,
     the password for SQL 2008 'sa'  is not known in our organisation ( strange..?? but true)

how do i change it. will this cause some problems too ?
0
Comment
Question by:shanj
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 35178893
for question 2: you can change it if you login with another login that has sysadmin fixed server role attached.
it will only cause problems to change if some application somewhere is using the (current) password ....
but then, you shall identify that application, and modify it there (aka find the password from that application)

for question 1: no problems. the db owner is usually not used except for the security part to eventually drop/restore the database.
0
 

Author Closing Comment

by:shanj
ID: 35180047
To the point, and very easy to follow.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
how to fix this error 14 48
Need an intro to -- .Net SQL Authorization Manager 7 51
Service Statictic 11 14
In or Between 2 0
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now