Re: Configuring a Windows NT account for MSSQLServer service and SQL Server Agent.

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 10/18/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Fri, 18 Oct 2002 07:43:56 -0500

The requirements are in the SQL 2000 Books Online
<instsql.chm::/in_overview_6k1f.htm>. When you specify the service
account using Enterprise Manager, the account is automatically assigned
the necessary rights. You'll need to ensure the account has permissions
on other resources (i.e. files) your applications may use. 

--
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"Alejandro Mesa" <AlejandroMesa@GardensAmerica.com> wrote in message
news:OssezrpdCHA.2616@tkmsftngp09...
Hello everybody!
Reading a little bit about security and MS Sql Server, in
http://www.microsoft.com/security/security_bulletins/ms02020_sql.asp,
one point that always has called my attention is:
Run the MSSQLServer service and SQL Server Agent under a Microsoft
Windows NT account, not localsystem.
Is there any place where I can find the specifications that this account
has to meet?, specially for Windows NT 4.0 sp6a and Windows 2000 Server
sp2.
Thanks in advance,
Alejandro Mesa

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: Connect problem MSDE ADO ASP
    ... problems on setting the IIS User password. ... result - and both can access the MSDE SQL via the webinterface (I am aware I ... > your connection string, and put in a valid SQL USER ACCOUNT, not a Windows ...
    (microsoft.public.sqlserver.programming)
  • Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
    ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
    (microsoft.public.vsnet.debugging)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: Trying to get a VB.net sample working with SQL Server.
    ... SQL server can have two types of logins. ... You can setup SQL to run in mixed mode (SQL and Windows) or Windows only. ... ASPNET is a windows account.. ...
    (microsoft.public.dotnet.languages.vb)