Re: Windows Authentication, Which Accounts? (newbie)
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/18/03
- Next message: Jasper Smith: "Re: GRANT - Execute SP"
- Previous message: Jasper Smith: "Re: Connections"
- In reply to: Tom Wells: "Windows Authentication, Which Accounts? (newbie)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 18 Aug 2003 22:52:01 +0100
If there is a login called BUILTIN\Administrators in MSDE then any members
of the local administrators group on the PC has access and by default
sysadmin rights. This account can be removed but make sure you set up a
dedicated group or login in advance that has sysadmin access (and that
you're in) to make sure you don't "lock yourself out" after removing the
login.Also make sure the SQL Service account (and SQL Agent Service account
if different) have sysadmin access. Depending on how these were set up the
required login(s) may already exist. Other than that, unless you have
explicitly add any NT users or groups then they won't have access
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Tom Wells" <noemail@nowhere.none> wrote in message news:OR3toCcZDHA.2284@TK2MSFTNGP12.phx.gbl... Hi SQL Server Newbie Here, How do I tell which domain accounts can access and especially administer a SQL Server instance? When I say administer I mean use the SQL Server Enterprize Manger. The instance is a copy of MSDE 2000. It's letting me in but I want to know who else can get in. Thanks Tom
- Next message: Jasper Smith: "Re: GRANT - Execute SP"
- Previous message: Jasper Smith: "Re: Connections"
- In reply to: Tom Wells: "Windows Authentication, Which Accounts? (newbie)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
