Monday, March 19, 2012

mssqlserver service user profile

greetings, I am trying to get MSSQLserver service to get
started under LocalSystem account. Where can I get info.
regarding this? I am currently starting the MSSQLserver
service under a network user that also has SQL2k profile
with admin role. What user is LocalSystem using. Thanks
for any info. you can send my way.
Sincerely,FredPerusing several on-line book topics, the following comprises some of the
information surrounding the Local System account:
The local system account does not require a password, does not have network
access rights in Windows 2000, Windows XP, and Windows Server 2003, and
restricts your SQL Server installation from interacting with other servers.
==Run SQL Server services with the lowest possible privileges. Associate SQL
Server services with Windows accounts.
==In Windows NT/2000, the Local System account is generally understood to mean
the operating system itself. Selecting the Local System account always
works. However, this account has no network access rights. Therefore, if
you want to integrate more than one SQL Server on your network or integrate
SQL Server with other BackOffice services such as Microsoft Exchange Server,
you should run the SQL Server services under a user account.
--
Keith Wilson
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
"fred ghaffari" <fred_ghaffari@.yahoo.com> wrote in message
news:014301c34c8b$1418ca80$a401280a@.phx.gbl...
> greetings, I am trying to get MSSQLserver service to get
> started under LocalSystem account. Where can I get info.
> regarding this? I am currently starting the MSSQLserver
> service under a network user that also has SQL2k profile
> with admin role. What user is LocalSystem using. Thanks
> for any info. you can send my way.
> Sincerely,Fred

No comments:

Post a Comment