Default account question

[OldSkoolSkater]

Hi All

Just a quickie, what are the default accounts created when SQL2000 is installed?

I'm figuring it's:

-Sa
-builtin\administrators

Are there any more?

Cheers

Steve - Network Coordinating in the UK

 

[ptheriault]

That about covers it. I would also recommend that you delete the built in admin account. (if it is currently not being used) This allows anyone who is a server admin the ability to be an 'sa' in the SQL Server.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

The only other account that is created automatically is the account that SQL Server is running under.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[OldSkoolSkater]

Thanks Guys

Is it possible to rename the Sa account?


Cheers

Steve - Network Coordinating in the UK

 

[ptheriault]

Don't mess with the 'sa' account. I don't even use it. I set the password. Then I lock it up in my file cabinet. I don't allow anyone to use 'sa'. Definetly don't rename it.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[OldSkoolSkater]

Unfortunately this is a system which I have inherited (much to my delight)and certain DBs are already setup to use Sa.

Just wondering what I can do to try and remedy this, which is nothing I am guessing!

Cheers

Steve - Network Coordinating in the UK

 

[ptheriault]

You would have to find what permissions are needed for the application. Find out how the application connects..DSN, connection string? Create an account that will satisfy the applications needs. Make the change in test. TEST, TEST and more TESTING. then change it in production. I had a similar problem when I started here but it can be changed.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

And no the sa account can not be renamed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

What do you mean they are set up to use SA? SA can be the OWNER of a database without any problem. In fact, we make SA the owner of all databases. That way if a user leaves and their login is revoked, there won't be a problem with the database being owned by a login that doesn't exist.

-SQLBill

Posting advice: FAQ481-4875