sql server 2005

Details: The following logins use master as the default database:
Instance=Default,SQLVersion=SQL2K5,User=sa,Database=master
Instance=Default,SQLVersion=SQL2K5,User=BUILTIN\Administrators,Database=master
Instance=Default,SQLVersion=SQL2K5,User=NT AUTHORITY\SYSTEM,Database=master
Instance=Default,SQLVersion=SQL2K5,User=W86327\SQLServer2005MSSQLUser$W86327$MSSQLSERVER,Database=master
Instance=Default,SQLVersion=SQL2K5,User=W86327\SQLServer2005SQLAgentUser$W86327$MSSQLSERVER,Database=master
Instance=Default,SQLVersion=SQL2K5,User=W86327\SQLServer2005MSFTEUser$W86327$MSSQLSERVER,Database=master

2.BUILTIN\Administrators is not deleted.

My Question is :
1.Why default database cannot be Master,will it be a problem or security issue.Can you please explain this ?Why login cannot use default as master database.?
2.How do i check that builtin\administrator is not being used by any one in the sql server.Since we are goin to delete it?
Thanks experts.
SandeepiiiAsked:
Who is Participating?
 
Alfredo Luis Torres SerranoConnect With a Mentor Development Director / DBACommented:
1. There is no problem using the master as default database, Of course you have to be sure that the user that has the master has a default database must be restricted to just login and select the database not to delete any records in it.

 2. In the Security tab you have to check for the BUILTIN\Administradores properties/UserMappings to see if there any database assigned as default to that group.

Hope this helps
0
 
SandeepiiiAuthor Commented:
Answer is fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.