Haslett, Andrew
andrew.haslett at ilc.gov.au
Sun Aug 27 17:42:36 CDT 2006
Ie - I meant the Login rights of your account in SQL Server. You'll need to give your Windows account login permissions to the SQL Server and to your database. You won't be able to log into your box from another machine using Windows Auth unless you're using a domain. Much easier to just setup SQL Authentication and specify a username and password. Also, might pay to remove and re-add DB-Level permissions as even though they may be the same as the old box, they don't automatically map to the SQL login. Search Books-On-Line for a stored proc called sp_change_users_login, although from memory, this was for SQL logins, not Integrated Auth logins. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Haslett, Andrew Sent: Monday, 28 August 2006 6:34 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server Have you setup security on the new box? -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Sunday, 27 August 2006 11:08 PM To: dba-sqlserver at databaseadvisors.com Cc: 'Access Developers discussion and problem solving' Subject: [dba-SQLServer] 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ *** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ *** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.