Mark Rider
ridermark at gmail.com
Sun Aug 27 09:36:59 CDT 2006
I'm not sure about the login issue, but a good way to transfer the DB is to Detach it on the old server, copy the MDF and LDF files to the new server and then attach it. This will preserve all of the data, and has worked for me several times. On 8/27/06, JWColby <jwcolby at colbyconsulting.com> wrote: > 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 > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- Mark Rider http://commonsensesecurity.info There are 10 kinds of people in the world: Those who understand binary and those who don't.