Re: Replication problems

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

  • Next message: pat: "Re: Replication problems-news" 
    Date: Fri, 10 Sep 2004 11:37:17 -0700

    There are two issues here that you are experiencing.

    1) You cannot create a share on your machine. While this is not an issue at
    this moment, it will be an issue if you want to have IIS on a different
    machine than SQL Server as you must reference a share on the machine and not
    the admin share (C$). However, since you do have IIS on the same machine
    you can reference the C$ share that comes up as the default when you are
    running through publication wizard.

    2) You can't create a publication due to the 1038 error. I still have no
    idea why that is occuring. Posting that error on the other newsgroup is the
    best solution I have for you at this time on that error. Once that is
    resolved, then you can proceed with referencing the snapshot directory to
    the admin share on your computer. Just keep in mind that you need to have
    IIS and SQL on the same machine in order for that to work.

    "pat" <pat@discussions.microsoft.com> wrote in message
    news:3E9CDC1B-29C6-466D-93AF-F4C784808BFF@microsoft.com...
    > Hello Mr. Collins,
    >
    > I went into the Windows Explorer under Tools (Extra) - Options
    > (Ordneroptionen) - View (Ansicht) - and the "Use Simple File Sharing"
    > (Einfache Dateifreigabe verwenden (empfohlen)) is already checked. And i
    > do
    > not yet have any Publications in my Enterprise Manager.
    > I wanted to note that when this error with the System account occurs a
    > screen "Configure SQL Server Agent" appears where i can choose between
    > "Yes,
    > configure the SQL Server Agent service to start automatically" or "No, I
    > will
    > start the SQL Server Agent service manually". Here i checked the first
    > one. I
    > hope this is right?
    >
    > I posted it now also in the SQL Server - Replication newsgroup. I think
    > this
    > is a general problem with my Enterprise Manager. I always created
    > Databases
    > and their Tables from VS.NET because when i want to add new Tables to a
    > Database in the Enterprise Manager a similiar error to this error 1038
    > occurs:
    > An unexpected error happened during this operation.
    > [Microsoft SQL-DMO (ODBC SQLState: 42000) - Cannot use empty object or
    > column names. Use a single space if necessary.
    >
    > Maybe could you help this that you know what went wrong in my Enterprise
    > Manager? It is inexplicable for me why this error during the Publication
    > occurs...:(
    >
    > regards
    >
    > patrick

  • Next message: pat: "Re: Replication problems-news"

    Relevant Pages

    • Re: Adding a New Table and EXCLUDING from merge replication
      ... no problems here - creating the table using Enterprise Manager or using ... Create Table will not automatically add it to the publication. ... Paul Ibison SQL Server MVP, ...
      (microsoft.public.sqlserver.replication)
    • invalid value specified for STOPAT parameter
      ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
      (microsoft.public.sqlserver.server)
    • Re: Replication Monitor didnt work because different collations
      ... Looking for a SQL Server replication book? ... SQL 2005 filtered merge replication. ... We changed collations to match the server collation and Replication ... After this change we started all publication snapshots. ...
      (microsoft.public.sqlserver.replication)
    • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
      ... Publication: NorthwindProducts ... PublisherDB: Northwind ... A snapshot of 1 articlewas generated. ... > check the replication monitor in SQL Server 2000 Enterprise Manager ...
      (microsoft.public.sqlserver.ce)
    • Re: Tools with/for Express
      ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
      (microsoft.public.sqlserver.tools)