SA account

SA account

Post by pdunni.. » Sat, 29 Jul 2000 04:00:00

How do I find out the sa account in sql?

1. SA account and SA role

I've been a Sybase DBA for a while, but just got started in MS SQL.

In Sybase, we have the concept of roles, like the sa_role, sso_role, and the

If I assign the sa_role to a login, then that login can do anything that the
sa account can, enabling me to lock the sa account for security reasons.

We just acquired a small software company that has been using MS SQL 6.5,
but they use the sa account for EVERYTHING.  Since I inherited the DBA job
for this MS SQL Server, I wanted to assign myself sa_role and disable the sa
account, but I cannot find any information on how to do that in SQL 6.5.


They need to use integrated security, which I believe maps anyone in the NT
administrators group to automatically login as sa.  How can I go around
that?  I don't want anyone to login as sa.  Never!

Thanks in advance.


2. Conversion timestamp -> datetime

3. MSDE Blank SA Account.

4. Character set /Language detection in ORACLE 8i and 9i

5. SQL7 sa account

6. Max Named Pipes

7. Problem changing sql sa-account password and sms

8. Removing Duplicates

9. basic question about sa account on MSDE

10. SQL2000 SA Account

11. sp_addumpdevice with non-sa account?

12. Authentication Error using SA account

13. SA Accounts