安装SQL Server 2008 Developer时要使用的帐户 [英] What accounts to use when installing SQL Server 2008 Developer

问题描述

我在这里安装SQL Server 2008 Developer，在安装的服务器配置"步骤中，它询问我有关服务帐户的信息.我在这里选择什么?

I am installing SQL Server 2008 Developer here, and on the Server Configuration step of the installation it asks me about Service Accounts. What do I choose here?

我可以在屏幕快照中看到可用的选项，尽管在大多数选项中，我只能选择其中的两个或三个.单击为所有SQL Server 2008服务使用同一帐户按钮时，我可以在 NT AUTHORITY \ NETWORK SERVICE 和 NT AUTHORITY \ SYSTEM 之间进行选择

I can see the available ones in the screen shot, although on most of them I can only select two or three of those. When I click the Use the same account for all SQL Server 2008 services button I can choose between NT AUTHORITY\NETWORK SERVICE and NT AUTHORITY\SYSTEM.

我在这里选择什么，为什么?

What do I choose here, and why?

推荐答案

来自Microsoft:

From Microsoft:

本地系统帐户.这个的名字 帐户是NT AUTHORITY \ System.它是 有一个强大的帐户 无限制地访问所有本地 系统资源.它是 Windows Administrators组上 本地计算机，因此是 SQL Server sysadmin的成员 固定服务器角色

Local System account. The name of this account is NT AUTHORITY\System. It is a powerful account that has unrestricted access to all local system resources. It is a member of the Windows Administrators group on the local computer, and is therefore a member of the SQL Server sysadmin fixed server role

网络服务帐户.的名字 这个帐户是新台币 AUTHORITY \ NetworkService.它是 在Microsoft Windows XP和 Microsoft Windows Server2003.全部 网络下运行的服务 服务帐户已通过身份验证 网络资源作为本地 电脑.

Network Service account. The name of this account is NT AUTHORITY\NetworkService. It is available in Microsoft Windows XP and Microsoft Windows Server 2003. All services that run under the Network Service account are authenticated to network resources as the local computer.

因此，除非需要开发SQL Server使用网络服务，否则可以使用本地系统帐户.

So unless you need your Dev SQL Server to use Network Services, you can use Local System account.

更新:

要配置外围应用，请依次单击开始-> Microsoft SQL Server->配置工具-> SQL Server外围应用配置.

To Configure your surface area go Start->Microsoft SQL Server->Configuration Tools->SQL Server Surface Area Configuration.

这就是您设置传入连接的方式.还要确保SQL Browser服务器正在运行.

Thats how you setup for incoming connections. Also make sure the SQL Browser server is running.

我还建议 SQL 2005 for Dummies 或 SQL Server 2005圣经进行一些研究SQL Serve的一些基本内容.如果您超出了傻瓜型书籍，那么圣经也会更加深入.

I would also recommend either SQL 2005 for Dummies or SQL Server 2005 Bible to do some study on some of the basic stuff of SQL Serve. The bible will also go more indepth should you be beyond the dummies type book.

这篇关于安装SQL Server 2008 Developer时要使用的帐户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！