Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amith
Starting Member
3 Posts |
 Posted - 2007-08-10 : 09:35:08
|
| Hi, I am newbie in replication, I have a requirement where need to set upo replication with db such as both dbs are in different domain. I have created a merge publication with create pulblisher wizard.I want to use FTP as default location for the snapshot so that from both the domain database can accesss this path and subscriber will take the snapshot from it.Issue facing like to run the snapshot agent we need to provide windows domain user or machine user but we can't add this user in FTP machine as domain is differnt will not get access on this machine. I am getting following error:Message: The replication agent failed to create the directory '\\192.168.7.57\ftproot\unc\PARAG-TEST_NORTHWINDSUB_PARAG_PUB\20070810185320\'.Stack: at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory) at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders() at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.CreateSnapshotFolders() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot() at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun() at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQL_REPL, Error number: MSSQL_REPL52026)Get help: http://help/MSSQL_REPL52026Source: mscorlibTarget Site: Void WinIOError(Int32, System.String)Message: Logon failure: unknown user name or bad password.Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity) at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity) at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory) (Source: mscorlib, Error number: 0)Any help regarding this is appreciable. Please can put more light on it if I am doing anything wrong.Thanks & RegardsAmit Harhare |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-11 : 01:12:32
|
| Possible to trust those domains? |
 |
|
|
Amith
Starting Member
3 Posts |
Posted - 2007-08-13 : 04:34:47
|
quote:
Originally posted by rmiao
Possible to trust those domains?
No we cannot trust the domains--Amith |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-13 : 22:24:29
|
| Then nothing you can do. |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2007-08-15 : 15:53:05
|
| You can replicate between non-trusted domains. Microsoft has a document on this. Make sure you have an administrative account on both severs with the same name & password. You may need to use a push subscription. I've not done merge replication, but I have it working from snapshot & transactional |
|
|
|
Amith
Starting Member
3 Posts |
Posted - 2007-11-13 : 06:08:42
|
| Hi Guys, we have found a workaround for this problem, We dropped the idea to use replication provided by MS SQL server. We wrote a script to take the replica of the database in text file (CSV) and created a shared location on a PC where we have stored all this file.To share this files across the internet we used FolderShare application (www.foldershare.com) which is now owned by Microsoft. This application shared the Folders across the internet so domain dependecy get removed. This application have facility to sync the shared folder accross internet. We wrote a scheduled task to put these text file into another database.Thus the mystry solved without hampering of security.Thanks to Foldershare.comThanks & RegardsAmit Harhare |
|
|
|
|
|
|
|
|
Isssue with Repllication accross domains and Inter