Hi David

well i seemed to have progressed on it seems like it was a issue with alias on the local and remote sql but i seem to be having problems with permissions now.

I have setup the subsciption etc on the remote sql which was fine but I notice that it wasnt syncing the tables so i clicked on view sync status and it displays

the process could not connect to the distributer

the agent could not be started

when i google this message it seems like it is a permission problem but know on the servsql it will only run the server agent on local system and not on the domain admin account which is strange as it was working fine.

i have looked at the properties of the distrubuter on the subcription and made sure that the snapshot folder is unc etc and tried changing the connection permissions to the sql sa username and the domain user account but still nothing