Wierd settings..



We have one SQL server setup to run our ASP.Net intranet. the SQL agents are
set to back the DB up to a file location nightly.
Then Veritas Back up Exec, cannot back that folder up. it fails with no
rights to the folder.
When I look at the server settings, the SQL service are started up by a user
called .\administrator .. ALL the other services on teh server are either
local admin started or start as a local service, the sql ones are the wierd
ones.
i think this is the reason i cannot back that one folder up.

i think at one time, this server was actually on another domain, called
ms.com, it was removed from that network, demoted as a DC and made a member
server, then moved to a new domain under acad.local. would that explain the
wierd .\admin user?

can i fix that to be the local\admin user without trashing my SQL install?
I have no way to find out what the .\admin password is, so i cannot change
the setting to use the local\admin account, and set them back if it blows
up.
btw.. this is on server 2K

any ideas on what to do?

TIA
KCI



.



Relevant Pages

  • RE: Server Usage Report - Email Data not available
    ... From your description, I know that when you open the Server Usage Report, ... Are there any log files in the shared folder? ... This issue occurs when you don't have SQL MSDE 2000 SP4 installed. ... This issue may be caused by the corrupt Monitoring component. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Error 7619 - Cannot enable FTS on any database
    ... Even after having stopped the Microsoft Search, SQL Server and SQL Agent ... I then went to install SP3a. ... I ran the extract again specifying a new folder, ...
    (microsoft.public.sqlserver.fulltext)

Loading