SQL SERVER 2008 REPLICATION

Okay I am at a loss.  I know nothing is impossible but I can not figure it out.  I have a server in Florida that is not on a domain and is running SQL server 2005.  Remote access is fine.  I have a new server at my location that is on a Domain running SQl 2008.  I am trying to set up Transactional Replication but I keep getting different errors such as can not log on etc...I created a network share and that did not work as  well.  States it can not find folder.  I created the same user name and password on both machines.  Any help would be greatly appreciated.  Thank you.
js_0505Asked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
SQL Server...but you really need to look at the users on both.  Make sure they both run under domain accounts that have rights on both servers.
0
 
chapmandewCommented:
the machines can ping each other, right?
0
 
js_0505Author Commented:
Yes they can with out any problems.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
chapmandewCommented:
What kind of rights do the accounts that run the MSSQLServer service and the SQLAgent service have?
0
 
js_0505Author Commented:
Well that might be one thing, how do i check the rights for SQL Agent?  Well I think i might have found it, the log on is set to the standard NT user.  I can change that to use the userid I want to correct?
0
 
chapmandewCommented:
sure, you can change it.  it is listed under services.  Change it do a domain account that has rights on both machines...should clear your problems right up.
0
 
js_0505Author Commented:
I went to the control panel and i saw the service for SQL Agent and can change the user information, but i do not see MSSQLServer service.
0
 
chapmandewCommented:
it might be just listed as SQL Server...depending on your OS....
0
 
js_0505Author Commented:
SQL Server or SQL Server Agent?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.