RE: enterprise manager no longer connects to remote database

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

  • SQL CE Setup 101... C#
    ... "The remote server does not exist or has not been designated as a valid ... along with "Initializing SQL Server Reconciler has failed. ... // Create the Local SSCE Database subscription. ... IncontrolNew is the database the ip address is the ip addy to the ...
    (microsoft.public.sqlserver.ce)
  • Re: Backing up SQL Server problem
    ... Are you trying to move local logins to the remote server? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > 'myusernameforsqlserver' does exist on the remote server - what I can't ... > to log on to the remote database and to create my tables and SPs. ...
    (microsoft.public.sqlserver.dts)
  • 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
    ... 'MyRemoteID' is 'MyremoteDB' and the database 'nhmforum01' is not an option ... "Mike Epprecht " wrote: ... > Get onto the remote server and for the login, ...
    (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)