[dba-SQLServer] Transferring a database to another SQL Server

JWColby jwcolby at colbyconsulting.com
Sun Aug 27 08:38:15 CDT 2006


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





More information about the dba-SQLServer mailing list