I have also made the local account part of the local administrators group and I will can't connect via BDE.

This is really starting to bother me, it shouldn't...

SQL Server is set to 'SQL Server and Windows' authentication.

Also, I just re-tested the ODBC connection and that works fine. It is just the BDE that won't connect. ...

Even if I'm trying to use a SQL Authenticated login.

This doesn't make sense to me.

This is the syntax that I use to attach a DB with only a MDF file:

Exec sp_attach_single_file_db DB_Name, 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\DB_Name_Data.MDF'

Just change the highlighted portions. 

Matt

Maybe I was too tired last week or what, but that script appears to be working fine this morning. I'll go ahead and put it into a test environment...

That's just it. I have never gotten an error during this process. But the data in the two databases do not match. The security log even says...

Yes, please post it.

I took the following out of BOL (didn't read down enough before), but it still isn't working.

USE master

BACKUP DATABASE DB1

TO DISK = 'c:\Program Files\Microsoft...

The device only contains a backup of DB1. And DB1 is not being restored. I tested this by running the backup, changing data, and then doing the restore....

Thanks guys! 

That is what I thought, but I wanted to run it by someone else as well. 

Is e: a drive on your system or is it a drive on the server.  You can only backup and restore to drives that are considered 'local' by the SQL...

What about using the Copy Database Wizard via Enterprise Manager.  MSSQLSERVER needs to run with a domain acct, local sys admin will not work.  This can be accessed via Enterprise...

like Karl said, make sure that the Windows NT User (or group that the user is in) is setup with a Login and then make sure that the login has...