Re: Backing up SQL Server problem

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 19:53:08 +0100

Are you trying to move local logins to the remote server? 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Mark" <anonymous@devdex.com> wrote in message
news:O9UwGUzjEHA.2692@TK2MSFTNGP12.phx.gbl...
> Hi - I am having a problem backing up my database on my host, onto my
> local instal of SQL Server 2000.
>
> I am using Enterprise Manager/DTS:
>
> I use "Copy objects and data between SQL Server databases"
> And on the next page I activate:
> Create destination objects + all 3 sub options
> + copy data
> + copy all object
> + use default options
>
> I am using SQL Authentication on both the remote, and local screens.
>
> It gets so far (and creates the tables structures), but then stalls
> before copying data:
>
> When I double click on the Executing Package/Status line it says:
>
> "[Microsoft][ODBC SQL Server Driver][SQL Server] The login
> 'myusernameforsqlserver' does not exist"
>
> 'myusernameforsqlserver' does exist on the remote server - what I can't
> figure out is why it is not recognising it - that is the username I use
> to log on to the remote database and to create my tables and SPs.  My
> host is baffled too.
>
> Can anyone suggest what may be going wrong?
>
> Thanks,
>
> Mark
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • 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)
  • 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: 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: Exporting data to another server
    ... the only valid login is LynxServer. ... everything up to the remote server by copying the SQLs ... >source and destination SQL Server to export data. ... If you want use the domain account, ...
    (microsoft.public.sqlserver.security)
  • RE: display all data in a long text column
    ... point in Query Analyzer, change the execute mode to "Results in Text". ... Once I am attached to the remote server, ... > some sql server tool report the data, ...
    (microsoft.public.sqlserver.programming)