Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

sql server 2005

Posted on 2012-03-12
2
Medium Priority
?
273 Views
Last Modified: 2012-12-26
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.
0
Comment
Question by:Sandeepiii
2 Comments
 
LVL 12

Accepted Solution

by:
Alfredo Luis Torres Serrano earned 1000 total points
ID: 37715399
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
 

Author Closing Comment

by:Sandeepiii
ID: 38720869
Answer is fine.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

564 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