BerggreenDK's questions

I'm been trying to get an old 32-bit service (.dll) of ours to run on a Windows 2008 (R1 and R2).

The service accesses a system-DNS for ODBC connection and secondly it performs some statistic HTTP calls with a normal WebClient request (sort of a PING function that reports data back to our service for statistics).

The only interface we have to see if this is running, is to see if the SQL spool/records changes with "LastUpdate" and from this I can conclude that "something" isnt working.

The service has been running smoothly for almost 8 years on Windows 2000 and Windows 2003 servers.

Now, as we are moving old servers into the cloud, I am trying to see if we can get this old friend to work too.

Somehow it doenst work. I've tried to look in windows-logs, checking for any sign of errors. But none found.

My guess would be that it just lacks some "rights" as Windows 2008 is more closed/secured.

Therefore I've also tried to make a "special user account" for this service only, and allowed the service to logon as account with access to desktop.

Currently I dont care how low security we have to make, as NOTHING works for me. I am testing this on a none-production server, so there is no problem with security - yet.

Does anyone have ANY clue of what I need to do?

What type of security rights, settings or policy am I missing?

I've been checking the threads about "32-bit on 64-bit" etc. no luck finding anything so far :-(

I'm lost...

IS the only way to get it running, to install and keep and old windows 2003 server in the cloud.. sigh ???

I seem to have big difficulties setting up the first replication ever between two SQL2000 instances.

They both run in seperate WAN's (IP with port assigned for SQL-remote) but I have been able to connection them through remote-SQL so they appear in Enterprise Manager in both places.

I cant figure out how to do this correctly, as I have tried many different approaches and got a lot of errors trying to do it.

I dont know if its a faulty installation (with SP4) or some rights I need to ajust or what I am trying to do isnt possible.

My idea is to take the primary server (lets call it MASTER or #5) and then PUBLISH some of its databases with replication to the secondary/backup server (lets call it SLAVE or #4)

I've added a "sync account login" on both, with same name and password to see if that would make things easier. I have FULL administrative access, so any needed changes can be made to this setup - as long as I get it fixed soon. (Have been starting to consider leaving SQL-server completely if this has to take so long time to fix, and check out MySQL or something else)...

BUT... to the current task/situation:

We have two servers, one in production and one in development, and I would REALLY like to have changes MERGE between these two "single instances". There is NO ActiveDirectory mechanism near them, so they are 100% stand-alone machines.

When I try to configure the master as "Distributor/Publisher" the Wizard halts with error of something being "(null)" ??? I get some weird error codes that tells me nothing usefull.

So I was wondering, is there a "guided tour" somewhere on HOW to do this in the right order, so that I can check if I have missed something before trying to set it up. Some rights, some flags, some patches or extra firewall ports or something weird needed for replication.

It looks so easy in every example I have found so far, but it just doesnt work ...

HELP!... please :-)