Transfer Database using Access Project -- sql server clients

Mark Mather
12/16/2004 2:09:03 AM

Hi everyone

I'm trying to transfer an SQL Database using an Access Project. Its Access
2003 running 2000 file format. The ADP file I have open is connected to a
SQL Server on a remote machine. I'm transferring from the remote server to
my local server. Both are MSDE.

The process seems to start and copy table definitions (scripts, stored
procedures) etc but then hits this error before it copies any of the data:

[Microsoft][ODBC SQL Server Driver][SQL Server] The login 'SQLGuests' does
not exist.

Then it tells me that the destination database is in an unknown state and
asks whether I want to Keep or Delete.

Any ideas? Do I need to create guest accounts or something? If so how do I
do it using osql? I don't have any of the SQL Enterprise tools.

Thanks in advance,

Andrew J. Kelly
12/16/2004 9:29:08 AM

I know nothing of the Access transfer process but why not simply detach and
attach? Maybe these will help:

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server clients : Transfer Database using Access Project