enterprise manager no longer connects to remote database

Hi
I am developing a database, 'MylocalDB' which i DTS transfer within
Enterprise Manager to a Fasthosts remote server 'MyRemoteDB', using SQL
security with ID 'MyRemoteID' and PW 'MyRemotePW'
I am no longer able to DTS getting the message 'MyRemoteID' is not a valid
user for database 'nhmforum01'. I do not recognise this database and it does
not appear in the group on the remote server
i have create a new remote database with Fasthosts and I can DTS to this
without problem. Fasthosts technical support advise me to reload SQL Server
2000 but I am reluctant because the setting up might prove a further
complication - Help

.

Relevant Pages

  • Re: Importing From an Access DB Secured with a Workgroup Information File
    ... > In the DTS designer there is an Access icon to use. ... > How can I dynamically set the Access System Database ... > source as Microsoft Access,choose the file path of the .mdb file, provide ... >> secured with a unique Workgroup file (as described in the Access ...
    (microsoft.public.sqlserver.dts)
  • Re: Audit of sql server
    ... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Advice sought on use of DTS [Long]
    ... I've used DTS for simple tasks for years, ... data from one database to another. ... In my scratch database I keep a mapping of all records I've previously ... Can you programmatically tell a DTS package which databases to update? ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie need help with DTS, null value error.
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... "Temjin" wrote in message ... > restore my database. ...
    (microsoft.public.sqlserver.dts)
  • DTS Database Transfer Problem
    ... We're backing up our database by using DTS to transfer it to another server. ... The DTS package is very simple, it consists of one 'Copy SQL Server Objects' ... that there's no consistency to exactly which constraint ...
    (microsoft.public.sqlserver.dts)