replication

Question

I am trying to install 2 sql server 2000 in my pc for testing replication.whenever I go to replication folder and open the distribution and publication wizard,after a few steps ,I get the message that my sql server is using a local system account,so the replication between servers would fail.I opened the windows management console and created a user in administrator group.But the sql servers are unable to open with that account.What is the solution? How can I change the sql server user account?

Anonymous · Answer

You need to either use a Domain Account if you are using Windows authentication or you need to use SQL server authentication.
The reason for this is because the user account that you are using only exists on the machine that you are on not on the machine that you will be replicating to.

Related Topics:

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Ask a Question

Check Out the Mobile Browsers Report

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee

Grand Canyon Tech

Brad Brown

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Related Topics:

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Related Topics

Ask a Question

Popular Questions

How can open password protected microsoft word document.

Get message that "Setup cannot find Office.en-us\OfficeMUI.msi"

Hi i need micro soft visio 2010 product key

Microsoft Wireless Notebook Optical Mouse Model 1023

Dell Drivers XP drivers for vostro 1400 ..