Re: Can't replicate because systemaccount needs internet access

From: Hal Berenson (haroldb_at_truemountainconsulting.com)
Date: 06/25/03


Date: Wed, 25 Jun 2003 12:10:42 -0600


See the Books Online topics:

Setting up Windows Services Accounts

and

How to change SQL Server services login account information

-- 
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"nfr" <nfr@nospam.com> wrote in message
news:uZhUgUfODHA.2212@TK2MSFTNGP12.phx.gbl...
> I am trying to replicate a database to another server but the wizard balks
> claiming the service is running under a local system account and needs to
be
> changed to allow network access... but gives no info on how to change it
to
> allow for this.
>
>


Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Re: Backup to Network Drive
    ... Then you need to setup SQL Server to use a local account that exists on ... You change the account the SQL Server uses to login through Enterprise ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.msde)