Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sql server 2005

Posted on 2012-03-12
2
Medium Priority
?
271 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

604 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