Re: Newbie question on replication failiure

From: Johan (johan.de.beuckeleer(removethis)_at_(removethis)mabo-lifting.be)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 10:42:49 +0100

Nirvan,

Thanks for the reply,

The problem seems to be that the administrator password was changed on the
server.
When removing the password from the administrator account on the server (NT)
replication does work. When a password is set on the administrator account,
replication fails, so it seems that authentation is the problem.
After changing the administrator password on the server, SQL-server didn't
start up. So i temporary removed the administrator password to start
SQL-server and placed the password back.
Where do I have to make changes in SQL interprise manager, to solve the
problem with the administrator password?

Regards
Johan

"Nirvan Biswas" <yourdisplayname@discussions.microsoft.com> schreef in
bericht news:642517C8-9614-4706-9256-4345DFBCA58A@microsoft.com...
> Hi Johan
>
>
> Pls check the user permission in the sql server users tab.
>
> Regards
> Nirvan Biswas
>
> "Johan" wrote:
>
> > Hi,
> >
> >
> > Replication to a MS-access database fails last week.
> >
> > It has always been working, but now I get this message:
> >
> >
> >
> > DISTRIBUTION AGENT ERROR
> >
> > Error : The process could not connect to Subscriber 'MAB-EC-NW'.
> >
> >
> >
> > Error information: Microsoft JET Database Engine (number = -534709256)
> >
> >
> >
> > The Microsoft Jet database engine cannot open the file
> > '\\Server\Ok2\MA\SQL-SERVER\MABDAT-EC.mdb'. It is already opened
> > exclusively by another user, or you need permission to view its data.
> >
> >
> >
> > I am working on a single server with 1 SQL-database:
> >
> > I does replication to a MS-Access dababase on the server.
> >
> > The SQL-server (2000) is running on a NT-server.
> >
> >
> >
> > It seems to me that the problem is could be caused by 2 reasons:
> >
> > a lock by another user: but ik can open the file MABDAT-EC.mdb' using
> > MS-Access.
> >
> > a problem with the permissions on the server, but what kind of
permissions
> > and where to check.
> >
> >
> >
> > SQL-server is new to me, and I just started my job in this company, so
all
> > help I can get is welcome.
> >
> >
> >
> > Thank in advance.
> >
> > Johan
> >
> >
> >
> >
> >

Relevant Pages

  • Re: Administrator password unavailable - Small Business Server
    ... "Windows Server 2003 for Small Business Server". ... If the domain Administrator password was changed from the Server Management ...
    (microsoft.public.windows.server.sbs)
  • RE: Password Protected Screen Saver and Administrative Password
    ... password as a means to control access to a common area server. ... let a trusted co-worker close the password protected screen-saver ... without giving them the administrator password). ... Why not provide a Domain Admin account to your vendor that they can use. ...
    (Focus-Microsoft)
  • Problem Gone...
    ... The problem must have occurred because I changed the Administrator password ... on the server which prevented certain services from starting because they had ... > Need more info. what other event errors are you receiving? ... >> I have been receiving an error for the past few days, ...
    (microsoft.public.windows.server.sbs)
  • Re: Locked out if 3 servers
    ... I have tried the DSRM and my known password from server installation doesn't ... the local administrator password (the original domain administrator password ... domain Administrator password was changed from the Server Management ...
    (microsoft.public.windows.server.sbs)
  • RE: Password Protected Screen Saver and Administrative Password
    ... You are giving them access to use the server with an administrator ... but you won't tell them the administrator password? ... Does someone know a way to allow a normal user to release a server ... The password protected screen-saver ...
    (Focus-Microsoft)