Is there any way to change NT AUTHORITY from NETWORK SERVICE to
SYSTEM? Or does this require uninstall and reinstall?

Use the SQL Server Configuration Manager tool. See the Books Online for
details (http://msdn.microsoft.com/en-us/library/ms345578.aspx).

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

However the SYSTEM account isn't a great choice. See
http://msdn.microsoft.com/en-us/library/ms143504.aspx
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Dan Guzman" <guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote

Good point. A minimally privileged account is a better choice.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

On Thu, 4 Feb 2010 06:56:04 -0600, "Dan Guzman"
<guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote:

Thanks for the link. I had looked through all the Config Mgr pages
and noticed only grayed out entries. Somehow managed to miss the
relevant screen.

On Thu, 4 Feb 2010 19:33:20 -0600, "Dan Guzman"
<guzmanda (AT) nospam-online (DOT) sbcglobal.net> wrote:

I'm setting this up on a laptop that will be used for SQL Azure
development, so there won't be any access from the outside, but point
taken.

The local SQL 2008 Express serves as the emulation for SQL Azure, but
I'm not far enough along with the Azure SDK setup to know how best to
configure authorization. Ideally, I'd like to get the connect strings
as close as possible with the local SQL Express config so that there's
as little change as possible when toggling to run test apps in the
cloud.

I don't suppose anyone here has done any SQL Azure work yet? Tons of
docs to get through.