Solved

sql server 2005

Posted on 2012-03-12
2
252 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 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

770 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