Bill Patten
bill_Patten at earthlink.net
Sun Aug 27 11:17:48 CDT 2006
John, Sounds like a domain issue to me, is one of the machines a domain controller?? If so have you logged the other into the domain? A work around, assuming you can get to the hard drive of one from the other, would be to use enterprise manager, detach the desired databases, copy them to the desired machine and re attach. Bill ----- Original Message ----- From: "JWColby" <jwcolby at colbyconsulting.com> To: <dba-sqlserver at databaseadvisors.com> Cc: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Sunday, August 27, 2006 6:38 AM Subject: [AccessD] Transferring a database to another SQL Server I have just finished rebuilding a machine (new motherboard) and need to transfer a large SQL Server database to that new server. The two servers can see each other (shared folders), but ... I cannot register the other SQL Servers, getting an error "Login failed for 'MachineName\Guest'. I get this error on either machine when trying to register the SQL Server on the other machine. My login user / password is the same on both machines. Both databases were installed using "Windows Authentication" rather than "SQL Server Authentication". Any ideas? John W. Colby Colby Consulting www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com