RE: enterprise manager no longer connects to remote database

Mike
this is what i don't understand, the default database in the remote server
login
'MyRemoteID' is 'MyremoteDB' and the database 'nhmforum01' is not an option

regards Earnie

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> Get onto the remote server and for the login, change the default database.
>
> Enterprise Manager > YourServer > Security > Login
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
>
>
> "Earnie" wrote:
>
> > 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: Updating remote MySQL databases
    ... than over Internet directly to the database. ... > I want to maintain with the WinForms program. ... > remote server, that would probably be done with PHP or whatever. ... > the appropriate dialect down the TCP/IP connection from my local PC to ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: enterprise manager no longer connects to remote database
    ... Get onto the remote server and for the login, change the default database. ... Mike Epprecht, Microsoft SQL Server MVP ... Fasthosts technical support advise me to reload SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to remote SQL Server
    ... There is a SQL Server database on that server. ... > My main development environment is Dreamweaver MX2004. ... User XXX has a login on the remote server, but does not have a user in the ...
    (microsoft.public.sqlserver.server)
  • Re: need ideas on multi threaded db update
    ... The remote server returns the code number to be put in ... a local cache (Array/ArrayList/whatever else might be appropriate) so you ... don't have to query the remote server so much. ... Are you using one database to update another database on a different ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Accessing .mdb data from a remote computer on a non asp application
    ... Is your "remote server" on your LAN? ... Open your database in Design View, and from the Database Window, Tools | ... Microsoft Access MVP ... a valid file name" and after looking in the error details I saw that c: ...
    (comp.databases.ms-access)