Jim Lawrence
accessd at shaw.ca
Sun Aug 27 11:08:30 CDT 2006
Hi John: 1. Would you have an IIS server running on both computers? 2. Are both MS SQLs using different ports (1433 default)? 3. The 'guest' account is turned off by default on new installs; would this be the case on the new computer? 4. Do you have a personal firewall setup on either/both computers that may be blocking the MS SQL ports? HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Sunday, August 27, 2006 6:38 AM To: dba-sqlserver at databaseadvisors.com Cc: 'Access Developers discussion and problem solving' 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