Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sa password

Posted on 2011-03-21
2
Medium Priority
?
421 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 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

972 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