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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 xp pro settings to work with replication

Author  Topic 

suckablesausage
Starting Member

4 Posts

Posted - 2006-12-23 : 16:07:35
hi guys :( ive searched on all the topics here about replication. but now i am wondering what windows xp settings do i have to edit? i read something about dcom settings and changing permissions. what is the RIGHT way to share a file or whatever because the schema cannot be accessed for some reason. i need a whole list of things to do because things are not working out after i read the tutorials on other sites. please someone help me.

basically i need to have two servers that need to be replicating each other. i realized that the instances have to be named so i am just totally confused. ill even let anyone connect remotely to help me out if they want. or explaining will do fine. please! thanks guys!
happy holidays!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-23 : 16:21:15
You don't have to touch DCOM or anything else for that matter to get replication setup. The only thing you have to do is configure replication using scripts or Enterprise Manager (EM being the easiest).

Which version of SQL Server are you using and what edition of it?

And the instances do not have to be named instances, they can be default instances.

What do you mean that the schema can't be accessed? What is it that you've done so far? Any errors?

Tara Kizer
Go to Top of Page

suckablesausage
Starting Member

4 Posts

Posted - 2006-12-23 : 18:07:27
i dont know the exact error because i cant check. the remote pc im trying to replicate with isnt online. it says something like "unable to upload or update the schema file"

ill get back to you on that one :( i can pay you ms tara. im very sad :(

jirehlubrin@gmail.com
AIM: suckablesausage
Go to Top of Page

suckablesausage
Starting Member

4 Posts

Posted - 2006-12-23 : 18:11:23
oh yeah im using sql 2000. and running under xp. heehee
Go to Top of Page
   

- Advertisement -