Re: replication password problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 10:37:08 -0700

These error messages are related to passwords that are associated with SQL
Server, not with SQL Server CE. It doesn't appear that you have the
distributor on a different server than SQL Server, so you can simply leave
the distribution properties blank and only assign the passwords for the
publisher properties. It is also important that you specify the correct
authentication type (window auth or sql auth) and use the appropirate
passwords.

The easiest, but not most secure way, is to use SQL Auth. You need to pass
the SQL Auth user name and password to those properties.

If you are want to see an example of this, using our upcoming product, you
can see a hands on lab here. This will take you through everything, using
SQL Mobile and SQL 2005 beta's. However, the properties that the HOL uses
are identical to what you would be doing with VS 2003 and SQL CE 2.0.

You can get this HOL here.

http://24.17.112.250/SQLMobileWebCasts/sqlmobilehol.zip

"RonF" <RonF@discussions.microsoft.com> wrote in message
news:376205C8-58B0-43F4-90CC-75FBA0CEE146@microsoft.com...
> I'm attempting to do replication of a database. I successfully create a
> blank database on the handheld using the sqlcereplication:
> dbrep.addsubscription(addoption.createdatabase) - This creates a database
> with no tables
> I then attempt to do syncronization with dbrep.syncronize and get the
> following errors on my handheld:
>
> Some distribution properties are not specified [,,,,,]
> The publisher login property is not specified[,,,,,]
>
> I'm using the windows authentication option for everything and believe I
> have all permissions enabled.
>
> I'm running everything on my PC including SQL2000, IIS, and the emulator
> which contains my application that is giving the above messages. I'm not
> sending any passwords along. Do I need to send any passwords from the
> Pocket
> PC (emulator) application or should this work? Any other suggestions on
> what
> I might look at.
>
> Thanks
>
>
> --
> Thanks
> RonF

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)
  • What is the best practices are supposed to be for MS SQL authentication?
    ... make sure to patch and upgrade your sql clients ... This will make sure that passwords are not stored ... way communication from specific PCs in LAN to sql server. ... you can install a certificate on sql server and encrypt ...
    (microsoft.public.sqlserver.server)
  • Re: Passwords case sensitivity
    ... Password case-sensitivity is determined by the default collation for the SQL ... It appears you have a case-insensitive collation. ... > How do I change my SQL Server back to the case sensitive passwords? ...
    (microsoft.public.sqlserver.security)
  • 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)