Merge Replication (Push) over Internet

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - SQL Server 2005 Express Is there no way in SQL Server Management Studio 2005 Express (SSMSE) to migrate the data only to an already provisioned database on another server Tag: Merge Replication (Push) over Internet
  - 2
    - Increase Transaction Log size Hi, How can I increase the transaction log size of my sql server 2005 database i can execute the shrink and backup log which can shrink the .ldf file to 1MB. However, since my dts involves a lot of inserts and updates, the my transaction log grows to 700MB in the middle of my dts execution. How can i increase the transaction log size maximum capacity to probably 1.5GB just so it can accommodate my full dts execution BTW, this is my commands to shrink the log file: DBCC SHRINKFILE ( <dbname>_log , 1 ) BACKUP LOG <dbname> WITH NO_LOG DBCC SHRINKFILE ( <dbname>_log , 1 ) cherriesh Tag: Merge Replication (Push) over Internet
  - 3
    - top 10 accounts for every day with summary hi, i am new to mdx and stuck on a problem on analysis services 2005. there is an orders cube with calendar and accounts dimension. the report i want to do is something like this date account quantity top10percentage 01.01.2007 All 1000 85 bnm 230 23 abc 150 15 bbc 140 14 aaa 100 10 wer 60 6 rrr 40 4 xyz 35 3,5 xtv 35 3,5 tyu 30 3 tbh 30 3 02.01.2007 All 1230 75 abc 150 15 bnm 150 15 bbc 140 14 aaa 100 10 txp 60 6 rrr 40 4 xyz 30 3 xtv 30 3 tyu 25 2,5 tbh 25 2,5 i have written a calculated member for the percentage of the account for that day's total order amount. but when i do a filter on accounts dimension to get top 10 records for that day in excel 2007 the total value of the percentage for that day remains 100. not the sum of the top 10 records percentage values. i am looking a way to write a report like this and appreciate any suggestions. and also any workaround to solve this excel behaviour. thanks in advance Tag: Merge Replication (Push) over Internet
  - 4
    - Improving Performance kk, what is bcp or DTS remeber i said i wasn't familar enough with Sql and the inserts are parameterized and well i'm not sure some of that time is getting the event entries remotely... but's it's not the upload that is bothering me... it's the performance when i try to query for information. Tag: Merge Replication (Push) over Internet
  - 5
    - Copy objects with DTS Import/Export Wizard? I also share in their frustrations... When you only have a few objects, in this case tables to transfer; you have very little options in the SQL2005 Import/Export wizard as compared to the SQL2000 DTS (Import/Export) wizard. Copy Database is out of the question for this scenario. My problem lies in the fact that the SQL2005 Import/Export wizard does not create the indexes and keys when the table needs to be created in the target database, even if the source schema exists on the target database. Is there any way around this without pre-creating the target tables from scripts generated on the source DB Seems that this manual step should be built into the wizard Ay suggestions We are running SP2 for SQL 2005. There are suggestions that SSIS can be used, thats fine, but given the entirely different interface as compared to DTS, I don't have the time to deal with that when the wizard should be able to do this in a few minutes. Tag: Merge Replication (Push) over Internet
  - 6
    - Problem with the SQL Insert with .CommandText() and .ExecuteNonQuery() Hi I think I have found the problem the database connection i set to. The database in my project folder is the one that is appearing on my IDE's server explorer. But the program was actually inserting data to /bin/debug/database.mdf instead. That is the reason why I am unable to see the data in my database. How can I make my debug binary point to the same working database instance, than to create mulitple copy of the database Tag: Merge Replication (Push) over Internet
  - 7
    - Select Statement In Table (Valid Expressions Error). here's the solution with the function that i've mentioned a while ago you can get the Split Function here Code Snippet CREATE FUNCTION dbo.ParseAccountNo ( @AccountNo varchar(800) ) RETURNS varchar(800) AS BEGIN DECLARE @SelectStmt varchar(800) SET @SelectStmt = '' -- for & delimiter IF (SELECT COUNT(*) FROM dbo.Split(@AccountNo,'&',NULL,NULL)) > 1 BEGIN SELECT @SelectStmt = @SelectStmt + 'AccountNo LIKE ''%' + RTRIM(LTRIM(CSV)) + ''' OR ' FROM dbo.Split(@AccountNo,'&',NULL,NULL) END -- for , delimiter ELSE IF (SELECT COUNT(*) FROM dbo.Split(@AccountNo,',',NULL,NULL)) > 1 BEGIN SELECT @SelectStmt = @SelectStmt + 'AccountNo LIKE ''%' + RTRIM(LTRIM(CSV)) + ''' OR ' FROM dbo.Split(@AccountNo,',',NULL,NULL) END -- you can insert other delimiter here -- -- for single account no ELSE BEGIN SELECT @SelectStmt = @SelectStmt + 'AccountNo LIKE ''%' + @AccountNo + ''' OR ' END IF @SelectStmt <> '' SET @SelectStmt = LEFT(@SelectStmt,LEN(@SelectStmt) - 2) SET @SelectStmt = 'And (' + LTRIM(RTRIM(@SelectStmt)) + ')' RETURN @SelectStmt END your optimized proc would then be.. INSERT INTO dbo.New_Cust_Table SELECT [Name] + '1' AS UserId , [Name] + '1#' AS Pwd , dbo.ParseAccountNo(AccountNo) AS SelectStmt FROM Cust_Table Tag: Merge Replication (Push) over Internet
  - 8
    - Why does using the "in" clause cause an error in my "Having" condition in 2000, but not 2005? Hmm..guess giving the error might help: Column 'Business_Grp.GLUnitCode' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause. I modified the SQL I posted to try to strip out the "real" database names ( didn't do a good job of that, did I ). Regardless, I know how to make it work. The SQL is coming out of my BI system (auto-generated), I'm just tyring to determine if its a BI problem or a MSSQL problem. The fact that it works in SQL 2005 suggests that this is a bug in SQL2000 (which means logging it with Microsoft). Tag: Merge Replication (Push) over Internet
  - 9
    - Dose anybody knows how to use MergeJoin component programitcally? I'm building a package programitcally and I can't find any document which shows how to work with MergeJoin component in code. Please help, Thanks Tag: Merge Replication (Push) over Internet
  - 10
    - SQL Server 2005 SP2 cannot be installed because the Database Engine setup remains in suspended installation mode SP2 refuses to install for the Database Engine because “the previous upgrade did not complete”, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine. When I try to do the same thing this time, I’m presented with the ”complete the suspended installation” option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, I’m still presented with the ”complete the suspended installation” option. I’ve even tried to run it more than once, but it doesn’t help. Needless to say, SP2 still refuses to install. I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully. I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=259606 Any ideas what I can do to resolve this problem Tag: Merge Replication (Push) over Internet
  - 11
    - patindex with nvarchar so please give me solution as possible, here i have written my stored procedure as below which use above function:--- I am using for all column nvarchar only in which i stored hindi text and English as well. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO -- -- spSearch -- SUMMARY Executes a search using the specified query -- PARAMS @siteId Identifier of the site from which the search request was generated -- @query Full-text query to be executed against the full-text engine -- ALTER PROCEDURE spSearch ( @siteId INT, @textOnly BIT, @query NVARCHAR(4000) ) AS -- Select Alternatives Declare @partialQuery NVARCHAR(50) Declare @keyphrase NVARCHAR(50) --Query can be provided like 'searchterm' or as "search term" depending in existance of space character --must format the partial query if it contains a space like '"search term*"' --the keyphrase is @query without quotes IF CHARINDEX('"',@query) > 0 BEGIN SET @partialQuery = LEFT(@query, LEN(@query) - 1) + '*"' SET @keyphrase = LEFT(RIGHT(@query, LEN(@query) - 1), LEN(@query) - 2) END ELSE BEGIN --must format the partial query like '"searchterm*"' set @partialQuery = ' "' + @query + '*" ' set @keyphrase = @query END --Now we can search for alternatives as exact match of @query on alternatives --or partial match on keyword, but ignore exact match on keyword (i.e. only alternatives to @query) SELECT * FROM tblKeywords WHERE NOT Keyword = @keyphrase AND SiteId = @siteId AND ( CONTAINS(Keyword, @partialQuery ) ) -- Select the pages that match the query SELECT DISTINCT c.ContentName, c.ContentLongSummary, c.MasterId, nc.NavigationId FROM tblContents AS c INNER JOIN trelKeywords AS ck ON ck.MasterId = c.MasterId INNER JOIN tblKeywords AS k ON k.KeywordId = ck.KeywordId INNER JOIN trelNavigationContents AS nc ON nc.MasterId = c.MasterId INNER JOIN GetKeywordsFromQuery(@query) AS kq ON kq.Word = k.Keyword INNER JOIN tblNavigation AS nav ON nc.NavigationId = nav.NavigationId WHERE c.SiteId = @siteId AND c.StatusID = 2 AND c.DeletedBy IS NULL AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) UNION -- the following selects list pages that match, with primarylist page as their navigationid SELECT DISTINCT c.ContentName, c.ContentLongSummary, c.MasterId, nc.NavigationId FROM tblContents AS c INNER JOIN trelKeywords AS ck ON ck.MasterId = c.MasterId INNER JOIN tblKeywords AS k ON k.KeywordId = ck.KeywordId INNER JOIN tblContents AS c1 ON c.PrimaryListMasterId = c1.MasterId INNER JOIN trelNavigationContents AS nc ON nc.MasterId = c1.MasterId INNER JOIN GetKeywordsFromQuery(@query) AS kq ON kq.Word = k.Keyword INNER JOIN tblNavigation AS nav ON nc.NavigationId = nav.NavigationId INNER JOIN tblListContents AS lst ON lst.ListItemMasterId = c.MasterId WHERE c.SiteId = @siteId AND c.DeletedBy IS NULL AND c.StatusID = 2 AND c1.statusid = 2 AND c1.DeletedBy IS NULL AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) AND lst.ContentMasterId = c.PrimaryListMasterId -- Select the downloads that match the query SELECT DISTINCT r.ResourceId, r.ResourceName, r.ResourceLongSummary, r.FileSize FROM tblResources AS r INNER JOIN trelKeywordResources AS kr ON kr.ResourceId = r.ResourceId INNER JOIN tblKeywords AS k ON k.KeywordId = kr.KeywordId INNER JOIN GetKeywordsFromQuery(@query) AS kq ON kq.Word = k.Keyword INNER JOIN trelContentItemResources AS cir ON r.ResourceId = cir.ResourceId WHERE r.ResourceTypeId = 2 AND r.SiteId = @siteId AND cir.StatusId = 2 SELECT CASE WHEN nc.MasterId IS NULL THEN cir.MasterId ELSE nc.MasterId END AS MasterId, CASE WHEN nc.MasterId IS NULL THEN ln.NavigationId ELSE nc.NavigationId END AS NavigationId, c.ContentName, res.ResourceId, res.ResourceTextType, res.ResourceText, c.ContentLongSummary FROM tblResources res INNER JOIN trelContentItemResources cir ON cir.ResourceId = res.ResourceId LEFT OUTER JOIN trelNavigationContents nc ON nc.MasterId = cir.MasterId LEFT OUTER JOIN tblContents c ON c.MasterId = cir.MasterId AND c.StatusId = cir.StatusId LEFT OUTER JOIN trelNavigationContents ln ON c.PrimaryListMasterId = ln.MasterId LEFT OUTER JOIN tblNavigation nav ON nc.NavigationId = nav.NavigationId INNER JOIN tlkpResourceTypes rt ON rt.ResourceTypeId = res.ResourceTypeId INNER JOIN tblListContents AS lst ON lst.ListItemMasterId = c.MasterId WHERE (res.SiteId = @siteId) AND (res.ResourceTypeId = 1 OR res.ResourceTypeId = 6) AND CONTAINS(res.ResourceText, @query) AND (c.ContentPublicationDate IS NOT NULL) AND (c.DeletedBy IS NULL) AND (c.StatusId = 2) AND (nc.MasterId IS NOT NULL) AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) OR (res.SiteId = @siteId) AND (res.ResourceTypeId = 1 OR res.ResourceTypeId = 6) AND CONTAINS(res.ResourceText, @query) AND (c.ContentPublicationDate IS NOT NULL) AND (c.DeletedBy IS NULL) AND (c.StatusId = 2) AND (c.PrimaryListMasterId IS NOT NULL) AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) ORDER BY rt.SearchResultOrder, c.ContentName GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO Tag: Merge Replication (Push) over Internet
  - 12
    - MDX Ranking Question Hi A further question to this. We are also wanting to make this ranking Time aware. Currently, you can only run the quesry for a specific time period (eg [dimDate].[Year].[2006]). If you try to create a crossjoin in the report to have all the above measures by 2005 and 2006, then the ranking does not work anymore. As far as I understand it, this will be the case as the Order Set does not know about the time dimension, and hasn't ordered the Products by Time. So, how I see this is that I will need to add the time Dim to the order Set, but at what level. We would like to make this dynamic within the cube and would like the ranking to work in a year on year, quarter on quarter, month on month ...etc level. I would think that ordering by the lowest level of time (day in my case) might work, but would create a set that is extremely large. Would this work, or is there a better way to do this Michael Tag: Merge Replication (Push) over Internet
  - 13
    - BCP loading failing on timeout error Hi Paul, are you using Cognos 7.2 - The bcp delivery in 7.2 will create a temporary text file in default data directory, there for make sure you have enough disk space. .... Which version of SQL-Server and SP are you running Tag: Merge Replication (Push) over Internet
  - 14
    - allows blank value for integer Parameter Hi have a problem to solve and I hope that this is not a SSRS Bug. I created a Reports(using SQL Server Project) which has several parameters which values are passed to a SP. One of these parameter is an Integer and it is an optional value, so if the user fill it is used by the SP, otherwise the SP uses NULL and run anyway. I starts to define tha parameter: Datatype = integer Allow blank value Available: Non queried Default: Null if I want to Preview the report I have to provide an integer to the parameter's field ... If for instance I set: Default: Not queried = 0 In the moment I deploy and I use the ReportViewer in my window application the parameter's field is unabled!! So I tried this solution: Datatype = integer Allow blank value Allow null value Available: Non queried Default: Null In the preview the checkbox: NULL is checked and I click on the View Report. But when I deploy it,in the ReportViewer in my window application the parameter's field this checkbox is unchecked. Do I forget something during my setting I have to control it programmatically N.B. By default the user will not user this parameter so the best is that he can click directly on "View Report" without any additional "work" on the parameter!! Thank you for any help! Tag: Merge Replication (Push) over Internet
  - 15
    - No one can help me on this prolem?????? Have you tried to leverage the cascading parameter feature WHat if you change the EmployeeDS dataset to have a clause like: WHERE EmployeeID IN (@ParameterThatYouPassFromTheWebApp) The @ParameterThatYouPassFromTheWebApp must precede the related parameters in the Report Parameters dialog box. Will this do the trick HTH, Jordi Tag: Merge Replication (Push) over Internet
  - 16
    - SSIS deployment - redefined Sara4 wrote: 1) Every package has to have its own configuration file There's no configuration on a project level 2) is there anything in particular I have to do with a configuration file before running a build When I run deployed package it seems like it ignores my configuration file and takes the connection string of conn. manager i use in development. For 1) you should open up a dtsConfig file and see how the configuration is stored. You'll see something that looks like this: Code Block < Configuration ConfiguredType = " Property " Path = " \Package.Variables[User::ContinueExecutionOnFailure].Properties[Value] " ValueType = " Boolean " > ... The key point is that you can reuse this configuration file with any package that has a variable with the same name and data type - and you can get the same sort of reuse with connection managers or any other components that are common across all configured packages. You basically just need to have each package be aware of the fact that there is a configuration, and have them all reference the same file, and then you define the configuration once with all packages pointing to it. For 2) it sounds like your packages may be looking in the wrong location when deployed. Do you use indirect configurations, where the path to the config file is stored in an environment variable If so, you should verify that the environment variables are set properly and that the files you think are in a given location are in fact the files that are there. (I've made mistakes with this stuff enough times to never trust myself, even when I "know" I did it right.) Also, check your package warnings to ensure that the configurations are being set in the first place. It's also possible that SSIS cannot find the environment variable and/or config file when the package is executed, so the values that are in the package from development are being used instead. Good luck! Tag: Merge Replication (Push) over Internet
- Next
  - 1
    - Secure SQL Server remote access from ISV application Hi, What is your main concern That a port is opened in the firewall for sqlbrowser.exe If so, then be aware that you can close he port, disable SQL Server Browser and still be able to connect to the database. SQL Server Browser is not used to facilitate SQL Auth connections. Rather it provides endpoint information, like TCP/IP port number, pipe name, etc., of a named instance to a client when trying to connect to the server. Specifically, when the server is specified as "server\instance". If you specify the port or named pipe name in the connection string, e.g., "server,port" then the client does not need to contact SQL Browser. Check out this link for more info about SQL Sever Browser: http://msdn2.microsoft.com/en-us/library/ms181087.aspx Il-Sung. Tag: Merge Replication (Push) over Internet
  - 2
    - SQL server 2000 move They are both the same edition. both SQL server 2000 w/sp4. in fact they were both installed from the same orig. CD. Jason Tag: Merge Replication (Push) over Internet
  - 3
    - Using CTE in data paging You can do below instead: with names(row_num, first_name, last_name) as ( select row_num = row_number() over(order by last_name, first_name), first_name, last_name from contacts where last_name like 's%' and first_name like 'm%' ) select row_num, first_name, last_name from names where row_num between 41 and 60 -- 3rd page order by row_num; select @@ROWCOUNT go But this is really unnecessary. Why can't you get the count on the client side after you fetch the results This is more efficient than sending one more result from the server. CTE can be referenced (one or more times) only in one query and statement. Tag: Merge Replication (Push) over Internet
  - 4
    - Aggregating records and displaying Hi Arnie, Could be, I did not test the statement. I am using function STR to convert the result number to string. case when sum_m > sum_f then 'M(' when sum_m < sum_f then 'F(' else 'MF(' end + str( ( case when sum_m >= sum_f then sum_m when sum_m < sum_f then sum_f end * 100.00) / nullif(cnt, 0 ) , 5, 2) + ')' AMB Tag: Merge Replication (Push) over Internet
  - 5
    - Cannot connect to SQL Server with PHP Sorry to repeat this question, but the answer I received before, to "reboot everything" was no help. To reiterate: " I installed Windows Server Service Pack 2 on my Windows 2003 server last night, and now my PHP application can longer connect to SQL Server running on this machine. Specifically, the PHP command mssql_connect("servername", "username", "password") returns the following error: Warning : mssql_connect() [ function.mssql-connect ]: Unable to connect to server: [servername] I have an instance of SQL Server running on a similar machine, an it connects just fine. I've tried using the IP address instead of the server name, and I've tried invcluding the port number, but nothing works. Has Win2003 SP2 broken PHP What else could be going on Nothing else has changed on this machine but SP2 and various other updates that I installed last night. " A couple of other things have come to my attention as well. I have IIS running on a different Win2003 server that has NOT had SP2 installed on it, and that is running PHP, and it can open the database on my original server with no problems. SP2 broke something in PHP on my original server. Also, very strangely, I hav a couple of PHP scripts on my original server that other sites submit forms to, which open the database and enter records into tables. These script are apparently working fine as a number of records have been added to the DB today. Tag: Merge Replication (Push) over Internet
  - 6
    - Changing the default database files path fails <P align=left><FONT face=Arial size=2>1) Some commands cannot be used within a transaction, but the problem in your case is that the database seems to be in use during the dropping action, see the blog post on my site for more information about that:<BR><BR>2) local one<BR><BR>3) DId not see anything for that, SMO tell that this functionality is deprecated in further versions.</FONT></P> <P align=left> </P> <P align=left>4) Which values do you mean Some are coded in the SMO library, some are taken from the db system.</P> <P dir=ltr style="MARGIN-RIGHT: 0px" align=left><BR><BR>Jens K. Suessmeyer<BR><BR>---<BR><A href="http://www.sqlserver2005.de">http://www.sqlserver2005.de</A><BR>---</P> Tag: Merge Replication (Push) over Internet
  - 7
    - Will FTP and File System Tasks run in Workgroup Edition? The error message is: The task "Get CMP File - FTP Task" cannot run on this edition of Integration Services. It requires a higher level edition. Tag: Merge Replication (Push) over Internet
  - 8
    - Store Membership information using Access .mdb database Try this one it is better than the one you used, if you still get errors then post the code conversion issue on both VB and C# forums other user can help you with the conversion. http://www.carlosag.net/Tools/CodeTranslator/Default.aspx Tag: Merge Replication (Push) over Internet
  - 9
    - SQL 2005 Server DDL Trigger Errors Jigar Lakhani wrote: Hi Brian, I am also looking at SQL Server auditing currently for our infrastructure. Would you be willing to share your DDL trigger code with me thanks Hi, Jigar! The code above (in the post marked as Answer) is the exact DDL trigger code that I use. If you want, I can send the script file (with the indentation), but you can just copy and paste the code in this thread. Is there something else that you need Brian Tag: Merge Replication (Push) over Internet
  - 10
    - Merge Join - Output of Lookup as sorted field? Lindsay wrote: In the merge join transformation, it will join on the originally specified join keys, which would be incorrect for me. So I'm not sure how this would be correct Where's the merge join Before or after the lookup Tag: Merge Replication (Push) over Internet
  - 11
    - Failing Execute SQL Task Lindsay wrote: Jamie, thanks for the quick response. Here are the datatypes in SSIS for the variables: ParentExecution_Idx Int32 Batch_Idx Int32 PackageName String PackageID String TargetTable String ContainerStartTime DateTime DataFilePattern Str My best guess is the value that you are tryig to supply to the UNIQUEIDENTIFIER parameter. Try changing that to something else and see if it works. Sorry i can't be of more help. -Jamie Tag: Merge Replication (Push) over Internet
  - 12
    - Null Values Is the field a date field Tag: Merge Replication (Push) over Internet
  - 13
    - Management Studio Express "Save Results As..." CSV Encoding That's not the worst of it. The worst thing about their CSV export is that if you happen to export a CSV file that has a field which includes commas, it *WILL NOT TEXT QUALIFY* your output! WTF ! So every time you see "Smith, John" in your database, if you export that datum to a CSV (in ANSI format, Unicode doesn't seem to work when you load it into Excel), you see two columns -- one for "Smith" and one for "John". I sit here in stunned disbelief. Tag: Merge Replication (Push) over Internet
  - 14
    - Connecting to a SQLServerCE database through vbscript Is it possible to talk to a SQLServerCE database from a vbs script If so, does anyone have an example Thanks, Mike Tag: Merge Replication (Push) over Internet
  - 15
    - How to convert SLQ Server Express Database File to SQL Compact Edition File? well ... thanks for your help, I will try it out Bombie Tag: Merge Replication (Push) over Internet
  - 16
    - No Report Manager When I enter http:\\localhost\Reports I get the following error message: The report server is not responding. Verify that the report server is running and can be accessed from this computer. The service is running. I have uninstalled/reinstalled SQL server and visual studio. I can't seem to be able to get to a report manager. Is there a way to recreate the proper links Tag: Merge Replication (Push) over Internet

