Michael Maddison
michael at ddisolutions.com.au
Sun Aug 27 22:52:26 CDT 2006
Why is it trying to use Guest as opposed to using the current logged in user on the current machine (jwcolby)? Because it is expecting a domain user and then defaulting to guest when there is no domain user???<guess> I would try using SQL user logins (sa? or another sys admin acc) Set up a sa account on the target SQL server instance. Attach the target SQL instance to EM using sa (on the base (non target) instance) If that works you should be ok. cheers Michael M John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Sunday, August 27, 2006 4:45 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] [AccessD] Transferring a database to anotherSQLServer In that case, the simplest means is detach the db, copy it to a memory stick or something, then copy it to the data directory of the new machine, and finally attach it. This sidesteps the problem of why you cannot see each box from the other, but one thing at a time. Presumably the most important thing is to get the db there. Depending on the size of the MDF and LDF files, you may need to ZIP or RAR them first, then extract them upon arrival. If space on the stick or CD or DVD is really a problem, you could skip or truncate the Log file. hth. Arthur ----- Original Message ---- From: JWColby <jwcolby at colbyconsulting.com> To: dba-sqlserver at databaseadvisors.com Sent: Sunday, August 27, 2006 1:26:31 PM Subject: Re: [dba-SQLServer] [AccessD] Transferring a database to anotherSQL Server SQL Server 2K John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com