[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL SERVER 2008 REPLICATION

Posted on 2009-04-16
9
Medium Priority
?
161 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:js_0505
  • 5
  • 4
9 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 24157524
the machines can ping each other, right?
0
 

Author Comment

by:js_0505
ID: 24157655
Yes they can with out any problems.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24157850
What kind of rights do the accounts that run the MSSQLServer service and the SQLAgent service have?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:js_0505
ID: 24157945
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
 
LVL 60

Expert Comment

by:chapmandew
ID: 24157968
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
 

Author Comment

by:js_0505
ID: 24158082
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
 
LVL 60

Expert Comment

by:chapmandew
ID: 24158102
it might be just listed as SQL Server...depending on your OS....
0
 

Author Comment

by:js_0505
ID: 24158213
SQL Server or SQL Server Agent?
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 24158254
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question