PNM

Hi all,

I was wondering if someone could suggest a solution to my problem:

I have an in-house production database. I wanted to use Merge replication (push) to mirror parts of this data to our Internet server on the web which has a Public IP.

Steps I followed

1. Created an entry in “C:\WINNT\system32\drivers\etc\hosts” file with IP
address of the Subscriber and just the “Servername” of the Subscriber on
publisher machine (local server)

2. Created an Alias to the Subscriber

3. Connected to the remote server thru Mgt Studio

4. Created Merge Replication on the Local Database

5. Created Subscription to the remote server.

6. Started the Replication Agent

I receive following msg "The process could not connect to Subscriber 'ISVR'.

When I check the View Synchronization Status in Mgt studio it shows "The server 'ISVR' is not a Subscriber"

I presume that if we have a Public IP at our end, then the Merge Replication will be thru.

Is it possible to replicate without having a Public IP

Any suggestions,

Thanks.

Re: Merge Replication (Push) over Internet

Hilary Cotter

can you register this subscriber in SSMS This is your acid test of connectivity between the two servers. The subscriber will need port 1433 open on its firewall.

Re: Merge Replication (Push) over Internet

PNM

Hi Hilary,

Yes, I am able to register this subscriber in SSMS. As I mentioned earlier, I am able to connect to the remote server using SSMS and also sucessfully created push subscription. Only when merge agent is started, agent is not able to connect to the remote server.

My remote server is running on port 5443 and it is open on its firewall.

Will it make any difference to the Merge Agent

Thanks

PNM