Re: Sync Manager With SQL Express

You need to use nt authentication end to end. The storing of passwords was
disabled in SP2 of SQL 2000 IIRC as it was a security risk.

"Ken Hundley" <KenHundley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F3A92B4C-C404-49C6-8D16-E8345DF83BEA@xxxxxxxxxxxxxxxx
We are really missing the sql agent that was in SQL 2000 for automating
our
replication, but he have created a work around application now.

However, now I have found the sync center in Vista and scheduled a sync.
It started the sync at the correct time, but it asked for the
publisher/distributer passwords and then asked for them each time it tried
to
sync after that. I looked all over the place but could find no way to get
it
to remember the password.

Is there anyway to get it to remember the password so that we could you
this
to schedule syncs on systems that only have SQL Server Express installed?

Thanks


.

Relevant Pages

  • Re: SQL Access security from Window Application
    ... you could have your app handle authentication by emulating the ... Currently my application access the SQL using ... >System.Data.SqlClient and all forms use stored procedures. ... >passwords in a protected file but this creates a problem on remote systems ...
    (microsoft.public.dotnet.general)
  • Re: ADSI
    ... Can you provide more details on how the passwords are stored in the SQL ... However, if they are in some sort of 1 way hash format, then it might be ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Active Directory to ADAM Sync Password question
    ... You can't read passwords out of AD or sync them with ADAMSync. ... I'm confused by your statement as bind proxy objects are designed ... specifically so that you can have an object in ADAM to do a simple bind on ...
    (microsoft.public.windows.server.active_directory)
  • Re: Openldap to AD
    ... How are the passwords stored in your OL implementation? ... I'm thinking that it may be easier to at least one-way sync from OL to AD. ... the account in both places and change passwords in both places. ... is for when I create a new account on openldap to be push to AD, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Passwords getting reset?
    ... If passwords expire, this sounds like you are referring to ... If these are SQL logins, as I said, they don't expire so ...
    (microsoft.public.sqlserver.security)