"You need to understand transactions and isolation levels and how this all works"

Yes, that's true. In fact I do have a basic understanding of transactions and isolation levels (i.e....

To put it another way, if my "web order update" job is executing Updates, how can I prevent the front end app from hanging up when the user inserts new orders...

Somehow I just ended up solving the windows user problem. I added repl_distribution user to the Admin group in Windows (probably not a good idea).

Now that I can make the sql 2005 connection to my subscrip server, I have a new problem. It fails to create the subscription, claiming that the Win user id...

Sql 2005 Surface Configuration Tool !!! The remote connection was disabled in here !

Thanks to Rick Strohl's post at http://www.west-wind.com/WebLog/ShowPost.aspx?id=4493

Thanks again for the input, folks.

Bob

SSMS, meaning the Sql Mgmt Studio ? Yes, I absolutely can connect to my subscriber machine. I can get to the Sql Studio via the "sa" id and create databases...

H,

 Would you mind answering me a question ? I have a 2005 publication, but I'm having trouble creating the subscriber on my target server (also sql 2005). It fails to...

Wow. Now why didn't I think of that ?

It worked out just fine.

Thank you,

Bob

After re-registering for the download, it provided the option to download the x86 version. I think I'm all set to test it on my laptop now.

I'm actually looking to test...

There's appears to be a 32bit version of sql 2005 according to : http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

System Requirements

Thanks. I'll go with the trial version.

For the first suggestion, I would need more specific steps.

For the second suggestion, when I try and update the srvname column of sysservers I get :

Server: Msg 259, Level 16, State...

I tried the first suggestion, but named pipes is already enabled.

On the 2nd suggestion, I noticed that in master..sysservers my server 'TMS_SERVER' is NOT listed ! The server that...

Disk space looks fine.

I already made TMS_SERVER\Replication part of the Admin group on my Win 2k server. Is that the user you're referring to ?

Do I need to add "distributor_admin"...

Thanks Dinakar. I created admin user "Replication" on the Win 2k server ("tms_server"), then created the  user in Enterprise Manager as "TMS_SERVER\Replication". I was then able to get past the initial user...