Setup SQL Server replication

Mr_Ezi
Mr_Ezi used Ask the Experts™
on
I want to setup a way to sync a compect sql file with a regular sql server, I tried the wizard but I keep on getting the same error:
"SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'PC2\SQL_2005'. (Replication.Utilities)"

in fact I do use the local name I'm not connecting via a ip.

on the other hand is there a better way to sync the databases? it looks like the setup will be very complicated with this.

Thanks
 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Máté FarkasDatabase Developer and Administrator

Commented:
You sould consider, the Compact Edition can be only subscriber (can not be a Publisher or Distributor).
You sould connect with the Management Studio Object Explorer via the name PC2\SQL_2005

Author

Commented:
Thanks I tried the PC2\SQL_2005 I got the same error.

Also I looks like its only available in the full version not in the express versions, that makes me think if there's a better way to do it?  
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
Thanks for the link's, the second one looks like something that could work but this reference is not avalible in a compact project, I tried a regular project and I do have this references in the list.

Is there a way to use this code in a mobile project?

Commented:
I don't know about in a mobile project

Author

Commented:
Ok, one more thing I forgot to mention is that I also want to be able to sync via a web service.

Author

Commented:
Ok, one more thing I forgot to mention is that I also want to be able to sync via a web service.

Commented:
You should ask that as a separate/related question

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial