I am trying to connect using a development user that has the same windows permissions as the user.

I am creating the DSN from scratch (as it does not exist on...

Hi Thanks for the reply

I cannot rebuild the dsn because I am unable to create it in the first place as I cannot connect to the server to setup the...

Hi

Thanks for the replies

I may have been a bit vague ...

I have dropped the Logon and User from the database and have recreated them with the same results as before.

When...

Thanks for the replies

The database has not been dropped and recreated

I cannot connect (as the user) from QA as this also gives the same error

sp_helpdb gides the following

======================

Database  LDF_Consult

db_size    277.69...

Thanks for the reply

The Database is in working order & has other users connected.

I cannot connect as the user with EM as I get the "Cannot open User Default Database. ...

Thanks for the reply

I have checked the database and yes they are the same

db user                           Login

Horsham1\LDC_Reports     Horsham1\LDC_Reports

Regards

Andy

Have you tried looking at Big Brother??

http://www.bb4.org/

It should do a lot of the things that you require & it is FREE!!

There are many scripts that you can add...

Cheers

I have not tried anything for a few days. I will look at the issue in some more detail...

The question still remains as to how often the application is scheduled...

Strange that the Performance Collector needs to run under a profile set up for US Dates.... I will try this when I get A Moment

This is an extract from the...

OK Now things are becoming clearer

SQLH2 is not real time monitoring as the performance files are not added to the database. (not a problem)

D:\SQLH2\Sqlh2 /DDMY is scheduled to upload the Perf...

Did you look at KB artivle 164667 Replication over a firewall

this article covers everything required to get you going..

It is best to use similar port no's to those in the...

The replication for R_IPS:IPS was merge replication.

The items that I want to remove are the entries in the replication monitor tree for the R_IPS:IPS replication.

as the original databases no longer...

OOPS

I missed off a bit of the message ...

The errors are showing in the replication monitor as publishers and agents with a red cross against them

They are available for SQLCE to query the local SQL CE DB's

try http://www.resco-net.com/developer/queryanalyzer/

if you want to query the SQL Server then why not use Terminal services

Regards

Andy

Jon

look at the following MSDN article

http://support.microsoft.com/default.aspx?scid=kb;en-us;164667

which I have used to set up replication through the firewall to the DMZ

Regards

Andoi