DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Can Someone pls help with this: SQL Server Compact Ed. Error(Synchronizing Data(100%)

  1. #1
    Join Date
    Dec 2008
    Location
    *****, Nigeria
    Posts
    62

    Can Someone pls help with this: SQL Server Compact Ed. Error(Synchronizing Data(100%)

    Hi Guys,

    I was done with creating a SQL Server DB for a mobile application on the server side. I configured the Publications, Web Configurations and all that BUT i had issues with the subscription. At the last phase of the subscription, this was the error i encountered:

    Synchronizing Data (100%) (Error)
    Messages
    Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
    HRESULT 0x80004005 (29061)

    The operation could not be completed.

    Please can any SQL Server Mobile Application SupaMan HELP!!!!!....I'll be SO grateful.


    Charles
    Mobile: +234 706 042 6036
    Email: charles@hedonmark.com
    Website: www.hedonmark.com

    “To be yourself in a world that is constantly trying to make you something else is the greatest accomplishment.”
    —Ralph Waldo Emerson

  2. #2
    Join Date
    Dec 2008
    Location
    *****, Nigeria
    Posts
    62
    Halo Mobile People,

    EUREKA!!! I have found a solution to the problem. I repeated the subscription creation process for the SQL Server Compact Ed. and boy it worked!!! Only this time i put in the same username and password that I use in logging into the SQL Server DB. So I guess that is required for the Compact Ed to be able to Sync with the SQL Server on the Server PC that has the publication component.

    Charles...
    Mobile: +234 706 042 6036
    Email: charles@hedonmark.com
    Website: www.hedonmark.com

    “To be yourself in a world that is constantly trying to make you something else is the greatest accomplishment.”
    —Ralph Waldo Emerson

Similar Threads

  1. find version & service packs
    By rperez in forum Database
    Replies: 5
    Last Post: 01-02-2009, 05:14 PM
  2. Accessing MySQL data from MS SQL Server 2000
    By Andy H in forum Database
    Replies: 8
    Last Post: 10-04-2005, 01:27 AM
  3. Users having trouble accessing my SQL Server
    By Brandon in forum Database
    Replies: 2
    Last Post: 04-29-2003, 12:49 PM
  4. Replies: 0
    Last Post: 04-29-2002, 07:39 AM
  5. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 10:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center