I assume you have enough permissions on both machines. Try adding ports 445 and 139. Also please add Query analyzer to the exception list.

Any results? Run Debugging while Firewall is off... and netstat -an > netstat.txt

You have to "... see which ports are open between the Client machine and the Remote Server machine". Ping Client and Remote machine. See which ports are open between...

Actually you are right. I have Window 2000 and SQL Server SP3A on a remote server (debugging from XP SP2), that's why I got hotfix 944 from MS...

So did you apply hotfix 944 as I suggested earlier? Try to turn off Firewall after that. Let us know.

Apply SQL Hotfix 944 on Server.

Turn off your Firewall. Or add exception (add ports) to it which are related to your machine/remote machine using Stored Proc.

Also in the...

I would suggest you to run DBCC showcontig with tableresults every wknd. For indexex, say with scan density over 75-90, you run Reindex. That way you always know...

See if it works:

Apply SQL Hotfix 944 on Server. If client doesnt have SP4 installed, install hotfix 944 too.

Turn off your Firewall. Or add exception (add ports) to it which...

Apply SQL Hotfix 944 on Server.

Turn off your Firewall. Or add exception (add ports) to it which are related to your machine/remote machine using Stored Proc.

Also in the Firewall...

You might want to implement the following to perform a standard backup:

Create a table in master DB

with Database names, properties (such as  status column: suspect, offline etc)

Loop thru all...

You might want to try SQLLiteSpeed which stores backups compressed.

can you paste it in QA and then execute it....

If you have Active Directory ( besides assigning job ownership to 'sa'), check if that server is up and running. Might need to restart it...

my 2 cents

Yes, you can. We use logshipping for reporting and DR purposes.

We restore logs from 5pm thru 4am and from 4am thru 5pm we run various reports. On wknd...

can it be something like:

if exists (select * from TEMPDB.dbo.sysobjects where id = object_id(N'[TEMPDB].[dbo].[#tempseverityerrorlog]'))

drop table [#tempseverityerrorlog]

create table #tempseverityerrorlog (lineid int identity(1,1),line varchar(500),ContinuationRow int)

insert #tempseverityerrorlog exec master.dbo.xp_readerrorlog

select * from...