Solved

sql server 2005

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Job Hung 17 37
Return Rows as per Quantity of Columns Value In SQL 6 28
Change this SQL to get all nodes 3 40
SQL Instance service gone? 5 39
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.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

733 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