does the user account for sqlserver have access on the production server?

If it can't access the info the job would fail.

Are both servers set up using domain accounts, or local...

Hey there,

You mention you have ADSL.

Does your provider use PPPOE?

If so, then your connection might be closing out every so often.

PPPOE disconnects after a while requiring you to re-connect the...

Hm,

I'd talk to your admin who takes care of the firewall.

See if he can provide a static external IP that maps to your internal IP.

If he/she can do that for...

Hi there,

I think the only way to do this is save to save the table with the dbo prefix.

We've had this problem here.

One of the developers here keeps forgetting to...

Contact the admin and see if he can assign a different port for you to connect through.

You might mention Steve's idea too.

If they are set up for VPN's he could...

Hey there,

We're currently running 4 SQL 2000 Servers all with McAfee Virus Scan for Win2K Server.

No performance issues here at all.

Smooth sailing.

That's just my experience, I've never had any troubles...

Hey bkelley,

I haven't registered either of the servers to AD.

I do want to thank your for the information though.

Here's a pic of the message box just in case you think...

Nope, I'm not trying to add it, and it doesn't appear to be registering successfully either.

Under the properties of the server, under the "AD" tab, it hasn't been added.

I didn't...

Hi again,

The MSSQLServerADHelper is set to run as the local system account.

It is not started on either server, and is set to manual startup.

We are in an AD domain, the...

Hey bkelley,

I fixed the error message about port 1433 by reinstalling the SP3 while logged in as the service account.

The warning messge that I still receive is an 8344...